asp.net identity tables location

1.4k Views Asked by At

I'm working on mvc5 project which is using asp.net identity for membership provider.

Now, I've registered the first test user via web interface and I was expecting to see newly created tables in the db I'm using but there are no new tables created although I'm able to register/login/logout of the app.

Where are the tables for the membership provider located?

Update

Conn string added:

<connectionStrings>
    <add name="TTBEntities" connectionString="metadata=res://*/TTB.csdl|res://*/TTB.ssdl|res://*/TTB.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=HOME-PC;initial catalog=TTB;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />
  </connectionStrings>
1

There are 1 best solutions below

3
On BEST ANSWER

If you are using default template then the connection strings looks like

<connectionStrings>
    <add name="DefaultConnection" connectionString="Data Source=(LocalDb)\v11.0;AttachDbFilename=|DataDirectory|\aspnet-WebApplication21-20141121113141.mdf;Initial Catalog=aspnet-WebApplication21-20141121113141;Integrated Security=True"
      providerName="System.Data.SqlClient" />
  </connectionStrings>

The database files (mdf and log) can be found in your local file storage project "App_Data" folder.

Update

According your connection string you are using Entity Framework connection string. You can get the answer using this article.

Check your bin folder or any application executable storage location for relevant files. There should be three files with extensions .csdl, .ssdl and .msl.

Hope this helps.