Keisoft.Chat.Repositorys 9.0.2

A Repository pattern implementation leveraging Entity Framework Core, tailored for the backend microservices architecture of a messaging platform.

// Inherits from the RepositoryBase class.
public class DemoRepository : RepositoryBase<DemoEntity>, IDemoRepository
{
    public DemoRepository(AppDbContext dbContext) : base(dbContext)
    {

    }
}

// Your business implementation class.
public class DemoService : IDemoService
{
    private readonly IDemoRepository _demoRepository;
    
	public DemoService(IDemoRepository demoRepository) 
    {
        _demoRepository = demoRepository;
    }
    
    // Usage example:
    public async Task Tests() 
    {
        // Counts all entities in the repository.
        var count1 = await _demoRepository.CountAsync();
        
        // Counts entities matching a specific condition.
        var count2 = await _demoRepository.CountAsync(a => a.Id == 1);
        
        // Inserts a single entity and returns the generated ID.
        var entity = await _demoRepository.InsertAsync(new DemoEntity { Name = "Demo" });
        
        // Inserts a collection of entities.
        await _demoRepository.InsertRangeAsync(new List<Certificate>
        {
            new Certificate { Name = "Demo" }
        });
        
        // Deletes a specific entity instance.
        await _demoRepository.DeleteAsync(entity);
        
        // Deletes entities matching a specific condition.
        await _demoRepository.DeleteAsync(a => a.Id == 1);
        
        // Updates specified fields of an entity.
        await _demoRepository.UpdateAsync(entity, a => new { a.Name, a.DateTime });
        
        // Finds a single entity matching the condition.
        var entitySingle = await _demoRepository.FindAsync(a => a.Id == 1);
        
        // Gets a list of entities matching the condition.
        var entityList = await _demoRepository.GetListAsync(a => a.Id == 1);
         
        // Gets a list ordered by descending based on specified criteria and a condition.
        var orderByEntityList = await _demoRepository.OrderByDescendingGetListAsync(a => new { a.Id }, a => a.Id == 1);

        // Executes raw SQL.
        var rowCount = await _demoRepository.RawAsync("UPDATE DemoEntity SET Name = @Name WHERE Id = @Id", new 
        {
            Name = "Demo", 
            Id = 1 
        });
    }
}