MiniUow 3.0.0

Generic Repository Pattern and Unit Of Work for C# .net Core

A simple lean & clean generic repository pattern and unit of work for .net core abstraction layer EntityFramework Core.

MiniUow supports the following platforms:

.NET Platform Standard

.NET Core

Installation

The simplest method to install MiniUow into your solution/project is to use NuGet.:

    nuget Install-Package MiniUow

Or via the DotNet Cli

    dotnet add package MiniUow

Check out Nuget package page for more details.

Documentation

Startup.cs

//Use the MiniUow Dependency Injection to set up the Unit of Work.
//using MiniUow.DependencyInjection;
public void ConfigureServices(IServiceCollection services)
{
    //---------Other Code-----------
	//.AddUnitOfWork<SampleContext>();

    //Sample for SQL Server:
    services.AddDbContext<SampleContext>(options =>
        options.UseSqlServer(Configuration.GetConnectionString("SampleDatabase"))).AddUnitOfWork<SampleContext>();

	//Sample for Postgresql:
    //services.AddEntityFrameworkNpgsql().AddDbContext<SampleContext>(opt =>
    //    opt.UseNpgsql(Configuration.GetConnectionString("SampleDatabase"))).AddUnitOfWork<SampleContext>();

    //Sample for MySQL:
    //services.AddDbContext<SampleContext>(options =>
    //    options.UseMySql(Configuration.GetConnectionString("SampleDatabase"))).AddUnitOfWork<SampleContext>();
    //---------Other Code-----------
}

Controller or Services

private readonly IUnitOfWork _uow;
public ClassConstructor(IUnitOfWork unit)
{
    _uow = unit;
}

public async Task ActionMethod(string value)
{
    //Demo Exists method
    bool isExists = _uow.GetRepository<TblUser>().Exists(p => p.Username == value);
    isExists = await _uow.GetRepository<TblUser>().ExistsAsync(p => p.Username == value);

    //Get with size
    var query = _uow.GetRepository<TblUser>().GetPagedList(index: 0, size: int.MaxValue);

    //Get with predicate
    var data = _uow.GetRepository<TblUser>().GetPagedList(
       predicate: p => p.Username.Contains(value) || p.Email.Contains(value) || p.Name.Contains(value),
       orderBy: p => p.OrderBy(p => p.Username),
       include: p => p.Include(x => x.TblUserGroup),
       index: 0,
       size: 20);

    //Get with predicate dynamic
    var data = _uow.GetRepository<TblUser>().GetPagedList(
       predicate: "Username = '" + value + "'",
       orderBy: "Username desc"),
       include: p => p.Include(x => x.TblUserGroup),
       index: 0,
       size: 20);

    //Get with predicate and return another Class
    var items = _uow.GetRepository<TblUser>().GetPagedList(b => new { Username = b.Username, Name = b.Name });
}

public TblUser Create()
{
    var user = new TblUser();
    user.Username = "MiniUow";
    user.CreateDate = DateTime.Now;
    var data = _uow.GetRepository<TblUser>().Add(user);
    _uow.SaveChanges();
    return data;
}

public void Update(string value)
{
    // If update data get funtion, need add disableTracking: false because default is true
    var user = _uow.GetRepository<TblUser>().FirstOrDefault( p=> p.Username == value, disableTracking: false);
    user.UpdateDate = DateTime.Now;
    var data = _uow.GetRepository<TblUser>().Update(user);
    _uow.SaveChanges();
}

License

MiniUow is developed and supported for free.