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

Repository Pattern with Entity Framework using EntityTypeConfiguration

, 20 Mar 2013 CPOL
Rate this:
Please Sign up or sign in to vote.
Repository Pattern with Entity Framework using EntityTypeConfiguration.

Introduction

I was looking for Repository Pattern with Entity Framework Code First with EntityTypeConfiguration. But unable to find such integrated sample. Here I am touching only the basic. It's my first article.

Background

I am taking plain two objects Category and Product to make this article simple.

Using EntityTypeConfiguration for making different layer to interact with Database and field validation.

Following is the Solution tree. 

**Note: need to add Entity Frame work reference in the EfRepPatTest.Data  project.

Development Tools

VS 2010

Entity Framework Library

Using the code 

First of all we shall create three Projects in the solution, of them two's are class library and the other one is console project for Implementation.
Solution Name: EfRepositoryPatterTest
Class Library Name: EfRepPatTest.Entity
EfRepPatTest.Data
Console Application: EfRepPatTest.Implementation  

In the EfRepPatTest.Entity project we shall create the following class:

BaseEntity.cs

public class BaseEntity<T>
{
    public T Id { get; set; }
}

IRepository.cs [Interface]

That contains action of

public interface IRepository<TEntity> where TEntity:class 
{
    IQueryable<TEntity> GetAll();
    TEntity GetById(object id);
    void Insert(TEntity entity);
    void Update(TEntity entity);
    void Delete(TEntity entity);
}

Category.cs

It will inherit BaseEntity class for getting the Id property and assigning Id field as integer.

public class Category:BaseEntity<int>
{
    public virtual string Name { get; set; }

    public List<Product> Products { get; set; }
}

Product.cs 

Same as category class.

public class Product:BaseEntity<long>
{
    public virtual int CategoryId { get; set; }
    public virtual Category Category { get; set; }
    public virtual string Name { get; set; }
    public virtual int MinimumStockLevel { get; set; }

}

EfRepPatTest.Data project hold the following classes or interfaces.

Add reference of EntityFramework and EfRepPatTest.Entity in this project.

First of all create an interface that driven DbContext class means DataContext class will consume.

IDbContext.cs

public interface IDbContext
{

    IDbSet<TEntity> Set<TEntity>() where TEntity:class;
    int SaveChanges();
    void Dispose();
}

Here IDbSet interface belongs to System.Data.Entity namespace. Create a class name DataContext that will inherit DbContext and consume IDbContext.

DataContext.cs [Partial]

public class DataContext: DbContext,IDbContext
{
    public new IDbSet<TEntity> Set<TEntity>() where TEntity : class
    {
        return base.Set<TEntity>();
    }
}

Before discussing the DataContext class’s method we need another two class that will map Entity with EntityTypeConfiguration and holds data validation logic of Database table.

Create folder name Mapping and place the CategoryMap and ProductMap class in it. [optional]

CategoryMap.cs

public class CategoryMap:EntityTypeConfiguration<Category>
{
    public CategoryMap()
    {
        ToTable("Category");
        HasKey(c => c.Id).Property(c => c.Id).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
        Property(c => c.Name).IsRequired().HasMaxLength(50);
    }
}

ProductMap.cs

public class ProductMap:EntityTypeConfiguration<Product>
{
    public ProductMap()
    {
        ToTable("Product");
        HasKey(p => p.Id).Property(p => p.Id).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
        //CategoryId as foreign key
        HasRequired(p => p.Category)
            .WithMany(c=>c.Products)
            .HasForeignKey(p => p.CategoryId);
        Property(p => p.Name).IsRequired().HasMaxLength(100);
        Property(p => p.MinimumStockLevel);
    }
}

The above part will help us avoiding directly use of Entities[Product and Category] as database table, instead it will cover db table logic, validation.

Now add "OnModelCreating" method in DataContext class for attaching the Entity as part of model.The following code snippet will demonstrates how to configure EntityTypeConfiguration driven class [ProductMap, CategoryMap] with ModelBuilder manually.

{

         modelBuilder.Configurations.Add(new CategoryMap());

         modelBuilder.Configurations.Add(new ProductMap());

         base.OnModelCreating(modelBuilder);

     }

Here problem is all of the classes need to be configure manually. That’s why I would like to avoid it. The following codes will help us to do it automatically.

DataContext.cs [Full]

public class DataContext: DbContext,IDbContext
{
    public new IDbSet<TEntity> Set<TEntity>() where TEntity : class
    {
        return base.Set<TEntity>();
    }

    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        var typesToRegister = Assembly.GetExecutingAssembly().GetTypes()
        .Where(type => !String.IsNullOrEmpty(type.Namespace))
        .Where(type => type.BaseType != null && type.BaseType.IsGenericType && 
           type.BaseType.GetGenericTypeDefinition() == typeof(EntityTypeConfiguration<>));
        foreach (var type in typesToRegister)
        {
            dynamic configurationInstance = Activator.CreateInstance(type);
            modelBuilder.Configurations.Add(configurationInstance);
        }

        base.OnModelCreating(modelBuilder);
    }

}

we haven’t implement the IRepository interface yet, through RepositoryService class we will implement it. 

RepositoryService.cs

public class RepositoryService<TEntity>:IRepository<TEntity> where TEntity:class 
{
    private IDbContext Context;

    private IDbSet<TEntity>  Entities
    {
        get { return this.Context.Set<TEntity>(); }
    }

    public RepositoryService(IDbContext context)
    {
        this.Context = context;

    }

    public IQueryable<TEntity> GetAll()
    {
        return Entities.AsQueryable();
    }

    public TEntity GetById(object id)
    {
        return Entities.Find(id);
    }

    public void Insert(TEntity entity)
    {
        Entities.Add(entity);
    }

    public void Update(TEntity entity)
    {
        if (entity == null)
            throw new ArgumentNullException("entity");

        this.Context.SaveChanges();
    }

    public void Delete(TEntity entity)
    {
        Entities.Remove(entity);
    }

    public void Dispose()
    {
        Dispose(true);
        GC.SuppressFinalize(this);
    }
    protected virtual void Dispose(bool disposing)
    {
        if (disposing)
        {
            if (this.Context != null)
            {
                this.Context.Dispose();
                this.Context = null;
            }
        }
    }
}

The "private IDbSet<TEntity>  Entities" property will returns DbSet instance for access to einties of the given type in the context.

Now need a class for initializing the Database. Add a class named DataBaseInitializer.

DataBaseInitializer.cs

public class DataBaseInitializer : IDatabaseInitializer<DataContext>
{
    public void InitializeDatabase(DataContext context)
    {
        context.Database.CreateIfNotExists();
    }
}

Implementing the application through  EfRepPatTest.Implementation console project:

The Program.cs class looks like the following:  

class Program
{
    static void Main(string[] args)
    {
        var context = new DataContext();
        var dataBaseInitializer = new DataBaseInitializer();
        dataBaseInitializer.InitializeDatabase(context);

        var categoryRepository = new RepositoryService<Category>(context);

        //Adding category in the category entity
        var category = new Category()
        {
            Name = "Baverage"
        };
        var products = new List<Product>();

        //Adding product in the product entity
        var product = new Product()
            {
                Name = "Soft Drink A",
                MinimumStockLevel = 50
            };
        products.Add(product);

        product = new Product()
        {
            Name = "Soft Drink B",
            MinimumStockLevel = 30
        };
        products.Add(product);

        category.Products = products;

        //Insert category and save changes
        categoryRepository.Insert(category);
        context.SaveChanges();

        ///////////////////////////////////////////////////////////////////////////////
        /////////////////For the next project we shall add Dependency Injection////////
        ////////////////But now we have add a Service layer for test manually//////////
        ///////////////////////////////////////////////////////////////////////////////
        IProductService productRepository = new ProductService();

        Console.WriteLine("\n");
        Console.WriteLine("Product List:");
        Console.WriteLine("-------------------------------------------------");
        foreach (var product1 in productRepository.GetAll())
        {
            Console.WriteLine(string.Format("Product Name : {0}",product1.Name));
            if (product1.Id == 9)
            {

                product1.Name = "Soft Drink AAA";
                productRepository.Update(product1);
            }
        }
        Console.WriteLine("Press any key to exit");
        Console.ReadKey();
    }
}

Here we have added "EfRepPatTest.Service" project to test the service. It will help us in the next article.

Connection string in App.config [highlighted portion]:

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <configSections>
    <!-- For more information
on Entity Framework configuration, visit
http://go.microsoft.com/fwlink/?LinkID=237468 -->
    <section name="entityFramework" 
             type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection,
EntityFramework, Version=4.4.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089" 
             requirePermission="false" />
  </configSections>
  <entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory,
EntityFramework" />
  </entityFramework>

  <connectionStrings>
      <add name="DataContext" 
         providerName="System.Data.SqlClient" 
         connectionString="Data
Source=YourSERVER;Initial Catalog=EfDBExistRepository;Integrated
Security=True;MultipleActiveResultSets=True;"/>
 
  </connectionStrings>
</configuration>

As name of connection string [name="DataContext"] same as DataContext.cs class so it will work automatically. 

That's may help.

Next Article

License

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

Share

About the Author

MdAsifBd
Software Developer (Senior)
Bangladesh Bangladesh
No Biography provided

Comments and Discussions

 
GeneralMy vote of 4 Pinmemberfredatcodeproject20-Mar-13 6:22 
GeneralRe: My vote of 4 PinmemberMdAsifBd20-Mar-13 6:28 

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 | Mobile
Web02 | 2.8.141029.1 | Last Updated 20 Mar 2013
Article Copyright 2013 by MdAsifBd
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid