Click here to Skip to main content
Click here to Skip to main content

Simple Sample with Entity Framework

, 9 Jul 2009 CPOL
Rate this:
Please Sign up or sign in to vote.
Simple sample with entity framework in 3 layers with ASP.NET

Introduction

This sample shows how you can use the entity framework in an application ASP.NET with an architecture in layers. This is useful for applications that are pretty small and fast. The code uses select, update, create and delete functions. You can use this example with stored procedures or without this. This sample is aimed at newcomers to EF.

This is a small idea that occurred to me to implement the concepts of Entity Framework in ASP.NET, but I'm honest I stumbled across a lot of blocks while making this exercise. The first context is complex and that creates some objects in memory, on the other hand I had to send objects to be processed. There was no need for stored entity framework to be a key, otherwise errors would be raised.

Database

First view the structure of the database. This example uses two tables, i.e., Customers and Category. Customers have a relation with Category.

imgbdsolution.JPG

Project

The project has a structure in three layers. The layer for business that contains the project entities, the project components, the layer of data and the layer of presentation.

imglayer.JPG

The layer of business contains two projects that are Solution.Bussines.Entities. This contains the same structure of the tables and is mapped with the structure of the database.

The Model has the same structure of database which uses ADO.NET Entity Data Model.

imgmodelsolution.JPG

The table customer has a relation with stored procedures.

imgrelationcustomer.JPG

It is important that you see the relation for delCustomer, you only need Id for delete but the entity framework is required for the table referenced.

The next class Customers extends the model generated with ADO.NET Entity Data Model which uses CategoryReference for loading Category of Customer in the line:

this.CategoryReference.Load();

This form easily obtains a class referenced in another class and can also be used for showing in a grid.

public partial class Customers
{
public const string EntitySetName = "Customers";

[Browsable(false)]
public string CategoryName
{
get
{
string res = "";
if (this.Category != null)
{ 
res = this.Category.Name; 
}
else if (this.CategoryReference != null)
{
this.CategoryReference.Load();
if (this.Category != null)
{ 
res = this.Category.Name; 
}
}
return res;
}
set
{
this.CategoryReference.EntityKey =
new EntityKey("CustomersEntities.Category", "CategoryId", value);
}
}

In the next fragment of code was extended the class entities or best call context for that has a singleton pattern and solution to the problem of creating many instances that do not close completely when you use using or dispose.

public static CustomersEntities Context
{
get
{
string objectContextKey = HttpContext.Current.GetHashCode().ToString("x");
if (!HttpContext.Current.Items.Contains(objectContextKey))
{
HttpContext.Current.Items.Add(objectContextKey, new CustomersEntities());
}
return HttpContext.Current.Items[objectContextKey] as CustomersEntities;
}
}

Business Layer

The Solution.Bussines.Components layer manages the logic of business and joins the layer of data with the layer of entities.

This layer is composed by the class CustomersComponent.cs which calls the layer of data. Here you can add more logic code for your business.

/// <summary>
/// Submit an Customers.
/// </summary>
/// <param name="Customers">An Customers object.</param>
public Customers CreateCustomer(Customers customers)
{
Console.WriteLine("Submitting... "); 
try
{
customers = CreateCustomers(customers); 
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw ex;
}

Console.WriteLine("New CustomersID = " + customers.Id.ToString());
return customers;
}

/// <summary>
/// Creates a new Customers record in the database.
/// </summary>
/// <param name="customers">An Customers object.</param>
private Customers CreateCustomers(Customers customers)
{
// Business logic.
Console.WriteLine(customers.ToString());

// Persist data.
CustomersDAC dac = new CustomersDAC();
return dac.Create(customers);
}

List a customer by name, this method calls the layer of data access.

/// <summary>
/// return a list of customers by name
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public List<Customers> ListCustomersByName(string name)
{
// Retrieve data.
CustomersDAC dac = new CustomersDAC();
return dac.SelectByName(name);
}

Data Layer

The data layer contains the logic for accessing the database.

Insert a new record in the database. This method uses the customer created previously for adding to context and saving the changes in the database.

/// <summary>
/// Inserts an Customers row.
/// </summary>
/// <param name="Customers">An Customers object.</param>
public Customers Create(Customers customers)
{
CustomersEntities ctx = CustomersEntities.Context;//)
try
{
ctx.AddToCustomers(customers); 
ctx.SaveChanges();
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
throw ex;
} 
return customers;
}

Update a record in the database. This method does not add the object to context because the previous one was obtained.

/// <summary>
/// Updates an Customers row.
/// </summary>
/// <param name="Customers">A Customers object.</param>
public void Update(Customers Customers)
{
    CustomersEntities ctx = CustomersEntities.Context;//)

    try
    {
        ctx.SaveChanges(); 
    }
    catch (Exception ex){

    Debug.WriteLine(ex.Message);
    throw ex;
    }
}

The context contains the tables as properties so that you can access this and obtain the list of generic classes.

The next method selects the records of the customers table.

/// <summary>
/// Returns a set of Customers that belongs to an employee
/// </summary>
/// <returns>A List of Customers.</returns>
public List<Customers> Select()
{
    List<Customers> resultsList = null;
    CustomersEntities ctx = CustomersEntities.Context;//)
    resultsList = ctx.Customers.ToList();
    return resultsList;
} 

The next method gets a record of the table customer by id. This uses the expression lambda for filter by Id. With the method First, you will surely get one record. After getting customer record, load the table referenced.

public Customers getCustomer(int Id)
{
    Customers custre = null;
    CustomersEntities ctx = CustomersEntities.Context;
    {
        custre = ctx.Customers.First(e => e.Id == Id);
    }            
    custre.CategoryReference.Load();
    return custre;
}

The next method Delete records the table customer, first gets the record and later calls the method DeleteObject for deleting the record temporarily. Finally it calls Save changes that ensures save in the database.

public void Delete(int Id)
{
    CustomersEntities ctx = CustomersEntities.Context;
    Customers cust = ctx.Customers.First(c => c.Id == Id);
    ctx.DeleteObject(cust);
    ctx.SaveChanges();
}

Presentation Layer

In the presentation layer built in ASP.NET, we have the form for update or add records, the principal method sends to the layer components the action for that to execute in the database. This first fills the object customer with the form information and the next calls Update or Add.

For updating a record, first get a record of the context.

protected void btnEnviar_Click(object sender, EventArgs e)
{
CustomersComponent custc = new CustomersComponent();
Customers cust = null; 
// if id customer for edit
if (Id > 0)
{
    cust = custc.getCustomer(Id);
    cust.Name = txtName.Text;
    Category category = custc.GetCategory(
    int.Parse(ddlCategories.SelectedValue));
    cust.Category = category;
    custc.UpdateCustomer(cust);
}
else
{ 
    // agregar 
    cust = new Customers();
    cust.Name = txtName.Text;
    Category category = custc.GetCategory(
    int.Parse(ddlCategories.SelectedValue));
    cust.Category = category;
    custc.CreateCustomer(cust);
}
Response.Redirect("Default.aspx");
}

The next method loads a customer in a form:

private void LoadCustomer()
{
    CustomersComponent custc = new CustomersComponent();
    Customers cust = custc.getCustomer(Id);
    txtName.Text = cust.Name;
    ddlCategories.SelectedValue = cust.Category.Id.ToString();
}

Please comment and vote for this article for it to improve the next time.

History

  • 9th July, 2009: Initial post

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

stexavcar
Web Developer Telecomunicaciones S.A. Esp
Colombia Colombia
Steve X. Cardenas are Developer of software, web sites. is creator of any web sites for magazines, also developer for other industries.
Systems engineer, Specialist in engineering software, certified net and development sharepoint.

Comments and Discussions

 
QuestionSeems that download link is broken PinmemberMember 111361457-Oct-14 10:32 
GeneralExcellent PinmemberMusakkhir16-Mar-14 0:41 
GeneralExcellent Article PinmemberRich.Edwards18-Jun-13 0:27 
GeneralMy vote of 4 Pinmemberwaelali831-May-13 8:35 
GeneralMy vote of 4 Pinmemberpothiq5-Sep-12 9:28 
SuggestionVisit www.entityframeworktutorial.net to learn entity framework step by step PinmemberRavi Karia19-Aug-12 3:33 
QuestionA bit complicated PinmemberMember 47137854-Aug-12 1:19 
GeneralThanks PinmemberShovra Das21-Apr-12 7:41 
GeneralMy vote of 3 Pinmembertarik0774-Apr-12 23:42 
GeneralMy vote of 2 Pinmemberfish5525-Apr-11 4:53 
GeneralMy vote of 3 Pinmembervsr.krishnamraju10-Feb-11 23:09 
GeneralMy vote of 5 PinmemberArlen Navasartian9-Feb-11 6:54 
GeneralPassing CategoryId in delCustomers PinmemberArlen Navasartian9-Feb-11 6:40 
Generaluse english only in application Pinmembersunil parihar7-Dec-10 20:15 
GeneralStatic context Pinmemberjportelas14-Sep-10 11:37 
GeneralRe: Static context PinmemberArash Javadi29-Nov-11 22:34 
Generalgood article PinmemberDonsw3-Oct-09 19:34 
General¡Buen artículo! PinmemberMember 406954610-Jul-09 3:24 
GeneralRe: ¡Buen artículo! PinmemberMi.Chal.10-Jul-09 7:05 
GeneralRe: ¡Buen artículo! PinmemberJoanGilabert13-Jul-09 22:12 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.141223.1 | Last Updated 9 Jul 2009
Article Copyright 2009 by stexavcar
Everything else Copyright © CodeProject, 1999-2014
Layout: fixed | fluid