asp.netdatabaseentity-frameworklocaldbapp-data

Entity Framework Does Not Create Database in App_Data


i am working on a web api and i need to have a local db in the App_Data folder, I'm using Entity Framework Code First but it does not create database in the App_Data

Here is my connection string :

  <connectionStrings>
    <add name="TestDBContext"
         connectionString="Data Source=(LocalDb)\MSSQLLocalDB;Initial Catalog=TestDB;Integrated Security=True;MultipleActiveResultSets=True;AttachDBFilename=|DataDirectory|TestDB.mdf;User Instance=True"
         providerName="System.Data.SqlClient" />
  </connectionStrings>

i used show all file in the project menu and bla bla bla

but database is being create in

C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA

how do i fix this?


Solution

  • Problem solved by installing Sql LocalDB