I have created an asp.net web api 4.5.2 project and I can't find the database that it's using for adding users. The info in the connection string:
Data Source=(LocalDb)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\aspnet-WebApplicationTest2-20160906022916.mdf;Initial Catalog=aspnet-WebApplicationTest2-20160906022916;Integrated Security=True.
But when I check the app_data directory it's empty. Where can I find this database?
Database creation for templates are delayed until a request is sent.
Run your server and POST following JSON with Content-Type: application/json header to http://localhost:xxx/api/Account/Register:
{
"Email": "[email protected]",
"Password": "TestTest1!",
"ConfirmPassword": "TestTest1!"
}
You should get 200: OK.
I am using Advanced REST client.
After that database will be created in App_Data folder.
If server returned 200: OK and App_Data is empty, Do the following steps:
In Visual Studio go to View menu. Select SQL Server Object Explorer(or press Ctrl+\, Ctrl+S).
Your SQL server should be there. You can find your database in Databases folder.
If you need specifically the data file, then expand Databases folder, right click on which one you need and click on Properties. Scroll down to see Current Connection Parameters.
create database MyDatabase, then execute. You'll need to refresh Server Object Explorer to see created database. To get connection string to newly created database, rightclick on it and open up Properties window, there you will see Connection String of that databaseAdd New DatabaseSome times this error occurred when you do not install local db of SQL server.To know if you install local db,open command prompt(administrator) and type "SqlLocalDb info".Then it show localdb name.add that name into connection string.If command prompt is not show this,refer following link to add localdb into SQL express server. link:-https://www.mssqltips.com/sqlservertip/5612/getting-started-with-sql-server-2017-express-localdb/
