Implementing Single CRUD operation for more than 30 of tables

Question

One of my questions is closed due to insufficient information so I written another with detail.

I want to write a blazor app in c# & .netCore plateform using Visual Studio 2022.

Such app will be operated as Inventory/Financial Management System, CRM, HRM etc. so this system is based on more than 30 tables where the date will be saved via CRUD operation.

Here the question is how I can implement single CRUD for all these tables like same UpdateTable function (with parameters) will be usable to update the tables like Customer, Supplier, Products etc in my database.

something like below..

function DbSet UpdateTable(DbSet tableName)
 {
   _context.Update(tableName);
 }

Actually this will help me save my time to write several lines of code /(I mean writing CRUD) for each and every table

thanks in advance

Take a look at this article of mine describing how to build a generic data pipeline. codeproject.com/Articles/5350000/… — MrC aka Shaun Curtis
– MrC aka Shaun Curtis, Commented Oct 31, 2023 at 21:22

dani herrera · Accepted Answer · 2023-10-31 10:08:46Z

It looks you are looking for Entity Framework Core Generic Repository:

The advantage of having generic CRUD repository is that you can inherit from it, pass it entity type and you have CRUD repository for any entity type with a minimal amount of code.

public interface IGenericRepository<TEntity>
 where TEntity : class, IEntity
{
    IQueryable<TEntity> GetAll();

    Task<TEntity> GetById(int id);

    Task Create(TEntity entity);

    Task Update(int id, TEntity entity);

    Task Delete(int id);
}


public class GenericRepository<TEntity> : IGenericRepository<TEntity>
    where TEntity : class, IEntity
{
    private readonly CodingBlastDbContext _dbContext;

    public GenericRepository(CodingBlastDbContext dbContext)
    {
        _dbContext = dbContext;
    }

    // ... Other CRUD ops

    public async Task Update(int id, TEntity entity)
    {
        _dbContext.Set<TEntity>().Update(entity);
        await _dbContext.SaveChangesAsync();
    }

}

Read the blog to learn how to create the generic repository. But, be carefully. Because you are using Blazor, you should deal with Blazor A second operation started on this context before a previous operation completed

Collectives™ on Stack Overflow

Implementing Single CRUD operation for more than 30 of tables

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related