EF Core 2.1 - generated Database Location

Question

User-234441352 posted

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;"
  },

Answer 1

User1120430333 posted

The location of the database is a computer name/server name is called  "QA-PC"  and the database is called "SalesDB".

Answer 2

User-234441352 posted
Thanks DA924,

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.

Answer 3

User1120430333 posted

Thanks DA924,

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.

Answer 4

User632428103 posted

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 ...

Answer 5

User-234441352 posted

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".