Make EF use local database in App_Data folder

Question

I am using POCO approach on all my projects using Entity Framework. It's all good but I have one problem: It is creating database on my SQL Express, instead I want it to store my database in *.mdf file in App_Data folder.

bricelam · Accepted Answer · 2012-11-05 20:23:27Z

7

Set an appropriate connection string in Web.config that makes use of the AttachDBFilename keyword.

<connectionStrings>
  <add name="MyContextClassName"
       connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=MyDatabase;Integrated Security=True;MultipleActiveResultSets=True;AttachDBFilename=|DataDirectory|MyDatabase.mdf;User Instance=True"
       providerName="System.Data.SqlClient" />
</connectionStrings>

edited Nov 5, 2012 at 20:23

answered Nov 5, 2012 at 17:06

bricelam

30.7k9 gold badges98 silver badges119 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Stan Over a year ago

But the thing is that database is not created in my App_Data folder. It's created straight in SQLEXPRESS

bricelam Over a year ago

@Stanislav Did you try the answer? "AttachDBFilename=|DataDirectory|..." will create the database file inside of App_Data.

Stan Over a year ago

I tried and it showed me Exception has been thrown by the target of an invocation. when I did update-database -f -v.

bricelam Over a year ago

@Stanislav Do you have any additional information? Does $Errors[0].Exception.InnerException.ToString() tell your more?

Stan Over a year ago

As it happends I upgraded to Win8 and now I don't even have SQLEXPRESS installed. Now it does what it is suppose to do - storing everything in file w/o even using database server.

|

Collectives™ on Stack Overflow

Make EF use local database in App_Data folder

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related