AegisInt.EntityFrameworkCore 2.0.3

AegisInt.EntityFrameworkCore

Dapper Integration for AegisInt.Core

• Automatically applies Value Converters to EncryptedInt and EncryptedInt? properties so they are stored as INT in the database but used as encrypted structs in your domain.

Installation

dotnet add package AegisInt.EntityFrameworkCore

Setup

1. Configure Core (Program.cs)

builder.Services.AddAegisInt(options => 
{
    options.Salt = "my-super-secret-production-salt"; // Required
    options.Alphabet = "aGbIJK3VWXYcfgmn14opL!MNO#Sqr2D-FEstuhBC9ijk67lvPQRw5dTUexy8zAHZ0"; // optional
    options.MinLength = 6; // optional
});

2. Configure DbContext

Override ConfigureConventions in your DbContext to apply the converter globally.

protected override void ConfigureConventions(ModelConfigurationBuilder configurationBuilder)
{
    // Automatically handles all EncryptedInt properties
    configurationBuilder.UseAegisIntEncryption();
}

Usage

Once configured with configurationBuilder.UseAegisIntEncryption(), EF Core handles the translation transparently in all LINQ queries.

1. Define your DTO

public class UserDto
{
    public EncryptedInt Id { get; set; }
    public string Name { get; set; }
}

2. Controller (Automatic Binding)

[ApiController]
[Route("api/[controller]")]
public class UsersController : ControllerBase
{
    private readonly IUserRepository _repository;

    public UsersController(IUserRepository repository) => _repository = repository;

    // GET /api/users/Nk7xR
    // "Nk7xR" is automatically decrypted to 101
    [HttpGet("{id}")]
    public IActionResult Get([FromRoute] EncryptedInt id)
    {
        var user = _repository.GetById(id);   
        if (user == null) return NotFound();
        return Ok(new UserDto { Id = user.Id, Name = user.Name });
    }
}

3. Repository (EntityFrameworkCore)

public class UserRepository : IUserRepository
{
    public async Task<UserDto?> GetById(EncryptedInt id)
    {
        // Generates: SELECT * FROM Users WHERE Id = @id (as int)
        return await _context.UsersDto
            .FirstOrDefaultAsync(u => u.Id == searchId);
    }

    public async Task<UserDto> ListUser()
    {
        return await _context.UserDto.ToList();
    }
}

3. What the Client Sees

Request (GET): GET /api/users/Nk7xR Response:

{
  "id": "Nk7xR",
  "name": "John Doe",
  "email": "john@example.com"
}