Control query generate in Entity Framework Core
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I have two databases one for testing and one for production for example database and database_test, I set the connection string to connect to database_test, I don't know, why when I try to access to any row of one table the query generated add the database production name for example database.TableName and in the other tables only generate a query with TableName without the databaseName. I try adding a schema in a table name in the model but always is adding the database name that it's the production name, instead of generate the queries without database name, why it's this behavior?
Update: sorry is EF Core 2.2 from mysql with pomelo, the connection string database is testing, the production database name is production. For example the next code
contexto.Table1
is translated in a query select * from production.Table1 instead of only translate in Select * from Table1
c# .net-core entity-framework-core
edited Jan 12 at 19:16
ekad
12.2k123742
asked Jan 4 at 0:13
abigail armijoabigail armijo
364
|
show 1 more comment
I have two databases one for testing and one for production for example database and database_test, I set the connection string to connect to database_test, I don't know, why when I try to access to any row of one table the query generated add the database production name for example database.TableName and in the other tables only generate a query with TableName without the databaseName. I try adding a schema in a table name in the model but always is adding the database name that it's the production name, instead of generate the queries without database name, why it's this behavior?
Update: sorry is EF Core 2.2 from mysql with pomelo, the connection string database is testing, the production database name is production. For example the next code
contexto.Table1
is translated in a query select * from production.Table1 instead of only translate in Select * from Table1
c# .net-core entity-framework-core
edited Jan 12 at 19:16
ekad
12.2k123742
asked Jan 4 at 0:13
abigail armijoabigail armijo
364
Unclear what you are asking, can you maybe give examples or be more concise?
– Michael Randall
Jan 4 at 0:16
Debug your code maybe some code exists that occur that particular problem.
– Vijunav Vastivch
Jan 4 at 0:23
Which provider are you using? Please provide source code other wise its like a magician who try to guess what is wrong.
– Volodymyr Bilyachat
Jan 4 at 0:27
sorry I edit the question
– abigail armijo
Jan 5 at 3:18
@abigailarmijo how do you generate the model is it "model.edmx"
– Mohamed Elrashid
Jan 5 at 3:45
|
show 1 more comment
I have two databases one for testing and one for production for example database and database_test, I set the connection string to connect to database_test, I don't know, why when I try to access to any row of one table the query generated add the database production name for example database.TableName and in the other tables only generate a query with TableName without the databaseName. I try adding a schema in a table name in the model but always is adding the database name that it's the production name, instead of generate the queries without database name, why it's this behavior?
Update: sorry is EF Core 2.2 from mysql with pomelo, the connection string database is testing, the production database name is production. For example the next code
contexto.Table1
is translated in a query select * from production.Table1 instead of only translate in Select * from Table1
c# .net-core entity-framework-core
edited Jan 12 at 19:16
ekad
12.2k123742
asked Jan 4 at 0:13
abigail armijoabigail armijo
364
I have two databases one for testing and one for production for example database and database_test, I set the connection string to connect to database_test, I don't know, why when I try to access to any row of one table the query generated add the database production name for example database.TableName and in the other tables only generate a query with TableName without the databaseName. I try adding a schema in a table name in the model but always is adding the database name that it's the production name, instead of generate the queries without database name, why it's this behavior?
Update: sorry is EF Core 2.2 from mysql with pomelo, the connection string database is testing, the production database name is production. For example the next code
contexto.Table1
is translated in a query select * from production.Table1 instead of only translate in Select * from Table1
c# .net-core entity-framework-core
c# .net-core entity-framework-core
edited Jan 12 at 19:16
ekad
12.2k123742
asked Jan 4 at 0:13
abigail armijoabigail armijo
364
edited Jan 12 at 19:16
ekad
12.2k123742
asked Jan 4 at 0:13
abigail armijoabigail armijo
364
edited Jan 12 at 19:16
ekad
12.2k123742
edited Jan 12 at 19:16
ekad
12.2k123742
edited Jan 12 at 19:16
ekad
12.2k123742
12.2k123742
asked Jan 4 at 0:13
abigail armijoabigail armijo
364
asked Jan 4 at 0:13
abigail armijoabigail armijo
364
asked Jan 4 at 0:13
abigail armijoabigail armijo
364
364
Unclear what you are asking, can you maybe give examples or be more concise?
– Michael Randall
Jan 4 at 0:16
Debug your code maybe some code exists that occur that particular problem.
– Vijunav Vastivch
Jan 4 at 0:23
Which provider are you using? Please provide source code other wise its like a magician who try to guess what is wrong.
– Volodymyr Bilyachat
Jan 4 at 0:27
sorry I edit the question
– abigail armijo
Jan 5 at 3:18
@abigailarmijo how do you generate the model is it "model.edmx"
– Mohamed Elrashid
Jan 5 at 3:45
|
show 1 more comment
Unclear what you are asking, can you maybe give examples or be more concise?
– Michael Randall
Jan 4 at 0:16
Debug your code maybe some code exists that occur that particular problem.
– Vijunav Vastivch
Jan 4 at 0:23
Which provider are you using? Please provide source code other wise its like a magician who try to guess what is wrong.
– Volodymyr Bilyachat
Jan 4 at 0:27
sorry I edit the question
– abigail armijo
Jan 5 at 3:18
@abigailarmijo how do you generate the model is it "model.edmx"
– Mohamed Elrashid
Jan 5 at 3:45
Unclear what you are asking, can you maybe give examples or be more concise?
– Michael Randall
Jan 4 at 0:16
Unclear what you are asking, can you maybe give examples or be more concise?
– Michael Randall
Jan 4 at 0:16
Debug your code maybe some code exists that occur that particular problem.
– Vijunav Vastivch
Jan 4 at 0:23
Debug your code maybe some code exists that occur that particular problem.
– Vijunav Vastivch
Jan 4 at 0:23
Which provider are you using? Please provide source code other wise its like a magician who try to guess what is wrong.
– Volodymyr Bilyachat
Jan 4 at 0:27
Which provider are you using? Please provide source code other wise its like a magician who try to guess what is wrong.
– Volodymyr Bilyachat
Jan 4 at 0:27
sorry I edit the question
– abigail armijo
Jan 5 at 3:18
sorry I edit the question
– abigail armijo
Jan 5 at 3:18
@abigailarmijo how do you generate the model is it "model.edmx"
– Mohamed Elrashid
Jan 5 at 3:45
@abigailarmijo how do you generate the model is it "model.edmx"
– Mohamed Elrashid
Jan 5 at 3:45
|
show 1 more comment
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54031561%2fcontrol-query-generate-in-entity-framework-core%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54031561%2fcontrol-query-generate-in-entity-framework-core%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Unclear what you are asking, can you maybe give examples or be more concise?
– Michael Randall
Jan 4 at 0:16
Debug your code maybe some code exists that occur that particular problem.
– Vijunav Vastivch
Jan 4 at 0:23
Which provider are you using? Please provide source code other wise its like a magician who try to guess what is wrong.
– Volodymyr Bilyachat
Jan 4 at 0:27
sorry I edit the question
– abigail armijo
Jan 5 at 3:18
@abigailarmijo how do you generate the model is it "model.edmx"
– Mohamed Elrashid
Jan 5 at 3:45