Where is the default database created for C# MVC ASP.NET application?

Question

I've got new MVC ASP.NET app on bootstrap with login/register script and it works ok, but I don't know where is default database for this app. My App_Data folder is empty. Can somebody tell me where the data from form registration are saved.

What is your version of visual studio ? and MVC app version ? — Kaushik Thanki
– Kaushik Thanki, Commented May 29, 2015 at 11:19

Kaushik Thanki · Accepted Answer · 2015-05-29 11:32:25Z

8

enter image description here

This will stored under Sql express that came along with visual studio 12,13 &15.

You can connect it using server explore under View - > server Explorer

edited May 29, 2015 at 11:32

answered May 29, 2015 at 11:27

Kaushik Thanki

3,5784 gold badges29 silver badges55 bronze badges

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

Comments

JustJohn · Accepted Answer · 2018-05-28 04:04:36Z

2

Here is something in case you can't see the DefaultConnection and AspNet tables in Server Explorer: You need to register a user at least once to get these tables created or at least to show.

answered May 28, 2018 at 4:04

JustJohn

1,4702 gold badges26 silver badges51 bronze badges

Comments

Mahesh Malpani · Accepted Answer · 2015-05-29 11:09:22Z

1

Default connection string will be

<connectionStrings>
    <add name="ApplicationServices"
         connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\aspnetdb.mdf;User Instance=true"
         providerName="System.Data.SqlClient" />
  </connectionStrings>

So it will be created in your app data. MDF file will be created. Though you can change the connection

answered May 29, 2015 at 11:09

Mahesh Malpani

2,04220 silver badges27 bronze badges

Comments

Vishal prabhu lawande · Accepted Answer · 2015-05-29 11:23:28Z

1

In your Web.config ,look for 'Connectionstring'

 <connectionstrings>
        <add name="ConnectionstringName" connectionstring="Data Source=DatasourceName;Initial Catalog=This_isDefault_db;Persist Security Info=True;User ID=ID;Password=pwd" providername="System.Data.SqlClient" />
    </connectionstrings>

The catalog attribute tells you which is your db.

edited May 29, 2015 at 11:23

answered May 29, 2015 at 11:15

Vishal prabhu lawande

2312 silver badges13 bronze badges

Comments

Midhun · Accepted Answer · 2015-05-29 11:28:42Z

1

Normally we connect our model or DAL to a databases like Sql Server or MySQL etc. But as per you question i understood that just you are using a visual studio built-in application. visual studio stores that data in localDB

answered May 29, 2015 at 11:28

Midhun

237 bronze badges

Collectives™ on Stack Overflow

Where is the default database created for C# MVC ASP.NET application?

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related