Yes it should be there but unfortunately it is not there.
And my application is still working with database. I want to know the exact location.
I don't know man. The machine seems to be a Quality Assurance, the QA as part of the machine name, staging machine on the Local Area Network (LAN). At best, you should be asking someone where you are located about the physical location of the computer.
If the machine is not there as you say based on the connectionstring you are showing, then there must be another connectionstring being used by the program that you are not seeing.
If you find the post has answered your issue, then please mark post as 'answered'.
Member
123 Points
207 Posts
EF Core 2.1 - generated Database Location
Aug 09, 2018 07:20 PM|mehmoodahmed...|LINK
Hi,
I am developing an application in asp.net mvc core 2.1 using EF Core 2.1 (code first).
I want to know the database location where it is being generated.
"ConnectionStrings": { "DefaultConnection": "Server=QA-PC;Database=SalesDB;userid=sa;password=test;" },Contributor
3991 Points
3365 Posts
Re: EF Core 2.1 - generated Database Location
Aug 09, 2018 08:20 PM|DA924|LINK
The location of the database is a computer name/server name is called "QA-PC" and the database is called "SalesDB".
Member
123 Points
207 Posts
Re: EF Core 2.1 - generated Database Location
Aug 10, 2018 05:16 AM|mehmoodahmed...|LINK
Yes it should be there but unfortunately it is not there.
And my application is still working with database. I want to know the exact location.
Contributor
3991 Points
3365 Posts
Re: EF Core 2.1 - generated Database Location
Aug 10, 2018 11:02 AM|DA924|LINK
I don't know man. The machine seems to be a Quality Assurance, the QA as part of the machine name, staging machine on the Local Area Network (LAN). At best, you should be asking someone where you are located about the physical location of the computer.
If the machine is not there as you say based on the connectionstring you are showing, then there must be another connectionstring being used by the program that you are not seeing.
Contributor
2188 Points
931 Posts
Re: EF Core 2.1 - generated Database Location
Aug 10, 2018 01:47 PM|jimmy69|LINK
Hello all,
@mehmoodahmed => just for to test perhpas change the database name and try to refresh your app ...
if it's continue to work => it's not the rigth connection ...
Member
123 Points
207 Posts
Re: EF Core 2.1 - generated Database Location
Aug 11, 2018 11:51 AM|mehmoodahmed...|LINK
thank you DA924 and Jimmy,
I got the issue guys.
the issue was in my connection string. at first time connection string was different and using that details
then I am using following connection string, and removed all generated databases.
"ConnectionStrings": {
"DefaultConnection": "Server=QA-PC;Database=SalesDB;User Id=sa;password=test;"
},
The actual identified issue was in connection string, I was using "userid" which was wrong and the correct thing is "User Id".