LocalDB location

Asked Apr 24 '14 at 20:47

Active Apr 24 '14 at 20:55

Viewed 202 times

I'm using LocalDB and Entity Framework code-first for a new project. I want to change the location where the database is created/saved. However, every time I do, I get one of any number of exceptions. If I try adding AttachDBFilename=|DataDirectory|\database.mdf, I get an exception stating:

The underlying provider failed on Open.

As well as:

Cannot attach the file 'C:\Projects\database.mdf' as database 'Schema.MyProject'.

Eventually, when I run this program on another computer, I'm looking to create/save the database in the AppData folder. How can this be done?

edited Apr 24 '14 at 20:55

marc_s

732,580
175
1,330
1,459

asked Apr 24 '14 at 20:47

PiousVenom

6,888
11
47
86

If you save database to your appdata folder, not all users may be able to access it. – msmolcic Apr 24 '14 at 20:55
@msmolcic92: That's the point with this particular application. – PiousVenom Apr 24 '14 at 20:56
Try with this SO answer: http://stackoverflow.com/questions/8354594/how-to-install-a-file-in-app-data-in-setup-project-c – msmolcic Apr 24 '14 at 20:56
@msmolcic92:I'm not to the install point yet. I'm just trying to get set the default location right now. – PiousVenom Apr 24 '14 at 20:58

LocalDB location

0 Answers0