ASP.Net Core基于EF6、Unitwork、Autofac實現(xiàn)Repository模式
更新時間：2022年02月16日 11:42:04 作者：Run2948
這篇文章介紹了ASP.Net Core基于EF6、Unitwork、Autofac實現(xiàn)Repository模式的方法，文中通過示例代碼介紹的非常詳細。對大家的學習或工作具有一定的參考借鑒價值，需要的朋友可以參考下
一、實現(xiàn)的思路和結(jié)構(gòu)圖
- Repository的共同性
有一些公共的方法(增刪改查)， 這些方法無關(guān)于Repository操作的是哪個實體類，可以把這些方法定義成接口IRepository，然后有個基類BaseRepository實現(xiàn)該接口的方法。常見的方法，比如Find, Filter, Delete, Create等
- Repository的差異性
每個Repository類又會有一些差異性，應(yīng)當允許它們能夠繼承BaseRepository之外，還能夠再擴展自己的一些方法。所以每個類都可以再定義一個自己特有的接口，定義一些屬于自己Repository的方法。
- Repository的協(xié)同性
不同的Repository可能需要協(xié)同，Repository對數(shù)據(jù)的修改，需要在統(tǒng)一的保存.
最終實現(xiàn)的類結(jié)構(gòu)圖如下:
二、Repository設(shè)計具體的實現(xiàn)代碼
IRepository接口定義了Repository共有的方法, BaseRepository實現(xiàn)了這些接口的方法。其它的Repository類再集成BaseRepository方法，就天然的得到了對數(shù)據(jù)操作的基本方法。
- IRepository代碼
public interface IRepository<TEntity> where TEntity : class
{
/// <summary>
/// Gets all objects from database
/// </summary>
/// <returns></returns>
IQueryable<TEntity> All();
/// <summary>
/// Gets objects from database by filter.
/// </summary>
/// <param name="predicate">Specified a filter</param>
/// <returns></returns>
IQueryable<TEntity> Filter(Expression<Func<TEntity, bool>> predicate);
/// <summary>
/// Gets objects from database with filtering and paging.
/// </summary>
/// <param name="filter">Specified a filter</param>
/// <param name="total">Returns the total records count of the filter.</param>
/// <param name="index">Specified the page index.</param>
/// <param name="size">Specified the page size</param>
/// <returns></returns>
IQueryable<TEntity> Filter(Expression<Func<TEntity, bool>> filter, out int total, int index = 0, int size = 50);
/// <summary>
/// Gets the object(s) is exists in database by specified filter.
/// </summary>
/// <param name="predicate">Specified the filter expression</param>
/// <returns></returns>
bool Contains(Expression<Func<TEntity, bool>> predicate);
/// <summary>
/// Find object by keys.
/// </summary>
/// <param name="keys">Specified the search keys.</param>
/// <returns></returns>
TEntity Find(params object[] keys);
/// <summary>
/// Find object by specified expression.
/// </summary>
/// <param name="predicate"></param>
/// <returns></returns>
TEntity Find(Expression<Func<TEntity, bool>> predicate);
/// <summary>
/// Create a new object to database.
/// </summary>
/// <param name="t">Specified a new object to create.</param>
/// <returns></returns>
void Create(TEntity t);
/// <summary>
/// Delete the object from database.
/// </summary>
/// <param name="t">Specified a existing object to delete.</param>
void Delete(TEntity t);
/// <summary>
/// Delete objects from database by specified filter expression.
/// </summary>
/// <param name="predicate"></param>
/// <returns></returns>
int Delete(Expression<Func<TEntity, bool>> predicate);
/// <summary>
/// Update object changes and save to database.
/// </summary>
/// <param name="t">Specified the object to save.</param>
/// <returns></returns>
void Update(TEntity t);
/// <summary>
/// Select Single Item by specified expression.
/// </summary>
/// <param name="expression"></param>
/// <returns></returns>
TEntity FirstOrDefault(Expression<Func<TEntity, bool>> expression);
}- BaseRepository代碼
public class BaseRepository<TEntity> : IRepository<TEntity> where TEntity : class
{
protected readonly DbContext Context;
public BaseRepository(DbContext context)
{
Context = context;
}
/// <summary>
/// Gets all objects from database
/// </summary>
/// <returns></returns>
public IQueryable<TEntity> All()
{
return Context.Set<TEntity>().AsQueryable();
}
/// <summary>
/// Gets objects from database by filter.
/// </summary>
/// <param name="predicate">Specified a filter</param>
/// <returns></returns>
public virtual IQueryable<TEntity> Filter(Expression<Func<TEntity, bool>> predicate)
{
return Context.Set<TEntity>().Where<TEntity>(predicate).AsQueryable<TEntity>();
}
/// <summary>
/// Gets objects from database with filtering and paging.
/// </summary>
/// <param name="filter">Specified a filter</param>
/// <param name="total">Returns the total records count of the filter.</param>
/// <param name="index">Specified the page index.</param>
/// <param name="size">Specified the page size</param>
/// <returns></returns>
public virtual IQueryable<TEntity> Filter(Expression<Func<TEntity, bool>> filter, out int total, int index = 0,
int size = 50)
{
var skipCount = index * size;
var resetSet = filter != null
? Context.Set<TEntity>().Where<TEntity>(filter).AsQueryable()
: Context.Set<TEntity>().AsQueryable();
resetSet = skipCount == 0 ? resetSet.Take(size) : resetSet.Skip(skipCount).Take(size);
total = resetSet.Count();
return resetSet.AsQueryable();
}
/// <summary>
/// Gets the object(s) is exists in database by specified filter.
/// </summary>
/// <param name="predicate">Specified the filter expression</param>
/// <returns></returns>
public bool Contains(Expression<Func<TEntity, bool>> predicate)
{
return Context.Set<TEntity>().Any(predicate);
}
/// <summary>
/// Find object by keys.
/// </summary>
/// <param name="keys">Specified the search keys.</param>
/// <returns></returns>
public virtual TEntity Find(params object[] keys)
{
return Context.Set<TEntity>().Find(keys);
}
/// <summary>
/// Find object by specified expression.
/// </summary>
/// <param name="predicate"></param>
/// <returns></returns>
public virtual TEntity Find(Expression<Func<TEntity, bool>> predicate)
{
return Context.Set<TEntity>().FirstOrDefault<TEntity>(predicate);
}
/// <summary>
/// Create a new object to database.
/// </summary>
/// <param name="t">Specified a new object to create.</param>
/// <returns></returns>
public virtual void Create(TEntity t)
{
Context.Set<TEntity>().Add(t);
}
/// <summary>
/// Delete the object from database.
/// </summary>
/// <param name="t">Specified a existing object to delete.</param>
public virtual void Delete(TEntity t)
{
Context.Set<TEntity>().Remove(t);
}
/// <summary>
/// Delete objects from database by specified filter expression.
/// </summary>
/// <param name="predicate"></param>
/// <returns></returns>
public virtual int Delete(Expression<Func<TEntity, bool>> predicate)
{
var objects = Filter(predicate);
foreach (var obj in objects)
Context.Set<TEntity>().Remove(obj);
return Context.SaveChanges();
}
/// <summary>
/// Update object changes and save to database.
/// </summary>
/// <param name="t">Specified the object to save.</param>
/// <returns></returns>
public virtual void Update(TEntity t)
{
try
{
var entry = Context.Entry(t);
Context.Set<TEntity>().Attach(t);
entry.State = EntityState.Modified;
}
catch (OptimisticConcurrencyException ex)
{
throw ex;
}
}
/// <summary>
/// Select Single Item by specified expression.
/// </summary>
/// <param name="expression"></param>
/// <returns></returns>
public TEntity FirstOrDefault(Expression<Func<TEntity, bool>> expression)
{
return All().FirstOrDefault(expression);
}
}IUnitOfWork接口定義了方法獲取特定的Repository, 執(zhí)行存儲過程, SaveChange方法提交修改，統(tǒng)一更新數(shù)據(jù)。
- IUnitOfWork接口代碼:
public interface IUnitOfWork : IDisposable
{
DbContext DbContext { get; }
TRepository GetRepository<TRepository>() where TRepository : class;
void ExecuteProcedure(string procedureCommand, params object[] sqlParams);
void ExecuteSql(string sql);
List<T> SqlQuery<T>(string sql);
void SaveChanges();
}UnitOfWork代碼, 代碼中使用到了Autofac中的IComponentContext來獲取Repository實例
public class UnitOfWork : IUnitOfWork
{
private readonly IComponentContext _componentContext;
protected readonly DbContext Context;
public UnitOfWork(DbContext context, IComponentContext componentContext)
{
Context = context;
_componentContext = componentContext;
}
public DbContext DbContext => Context;
public TRepository GetRepository<TRepository>() where TRepository : class
{
return _componentContext.Resolve<TRepository>();
}
public void ExecuteProcedure(string procedureCommand, params object[] sqlParams)
{
Context.Database.ExecuteSqlCommand(procedureCommand, sqlParams);
}
public void ExecuteSql(string sql)
{
Context.Database.ExecuteSqlCommand(sql);
}
public List<T> SqlQuery<T>(string sql)
{
return Context.Database.SqlQuery<T>(sql).ToList();
}
public void SaveChanges()
{
try
{
Context.SaveChanges();
}
catch (InvalidOperationException ex)
{
if (!ex.Message.Contains("The changes to the database were committed successfully"))
{
throw;
}
}
}
public void Dispose()
{
Context?.Dispose();
}
}三、Repository設(shè)計的具體的使用
這里我們定義一個
IStudentRepository接口, 包含了方法GetAllStudents(), 同時繼承于IRepository<Student>接口
public interface IStudentRepository : IRepository<Student>
{
IEnumerable<dynamic> GetAllStudents();
}接著定義StudentRepository類來實現(xiàn)這個接口
public class StudentRepository : BaseRepository<Student>, IStudentRepository
{
private readonly SchoolContext _context;
public StudentRepository(SchoolContext context)
: base(context)
{
_context = context;
}
public IEnumerable<dynamic> GetAllStudents()
{
return _context.Students;
}
}- 在
Application_Start方法中使用Autofac注冊Repository的代碼如下：
var builder = new ContainerBuilder();
//register controllers
builder.RegisterControllers(typeof(MvcApplication).Assembly);
//register repository
builder.RegisterAssemblyTypes(Assembly.GetExecutingAssembly()).AsImplementedInterfaces();
//add the Entity Framework context to make sure only one context per request
builder.RegisterType<SchoolContext>().InstancePerRequest();
builder.Register(c => c.Resolve<SchoolContext>()).As<DbContext>().InstancePerRequest();
var container = builder.Build();
DependencyResolver.SetResolver(new AutofacDependencyResolver(container));- 在控制器中注入使用Repository的代碼如下:
private readonly IUnitOfWork _repositoryCenter;
private readonly IStudentRepository _studentRepository;
public HomeController(IUnitOfWork repositoryCenter)
{
_repositoryCenter = repositoryCenter;
_studentRepository = _repositoryCenter.GetRepository<IStudentRepository>();
}
public ActionResult Index(Student sessionStudent)
{
var students = _studentRepository.GetAllStudents();
// 同時你也可以使用定義于IRepository<Student>中的方法， 比如:
_studentRepository.Delete(students.First());
_repositoryCenter.SaveChanges();
...
return View(students);
}四、思路總結(jié)
上面的設(shè)計，把Repository的通用代碼剝離到父類中，同時又允許每個Repository擴展自己的方法，達到了比較理想的狀態(tài)。
只是現(xiàn)在的設(shè)計和Autofac耦合了，但是如果想繼續(xù)剝離Autofac直接使用 _repositoryCenter.GetRepository<IStudentRepository>(); 的方式獲取IStudentRepository的實例就很困難了。
五、案例源碼
源代碼倉庫 AutoFacMvc
到此這篇關(guān)于ASP.Net Core基于EF6、Unitwork、Autofac實現(xiàn)Repository模式的文章就介紹到這了。希望對大家的學習有所幫助，也希望大家多多支持腳本之家。
相關(guān)文章
.NET CORE動態(tài)調(diào)用泛型方法詳解
這篇文章主要為大家詳細介紹了.NET CORE動態(tài)調(diào)用泛型方法，具有一定的參考價值，感興趣的小伙伴們可以參考一下2017-08-08
文件上傳在asp.net中有很多方法，這里我很給各位介紹最簡單最方便的.net文件上傳實例，希望給各位.net入門者帶來幫助2014-01-01
兩級聯(lián)動實現(xiàn)代碼2009-01-01
.NET截取指定長度漢字超出部分以"..."代替 實例分享，需要的朋友可以參考一下2013-06-06
這篇文章主要介紹了ASP.net處理XML數(shù)據(jù)實例淺析,分析了XML的原理與用法,并以實例形式講述了asp.net處理XML數(shù)據(jù)的方法,需要的朋友可以參考下2014-10-10
web.config配置 前后臺文件等代碼2009-01-01
asp.net實現(xiàn)生成靜態(tài)頁并添加鏈接的方法
這篇文章主要介紹了asp.net實現(xiàn)生成靜態(tài)頁并添加鏈接的方法,非常實用的功能,需要的朋友可以參考下2014-07-07
asp.net得到本機數(shù)據(jù)庫實例的兩種方法代碼
這篇文章介紹了asp.net得到本機數(shù)據(jù)庫實例的兩種方法代碼，有需要的朋友可以參考一下2013-07-07
ASP.NET Core通用主機實現(xiàn)托管服務(wù)
這篇文章介紹了ASP.NET Core通用主機實現(xiàn)托管服務(wù)的方法，文中通過示例代碼介紹的非常詳細。對大家的學習或工作具有一定的參考借鑒價值，需要的朋友可以參考下2022-07-07
gRPC 一開始由 google 開發(fā)，是一款語言中立、平臺中立、開源的遠程過程調(diào)用(RPC)系統(tǒng)，所以叫g(shù)(google)RPC，這篇文章主要介紹了.NET?Core中使用gRPC,需要的朋友可以參考下2022-09-09