Configuring local db location in Entity Framework

Question

I am trying to configure a different location for my local db.

I read an article on configuring connection strings and it suggests I can replace |DataDirectory| in the web config with ~/MyDirectory where ~ is the web app root. So I have input the connection string as:

<connectionStrings>
<add name="Context" connectionString="Data Source=(LocalDb)\v11.0;Initial Catalog=Context-20130829161219;Integrated Security=SSPI;AttachDBFilename=~/MyDirectory/Context-20130829161219.mdf"
  providerName="System.Data.SqlClient" />

Unfortunately, when I run the app it doesn't seem to create the db at all. I can imagine it's only something very small that I am doing wrong but I would appreciate if someone can point me in the right direction.

Many Thanks

MSTdev · Accepted Answer · 2013-08-30 10:02:36Z

2

Lets try with below string it will help you

<add name="Context" connectionString="metadata=res://*/Models.Datacontext.csdl|res://*/Models.Datacontext.ssdl|res://*/Models.Datacontext.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=(LocalDb)\SQLInstance;initial catalog=Context-20130829161219;persist security info=True;user id=sa;password=Yourpassword;multipleactiveresultsets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />

or replace your Source=(LocalDb)\SQLInstance;initial with Source=.\SQLInstance;initial

answered Aug 30, 2013 at 10:02

MSTdev

4,6352 gold badges26 silver badges40 bronze badges

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

Comments

Richard · Accepted Answer · 2013-08-30 09:53:45Z

1

Try running the Update-Database cmdlet from the package manager console - you should at least see some output indicating why it doesn't work.

answered Aug 30, 2013 at 9:53

Richard

30.7k12 gold badges79 silver badges121 bronze badges

2 Comments

Theo Over a year ago

Thanks for the suggestion. I get the following error: A file activation error occurred. The physical file name '~/MyDirectory/Context-20130829161220.mdf' may be incorrect. Diagnose and correct additional errors, and retry the operation.

Theo Over a year ago

Yes, when replacing ~/MyDirectory/ with |DataDirectory| everything works fine

Collectives™ on Stack Overflow

Configuring local db location in Entity Framework

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related