Skip to main content

Steps to attach DataBase to .Net Application - App_Data folder.

Step 1:

Detach Database from SQL Server.
         i) Open Sql Server
         ii) Login to Server
         iii) Select the DB that you going to attach to application, and right click for the option to detach the DB.

Step 2:

Right click on app_data folder and click on add existing item and then select database which you want to add in app_data folder,DB will exist in C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\...

 Step 3:

Alter the your connection string as below:
<connectionstrings>
<add connectionstring="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\DBName.mdf;Integrated Security=True;User Instance=True  " name="ConnectionName" providername="System.Data.SqlClient" />
</connectionstrings>

Comments

Post a Comment

Popular posts from this blog

C# IEnumerable and IQueryable

The first important point to remember is IQueryable interface inherits from IEnumerable, so whatever IEnumerable can do, IQueryable can also do.   There are many differences but let us discuss about the one big difference which makes the biggest difference. IEnumerable interface is useful when your collection is loaded using LINQ or Entity framework and you want to apply filter on the collection. Consider the below simple code which uses IEnumerable with entity framework. It’s using a Wherefilter to get records whose EmpId is 2. EmpEntities ent = new EmpEntities(); IEnumerable<Employee> emp = ent.Employees;  IEnumerable<Employee> temp = emp.Where(x => x.Empid == 2).ToList<Employee>(); This where filter is executed on the client side where the IEnumerable code is. In other words all the data is fetched from the database and then at the client its scans and gets the record with EmpId is 2.   But now see the below code we have...
Post a Comment
Read more