c mysql ef 三层架构_EF 三层架构 简单示例

[c#]代码库using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace DAL

{

public partial class Test2Entities : System.Data.Entity.DbContext

{

public Test2Entities()

: base("name=Test2Entities")

{

Database.SetInitializer(new System.Data.Entity.CreateDatabaseIfNotExists());

}

protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)

{

//modelBuilder.Conventions.Remove();

}

public virtual DbSet RoleSet { get; set; }

public virtual DbSet UserSet { get; set; }

}

public static class GetDbContext

{

static Test2Entities _Test2DbContext = new Test2Entities();

public static Test2Entities Test2DbContext

{

get { return _Test2DbContext; }

}

}

public class RepositoryBase : ModelL.IRepository where T : class, new()

{

Test2Entities _Test2DbContext = GetDbContext.Test2DbContext;

public T Create()

{

return _Test2DbContext.Set().Create();

}

public T Update(T entity)

{

return entity;

}

public T Insert(T entity)

{

return _Test2DbContext.Set().Add(entity);

}

public void Delete(T entity)

{

_Test2DbContext.Set().Remove(entity);

}

public ModelL.ReturnMsg SaveChange()

{

ModelL.ReturnMsg rm = new ModelL.ReturnMsg();

try

{

int i = _Test2DbContext.SaveChanges();

rm.ErrCode = 0;

rm.Successful = true;

rm.ErrMsg = "";

}

catch (Exception exc)

{

rm.ErrCode = exc.HResult;

rm.Successful = false;

rm.ErrMsg = exc.Message;

}

return rm;

}

public T Find(params object[] keyValues)

{

return _Test2DbContext.Set().Find(keyValues);

}

public T Find(Func predict)

{

return _Test2DbContext.Set().FirstOrDefault(predict);

}

public List FindAll(Func predict)

{

return _Test2DbContext.Set().Where(predict).ToList();

}

public List FindAll()

{

return _Test2DbContext.Set().ToList();

}

}

public class RoleRepository : DAL.RepositoryBase

{

}

public class UserRepository : DAL.RepositoryBase

{

}

}

[源代码打包下载]

EF_Demo.rar(50积分)[2 次下载]