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
- Advanced Queries - In-depth filtering, pagination, and aggregation
- Relations & Joins - One-to-many and many-to-many relations
- Database Providers - Provider dialect specifics
- Client Languages - Complete language runtime specifications