Generic.RepositoryAsync.EFCore 1.0.0

Generic.Repository.EFCore

This is a Generic Repository Async make using EFCore 2.2.4

Code Quality - Master Travis CI - Master

This version is final.

This project has objective to made a CRUD more easily. Adding an extra layer of abstraction in application. This project has building using the best programmation pratices.

Principles used:

• Reactive progammation;
• DRY principle;
• SOLID principles.

Add an generic layer of abstraction in application.

This project is builded in asp.net standard and has the dependencies below:

• Microsoft.EntityFrameworkCore (>= 2.2.4)

V.1.0.0

An new project has born..

DOCS

To use this package is necessary make this steps:

Step 1

On startup project yor will add this

 public void ConfigureServices(IServiceCollection services)
       {
          //You can pass empty parameter on here!!! EX: Commom.SetSizeByLengthProperties("", "");
        Commom.SetSizeByLengthProperties("AssemblyName", "Namespace of Entity; Namespace of Filters");
        Commom.SaveOnCacheIfNonExists<TypeEntity>();
        ... rest your code...

Step 2

   //Create your own repository, like this sample:
   //Interface
    public interface ICustomerRepository : IBaseRepositoryAsync<Customer, CustomerFilter>
    {
        IPage<Customer> CustomerPage(IPageConfig config);
    }

   //Implementation   
   public class CustomerRepository : BaseRepositoryAsync<Customer, CustomerFilter>, ICustomerRepository
   {

      public CustomerRepository(LocalDbContext context) : base(context)
      {
         //is this necessary
         includesString = new List<string>();
         //and this... 
         includesExp = new List<Expression<Func<Customer, object>>>();
      }
      // If you will use Pagination
      public IPage<Customer> CustomerPage(IPageConfig config)
      {
         return base._context.Set<Customer>().AsNoTracking().ToPage(config);
      }
   }

   //On startup you will add this:
   services.AddScoped<ICustomerRepository, CustomerRepository>();

   //If you will use auto generation filter you will need implements interface IFilter, like this...
       public class CustomerFilter : IFilter...

Step 3

Now you need add your repository on your Controller.... P.S.: This is a sample, if you want you can add repository on your Service layer and add your Service in your Controller, this is a simple sample.

    [ApiController]
    [Route("api/[controller]")]
    public class CustomerController : ControllerBase
    {
      ///....code...
      ///Filter example
        [HttpGet("filter")]
        public async Task<ActionResult<List<Customer>>> GetAllFilterAsync([FromQuery]CustomerFilter filter)
        {
            try
            {
                var list = await _repo.FilterAllAsync(filter, true);
                if (list.Count() < 1)
                    return NoContent();
                return Ok(list);
            }
            catch (Exception e)
            {
                return BadRequest($"Message: {e.Message} - StackTrace: {e.StackTrace} {(e.InnerException != null ? "InnerException" + e.InnerException : "")}");
            }
        }

        /// Get All example
        [HttpGet]
        public async Task<ActionResult<List<Customer>>> GetAllAsync()
        {
            var list = await _repo.GetAllAsync(true);
            if (list.Count() < 1)
                return NoContent();
            return Ok(list);
        }

        /// <summary>
        /// Get All paginated example
        /// </summary>
        /// <returns></returns>
        [HttpGet("page")]
        public ActionResult<Page<Customer>> GetAllPaginated([FromQuery]PageConfig config)
        {
            try
            {
                return Ok(_repo.CustomerPage(config));
            }
            catch (Exception e)
            {
                return BadRequest($"Message: {e.Message} - StackTrace: {e.StackTrace} {(e.InnerException != null ? "InnerException" + e.InnerException : "")}");
            }
        }

    }