Haris
Haris

Reputation: 1209

How to access asp.net membership database?

Im trying to access default membership database. Because i have added 3 more table. Im doing this by using entity framework. But it isn`t displaying database name. I want a single database in my project.

Upvotes: 0

Views: 1034

Answers (3)

Jim G.
Jim G.

Reputation: 15365

Are you connecting to the ApplicationServices database in your project's App_Data folder?

Or did you create the ApplicationServices database on a genuine SQL Server instance?

In any event:

  1. This link can help: http://www.misfitgeek.com/adding-asp-net-membership-to-your-own-database/
  2. As always, the connection string will definitively tell you where your database is located.

Upvotes: 1

Mehdi Bugnard
Mehdi Bugnard

Reputation: 3979

I'm not sure I understood the question completely ... But Install SQL SERVER MANAGEMENT STUDIO . The best official programm for microsoft to connect ,show,edit and update your databases ;-)

enter image description here

You can through this program have a better visibilitée installed bases. Otherwise you can simply querying with the console manually using the prefix "USE [aspnet_nameTable] ..."

sample:

USE [dbo].[aspnet_users]
CREATE DATABASE blablobli......

OR you can attach the local database in SQL MANAGEMENT STUDIO

enter image description here

Upvotes: 0

Bhushan Firake
Bhushan Firake

Reputation: 9448

After you run your project for first time, just go to the App_Data Folder and there you can see the database file. Remember to do the following before it:

enter image description here

You can access by double clicking it..

Upvotes: 0

Related Questions