Asp.Net Core migration path error

Question

I am trying to create a DB from EF Core migration. With this connection string.

"ConnectionStrings": {
"DefaultConnection": "Server=(localdb)\\MSSQLLocalDB;Database=BookList_RazorDemo;Trusted_Connection=True;MultipleActiveResultSets=True"

}

The add-migration command on the PMC works fine, but when I execute update-database it give me an error saying that it cannot open or create the physical file 'C:\Users\[User]BookList_RazorDemo.mdf', the users name and the mdf file name are not separated by .

Is there a parameter I can specify with the update-database command to set my output path for the mdf file, or where can I set the output directory otherwise?

Thank you in advance.

Valuator · Accepted Answer · 2018-05-11 17:32:42Z

1

You can specify the path to your .mdf file by adding AttachDbFileName to the connection string (Documentation):

Server=(LocalDB)\\MSSQLLocalDB;Integrated Security=true;AttachDbFileName=D:\Data\MyDB1.mdf

answered May 11, 2018 at 17:32

Valuator

3,6974 gold badges37 silver badges69 bronze badges

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

1 Comment

Tinaira Over a year ago

Nice, it works. Last time I was using EF Core it didn't recognise AttachDbFIleName as property.

dan · Accepted Answer · 2020-10-13 20:34:10Z

0

This is Fixed in latest SQL Server 2017 CU!

https://github.com/dotnet/ef6/issues/384#issuecomment-398313650

answered Oct 13, 2020 at 20:34

dan

2,0343 gold badges25 silver badges32 bronze badges

Collectives™ on Stack Overflow

Asp.Net Core migration path error

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related