ASP.NET MVC .mdf file missing

Question

I have a problem that my asp.net mvc application somehow can't create a localdb .mdf file.

For example, I am creating a new web project in VS 2015 and debug it. When I go to register and enter some new user, the app throws an exception that the file cannot be found...

I know there are similar posts, but none of the solutions helped me.

My connection string looks like this:

<add name="DefaultConnection" 
     connectionString="Data Source=(LocalDb)\MSSQLLocalDB;AttachDbFilename=C:\Users\User\Documents\Visual Studio 2015\Projects\Auth1\Auth1\App_Data\aspnet-Auth1-20160121104112.mdf;Initial Catalog=aspnet-Auth1-20160121104112;Integrated Security=True" 
     providerName="System.Data.SqlClient" />

I already tried changing the keyword AttachDbFilename to

|DataDirectory|\aspnet-Auth1-20160121104112.mdf

I tried playing around with the Data Source.

I tried giving permission to the the SQL Server user to the folder...

I checked that VS, SQL Server 2014 and the Windows User are all using the same user.

I mean, how can a project from scratch already have a bug?

Please could you post the exact exception you are receiving. And, does that file actually exist on the filesystem or not? — ngm
– ngm, Commented Jan 21, 2016 at 11:42

RoteS · Accepted Answer · 2016-01-21 11:20:12Z

2

Have you tried removing this part entirely?

(the part being : AttachDbFilename=C:\Users\User\Documents\Visual Studio 2015\Projects\Auth1\Auth1\App_Data\aspnet-Auth1-20160121104112.mdf)

if that doesn't work have you installed localdb?

answered Jan 21, 2016 at 11:20

RoteS

1,45513 silver badges10 bronze badges

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

1 Comment

gisderdube Over a year ago

Wow, i really didn't have Localdb installed... I assumed by installing MS SQL Server Express, it would install LocalDB with it, but nah. Thank you a lot! I was searching for a solution for about 5-6 hours...

Chetan Hirapara · Accepted Answer · 2016-01-21 11:25:44Z

0

Remove all the thinigs for entity related to .mdf and add again from start point

This will be automatic add all required reference and artifacts.

answered Jan 21, 2016 at 11:25

Chetan Hirapara

6941 gold badge10 silver badges30 bronze badges

Comments

oneNiceFriend · Accepted Answer · 2016-01-21 11:36:59Z

0

You can try to create a database inside your project(or in your solution) from scratch. Lets see whats going to happen? If there will be error, the error message will give us a hint.

answered Jan 21, 2016 at 11:36

oneNiceFriend

6,9117 gold badges32 silver badges40 bronze badges

Comments

Mihail Stancescu · Accepted Answer · 2016-01-21 11:42:33Z

0

Is this a new project?
Have you build and run the project?

That database will be created by the asp.net identity when a user tries to login/register. Afterwards you'll see the mdf file in the directory you specified in the connection string.

answered Jan 21, 2016 at 11:42

Mihail Stancescu

4,1681 gold badge18 silver badges22 bronze badges

1 Comment

gisderdube Over a year ago

yes, completely new project, only files created by VS. I have built and debugged the application (F6-F5).

salli · Accepted Answer · 2019-02-21 20:13:57Z

0

If you are working with C:\inetpub\wwwroot and you are using IIS express, make sure that app_data folder in the project is given full access for the current logged in user.

answered Feb 21, 2019 at 20:13

salli

8176 silver badges12 bronze badges

Collectives™ on Stack Overflow

ASP.NET MVC .mdf file missing

5 Answers 5

1 Comment

Comments

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related