how can i create sql database by entity framework code first in specific path

Question

I successfully create my database in entity framework code first using this string :

Data Source=DESKTOP-PL8EDEA;Initial Catalog=MyDB;Integrated Security=True;TimeOut=3600

This top connection string create database in default address of sql server databases but I want the database to be saved in my desired path I also tried this field but it was not successful

Data Source=DESKTOP-PL8EDEA;Initial Catalog=|D:\MyFolder|\MyDB;Integrated Security=True;TimeOut=3600

Hope this answer your question. stackoverflow.com/questions/4731335/… — shehanpathi
– shehanpathi, Commented Jul 22, 2022 at 7:00
See also stackoverflow.com/search?q=ef6+code+first+database+location — Stefan Wuebbe
– Stefan Wuebbe, Commented Jul 22, 2022 at 14:36

Darkk L · Accepted Answer · 2022-07-22 12:58:36Z

1

You can specify the path:

Server=.\SQLExpress;AttachDbFilename=C:\MyFolder\MyDataFile.mdf;Database=dbname;Trusted_Connection=Yes;

answered Jul 22, 2022 at 12:58

Darkk L

1,0391 gold badge7 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

how can i create sql database by entity framework code first in specific path

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related