I am part of a year long plus project that is re-writing an existing application for a client.  We have decided to develop the project using Visual Studio 2012 and .NET 4.5.  The project will be using a number of technologies and patterns to include Entity Framework 5, WCF Services, and WPF for the client UI.

This is my attempt at documenting some of the successes and failures that I will be coming across in the development of the application.

In building the data access layer we have to access a database that has already been designed by a dedicated dba. The dba insists on using Stored Procedures which has made the use of EF a little more difficult.  He will not allow direct table access but we did manage to get him to allow us to use Views. 

Since EF 5 does not have good support to do Code First with Stored Procedures, my option was to create a model (EDMX) against the existing database views.   I then had to go select each entity and map the Insert/Update/Delete functions to their respective stored procedure.

The next step after I had completed mapping the stored procedures to the entities in the EDMX model was to figure out how to build a generic repository that would work well with Entity Framework 5. 

http://www.tcscblog.com/2012/06/22/entity-framework-generic-repository/

http://www.tugberkugurlu.com/archive/generic-repository-pattern-entity-framework-asp-net-mvc-and-unit-testing-triangle

IRepository.cs

   
public interface IRepository : IDisposable where T : class
    {
        void Add(T entity);
        void Update(T entity, int id);
        T GetById(object key);
        IQueryable Query(Expression> predicate);
        IQueryable GetAll();
        int SaveChanges();
        int SaveChanges(bool validateEntities);
    }

GenericRepository.cs

    
public abstract class GenericRepository : IRepository where T : class
    {
        public abstract void Add(T entity);
        public abstract void Update(T entity, int id);
        public abstract T GetById(object key);
        public abstract IQueryable Query(Expression> predicate);
        public abstract IQueryable GetAll();
        public int SaveChanges()
        {
            return SaveChanges(true);
        }
        public abstract int SaveChanges(bool validateEntities);
        public abstract void Dispose();
    }

One of the issues I ran into was trying to do an update. I kept receiving errors so I posted a question on Stack Overflow

http://stackoverflow.com/questions/12585664/an-object-with-the-same-key-already-exists-in-the-objectstatemanager-the-object

and came up with the following hack. If someone has a better way, please let me know.

DbContextRepository.cs

 public class DbContextRepository : GenericRepository
        where T : class
    {
        protected DbContext Context;
        protected DbSet DbSet;

        public DbContextRepository(DbContext context)
        {
            if (context == null)
                throw new ArgumentException("context");

            Context = context;
            DbSet = Context.Set();
        }

        public override void Add(T entity)
        {
            if (entity == null)
                throw new ArgumentException("Cannot add a null entity.");

            DbSet.Add(entity);
        }

        public override void Update(T entity, int id)
        {
            if (entity == null)
                throw new ArgumentException("Cannot update a null entity.");

            var entry = Context.Entry(entity);

            if (entry.State == EntityState.Detached)
            {
                var attachedEntity = DbSet.Find(id); // Need to have access to key

                if (attachedEntity != null)
                {
                    var attachedEntry = Context.Entry(attachedEntity);
                    attachedEntry.CurrentValues.SetValues(entity);
                }
                else
                {
                    entry.State = EntityState.Modified; // This should attach entity
                }
            }
        }

        public override T GetById(object key)
        {
            return DbSet.Find(key);
        }

        public override IQueryable Query(Expression> predicate)
        {
            return DbSet.Where(predicate);
        }

        public override IQueryable GetAll()
        {
            return Context.Set();
        }

        public override int SaveChanges(bool validateEntities)
        {
            Context.Configuration.ValidateOnSaveEnabled = validateEntities;
            return Context.SaveChanges();
        }

        #region IDisposable implementation

        public override void Dispose()
        {
            if (Context != null)
            {
                Context.Dispose();
                GC.SuppressFinalize(this);
            }
        }

        #endregion IDisposable implementation
    }

At this point I am able to start creating individual repositories that are needed and add a Unit of Work.  Stay tuned for the next installment in my path to creating a Repository Pattern against EF5.