CRUD Operations

AN5 ORM provides a clean, type-safe API for all CRUD operations tailored for Dotnet.


Client Setup

using An5Orm;

var db = new An5DbContext();

1. Create

Create a Single Record

var user = await db.Users.CreateAsync(new UserCreateInput
{
    Email = "john@example.com",
    Name = "John Doe"
});

Create Many Records

var count = await db.Users.CreateManyAsync(new List<UserCreateInput>
{
    new() { Email = "alice@example.com", Name = "Alice" },
    new() { Email = "bob@example.com", Name = "Bob" }
});

2. Read

Find by Primary Key or Unique Field

var user = await db.Users.FindFirstAsync(new UserFindFirstArgs
{
    Where = new UserWhereInput { Email = new StringFilter { Equals = "john@example.com" } }
});

Find Many Records with Filter & Sort

var users = await db.Users.FindManyAsync(new UserFindManyArgs
{
    Where = new UserWhereInput
    {
        IsActive = new BoolFilter { Equals = true },
        Email = new StringFilter { Contains = "@example.com" }
    },
    OrderBy = new UserOrderByInput { CreatedAt = SortOrder.Desc },
    Take = 10
});

3. Update

Update Single Record

await db.Users.UpdateAsync(new UserUpdateArgs
{
    Where = new UserWhereInput { Id = new StringFilter { Equals = user.Id } },
    Data = new UserUpdateInput { Name = "Johnny Doe" }
});

4. Delete

Delete Single Record

await db.Users.DeleteAsync(new UserWhereInput
{
    Id = new StringFilter { Equals = user.Id }
});

Next Steps