ADO.NET Entity Framework

by Farooq Kaiser 6. June 2009 15:44

In this tutorial I will show you how you can create data access classes using the Microsoft Entity Framework when building an ASP.NET application.

This tutorial will use AdventureWorks database. Follow the these steps.

Add a new item to the project by right-clicking on WindowsFormsApplication1 in the Solution Explorer, clicking Add, and then clicking New Item.
Select ADO.NET Entity Data Model from the Templates list and click ADD
On the Choose Model Contents page, select the Generate from Database option and click Next.
Set up as a database connection in Visual Studio, click New Connection to open the Connection Properties dialog and create a new connection to the database.
On the Choose Your Database Objects page, expand the Tables node and check the contact table.
Click Finish.
Add the datagridview and a button on the form1.cs
The following code will bind the grid with contact table.

private void button1_Click(object sender, EventArgs e)
{

using (var context = new AdventureWorksEntities1())
{

dataGridView1.DataSource = context.Contact.ToList();

}

}

Currently rated 1.0 by 1 people

Entity Framework with ASP.NET MVC In this article, I will explore entity framework with ASP.NET MVC. We will modify Form valid...Creating Custom HTML Helpers in ASP.NET MVC framework In this article, I will explore how you can create custom HTML Helpers that you can use within y...Querying with Entity SQLCreateQuery(T) Method creates an ObjectQuery(T) in the current&nb...