Last post Aug 11, 2018 11:51 AM by mehmoodahmed...
Aug 09, 2018 07:20 PM|mehmoodahmed...|LINK
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.
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".
Aug 10, 2018 05:16 AM|mehmoodahmed...|LINK
Aug 10, 2018 11:02 AM|DA924|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.
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.
Aug 10, 2018 01:47 PM|jimmy69|LINK
@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 ...
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.
"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