EFCoreExtension 1.8.0

This package is used for generic repository and mapping entity with models

// Install package in project

// Handle dependency injection. Write this code in startup class or in program class (.NET 6)

services.AddScoped(typeof(IRepository<>), typeof(Repository<>)); services.AddScoped(typeof(IGetService<>), typeof(GetService<>)); services.AddScoped(typeof(ICrudService<>), typeof(CrudService<>)); //Create generic repository for entity

EntityName (entity class name - Account)

public class EntityNameRepositoryService : CrudService<EntityName>, IEntityNameRepositoryService { public EntityNameRepositoryService(IRepository<EntityName> repository) : base(repository) { } }

public interface IEntityNameRepositoryService : ICrudService<EntityName> { } // Use repository services

................................

private readonly IEntityNameRepositoryService _entityNameRepositoryService;

public HomeController(IEntityNameRepositoryService entityNameRepositoryService) { this._entityNameRepositoryService = entityNameRepositoryService; }

{

var item = _entityNameRepositoryService.Get(x ⇒ x.ID == Id); var items = _entityNameRepositoryService.GetAll(x ⇒ x.Name == "name");

              .Add(entityItem)
              .Update(entityItem);
              .Delete(x => x.ID == Id)

}

For execute stored procedure follow these steps :- Make a model with fields as stored procedure result

public class SP_Name_Result { public long ID { get; set; } public string Name { get; set; } public long Col1 { get; set; } public int Col2 { get; set; } public DateTime DateCol { get; set; } }

Then make class for execute functions

using EFCoreExtension.Extensions;

using EFCoreExtension.Utility;

using Microsoft.EntityFrameworkCore;

public static class ExecuteSPExtensions {

public static async Task<IList<SP_Name_Result>> SP_Name(this DbContext _context, long? Param1, int? Param2, string Param3)
{

     var param1Parameter = Param1.HasValue ?
         new ObjectParameter("Param1", Param1) :
        new ObjectParameter("Param1", typeof(long));

    var param2Parameter = Param2.HasValue ?
        new ObjectParameter("Param2", Param2) :
        new ObjectParameter("Param2", typeof(int));

    var param3Parameter = Param3 != null ?
        new ObjectParameter("Param3", Param3) :
        new ObjectParameter("Param3", typeof(string));

    return await _context.ExecuteFunctionAsync<SP_Name_Result>("SP_Name", param1Parameter, param2Parameter , param3Parameter );
}

}

Call function ----

var _result = (await _context.SP_Name( param1, param2, param3));