EFRepo.EntityFramework.Core 1.3.8

EFRepo.EntityFrameworkCore

EFRepo generic repository implemented with .Net core 8. The library uses the repository pattern source code organization. So to use it you need to create an interface base that includes the repository and implement that interface. The library makes it easy to use both Linq or ADO with SQL queries or stored procedures.

Installation

Install-Package EFRepo.EntityFramework.Core -Version 1.3.5

Update description

in this version of events, package updated some feature such as:

• Update package to .net 8
• Integrate Redis services
• Update Redis cache for repository
• Optimize Repository
• Optimize UnitOfWork for Query T-SQL (store proceduce, query raw,...)

Usage

How to use?

You need make sure Interface and Implement class to included repository pattern

Step 1: make interface class in your project

interface IAbc : IRepository<Abc>

Step 2: make implement class in your project

public class IplAbc: Repository<Abc>, IAbc

public IConfiguration _Configuration { get; }

//Your data context
public yourContext _context;
public IplAbc(yourContext context, IConfiguration configuration) : base(context)
{
    _Configuration = configuration;
    _context = context;
}
//override this function to use transaction control
public override void SaveChange()
{
    base.SaveChange();
}

Step 3: make unitofwork to declare the repositories in your project

public interface IBase

 IAbc abcRepository { get; } 

public class BaseImplement : IBase
    private YourDbContext _dbContext;
    private IAbc _abcRepository;       
    public IConfiguration _Configuration { get; }
    public IplBase(YourDbContext dbContext, IConfiguration configuration)
    {
        _dbContext = dbContext;
        _Configuration = configuration;
    }
    public IAbc abcRepository
    {
        get
        {
            return _abcRepository ?? (_abcRepository = new IplAbc(_dbContext, _Configuration));
        }
    }
    //Other repositories

Step 4: Usage

IBase _ibase;

public AbcController(IBase @base){
        _ibase = @base;
    }

public IActionResult Index(int id)
    {
        Expression<Func<abc, bool>> mypredicate = (o => o.Id == id);
        var data =  _ibase.contentsRepository.Read(mypredicate);

        return View(data);
    }      

Integration Execute Query Multiple Async using only Procedure of SQL server.

async Task<dynamic> ExecuteQueryMultipleAsync(string spName, object param = null, IEnumerable<MapItem> mapItems = null)

Usage

var unitOfWork = new UnitOfWorkFactory(_cnnString);
using (var u = unitOfWork.Create(false))
{
    var mapItems = new List<MapItem>()
    {
        new MapItem(typeof(CustomerEntity), DataRetriveTypeEnum.FirstOrDefault, "CustomerEntity"),
        new MapItem(typeof(ContractEntity), DataRetriveTypeEnum.List, "ContractEntity"),
    };
    var p = new DynamicParameters();
    p.Add("@CutomerId", CutomerId, DbType.Int32);
    var response = await u.ExecuteQueryMultipleAsync(TSQL.GET_CUSTOMER_VIEW, p, mapItems);
    var property = (IDictionary<String, Object>)response;
    entity.CustomerEntity = (CustomerEntity)property["CustomerEntity"];
    entity.ContractEntity = ((List<dynamic>)property["ContractEntity"]).OfType<ContractEntity>().ToList();
}

How to integrated redis services

//Your data context
public yourContext _context;
private EnCache enCache = EnCache.MemoryCache;
private Func<EnCache, ICacheService> _cacheService;
public IplAbc(yourContext context, IConfiguration configuration, IDatabase rd) : base(context)
{
        _context = context;
        _configuration = configuration;
        _cnnString = _configuration.GetConnectionString("DefaultConnection");

        if (rdb != null)
        {
            _redisDb = rdb;
            cacheService = new CacheServices(_redisDb);
        }
}
public Abc GetDataUsingCache(Expression<Func<Abc,bool>> expression, string keyCache="")
    {
        Abc data = new Abc();
        if (!string.IsNullOrEmpty(keyCache) && _redisDb != null)
        {                
            data = cacheService.Get<Abc>(keyCache);
            if (data != null)
                return data;
            else
            {
                data = new AbcRepository(_context, _Configuration, _cacheService).Read(expression);
                cacheService.Set<Abc>(keyCache, data);
            }
        }
        else
        {
            data = new AbcRepository(_context, _Configuration, _cacheService).Read(expression);
        }
        return data;
    }

Contributing

Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.

Please make sure to update tests as appropriate.

License

MIT