EFRepo.EntityFramework.Core 1.3.3

EFRepo.EntityFrameworkCore

EFRepo generic repository implemented with .Net core 6

Installation

Install-Package EFRepo.EntityFramework.Core -Version 1.3.3

Update description

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

• Update package to .net 6
• Update Redis cache for repository

Usage

The library using repository Pattern source code organization. So, to using you need create Interface Base include repositories and implement that interface.

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 base class 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 cache services

//Your data context
public yourContext _context;
private EnCache enCache = EnCache.MemoryCache;
private Func<EnCache, ICacheService> _cacheService;
public IplAbc(yourContext context, IConfiguration configuration, Func<EnCache, ICacheService> cacheService) : base(context)
{
    _Configuration = configuration;
    _context = context;
     _cacheService = cacheService;
}
public Abc GetDataUsingCache(Expression<Func<Abc,bool>> expression, string keyCache="")
    {
            Abc data = new Abc();
        if (!string.IsNullOrEmpty(keyCache))
        {
            data = _cacheService(enCache).Get<Abc>(keyCache);
            if (data != null)
                return data;
            else
            {
                data = new AbcRepository(_context, _Configuration, _cacheService).Read(expression);
                _cacheService(enCache).Set(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