How to access Database which was in APP_DATA

Question

I developed a sample for membership and roles using the video tutorial available. Now what i need is if i run my example in the other machine i would like to login and access the pages with the user name and password that were created using Asp.Net Configuration in my machine can any one give me an idea to achieve this

Jiteendra Sampathirao · Answer

Hi To access db which was in App_Data folder: connectionStrings > | add name = LocalSqlServer  connectionString =  Data Source=.\SQLEXPRESS;AttachDbFilename=| Directory |myDB.mdf;Integrated Security=True;User Instance=True  /> connectionStrings > For asp.Net membership an roles: Please refer this links: Link1 Link2 i hope it help you..

Dorababu Meka · Answer

Hi jitendra this is the one we have to write in order to access if we run our solution on other machine DataDirectory |Login.mdf;Integrated Security=True;User Instance=True  providerName=System.Data.SqlClient/> So it will read the mdf from the specified path

Jiteendra Sampathirao · Answer

Hi right click on the mdf file. And then click on property -->Then you can see connection string value you mdf file storing address means directory.... Place your file storing location at |Directory| place

Dorababu Meka · Answer

Hi Jitendra can you clarify on this AttachDbFilename=| Directory |myDB.mdf; What should be the directory name here