CODEWITHSUNDEEP
visual-studio-2010entity-frameworkentity-framework-4mdf
user624274
user624274

Reputation: 5

cannot save record in attached .mdf file with EF 4.0

I want to create a VS 2010 project with EF 4.0 model.
But I have no records and errors after inserting new record with attached .mdf file .

But if the base is connected to Sql Server, it works fine.

Please help me to insert records to attached .mdf db

Upvotes: 0

Views: 692

Answers (1)

Danny Varod
Danny Varod

Reputation: 18069

You need to make sure DB is not in a shared folder, is on your pc, is not read only, that you have write permissions to the folder that contains it and there is no DB already attached to service with same name. Make sure you can connect with Server Explorer window first.

Consider using SQL Server CE, if you want to work with loose DB files.

Also, make sure the file is not overwritten with each build. (Use "Copy if newer", not "Copy always".)

Upvotes: 1

Related Questions