EFCore.Data.Repository 1.0.3

EFCore.Data.Repository

Repository written in C# for EntityFrameworkCore.

I can guess that you are encountering more than one repository. You can simply use the repository I have prepared in your projects. You can use directly generic repository while injecting in ctor. Since it's already generic, you only need to provide an entity. Let's setup it together.

###How to setup?

#####1. Creating Entity

    public class User
    {
        public Guid Identifier { get; set; }
        public string Username { get; set; }
        public string PasswordHash { get; set; }
        public string Email { get; set; }
    }

#####2.Creating Basic DbContext

public class ApplicationDbContext : DbContext
{
    private readonly IConfiguration _configuration;

    public ApplicationDbContext(IConfiguration configuration)
    {
        _configuration = configuration;
    }

    public DbSet<User> Users { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder options)
    {
        // Replace with your connection string.
        var connectionString = _configuration.GetConnectionString("TestDbConnection");

        options.UseSqlServer(connectionString);
    }

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        modelBuilder.Entity<User>();
    }
}

#####3.Creating Controller and Injecting Repository

[Route("api/[controller]")]
[ApiController]
public class UserController : ControllerBase
{
    private readonly IRepository<User> _repository;

    public UserController(IRepository<User> repository)
    {
        _repository = repository;
    }
}

#####3.Creating Endpoint and Using Repository with CRUD Operation

[Route("api/[controller]")]
[ApiController]
public class UserController : ControllerBase
{
    private readonly IRepository<User> _repository;

    public UserController(IRepository<User> repository)
    {
        _repository = repository;
    }

        #region Read

        [HttpGet]
        public async Task<IActionResult> GetAsync()
        {
            // Get list of data
            var data = await _repository.GetListAsync();

            return Ok(data);
        }

        [HttpGet("{id}")]
        public async Task<IActionResult> GetAsync(Guid id)
        {
            // Get data by id
            var data = await _repository.GetFirstOrDefaultAsync(x => x.Identifier == id);

            return Ok(data);
        }

        #endregion

        #region Create

        [HttpPost]
        public async Task<IActionResult> PostAsync(User user)
        {
            // Create
            await _repository.AddAsync(user);

            return Ok();
        }

        #endregion

        #region Update

        [HttpPut("{id}")]
        public async Task<IActionResult> PutAsync(User user)
        {
            // Get entity
            var entity = await _repository.GetFirstOrDefaultAsync(x => x.Identifier.Equals(user.Identifier));

            // Set new values
            entity.Username = user.Username;
            entity.Email = user.Email;
            entity.PasswordHash = user.PasswordHash;

            // Update
            await _repository.UpdateAsync(user);

            return NoContent();
        }

        #endregion

        #region Delete

        [HttpDelete("{id}")]
        public async Task<IActionResult> DeleteAsync(Guid id)
        {
            // Get entity
            var entity = await _repository.GetFirstOrDefaultAsync(x => x.Identifier.Equals(id));

            // Delete
            await _repository.DeleteAsync(entity);

            return Ok();
        }

        #endregion
}

#####4.DI container Registration

...
services.AddTransient<IRepository<User>, Repository<ApplicationDbContext, User>>();
...

Finally we did it. It will be continued to develop. You can fork. I will make a youtube video.