QLimitive is an attribute-based primitive SQL generator that respects the Entity Framework Core and is called 'Primitive'.
Support Platform
.NET 6.0+
Attribute-based O/R mapping information
QLimitive performs O/R mapping and generates SQL based on the attributes used in Entity Framework Core.
using System;
using System.ComponentModel;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
namespace SampleApp;
[Table("T_People", Schema = "dbo")]
public sealed class Person
{
[Key]
[DatabaseGenerated(DatabaseGeneratedOption.Identity)]
public int Id { get; init; }
[Column("姓")]
public string LastName { get; init; }
[Column("名")]
public string FirstName { get; init; }
[NotMapped]
public string FullName => $"{this.LastName} {this.FirstName}";
public int Age { get; init; }
public bool HasChildren { get; init; }
[AmbientValue("SYSDATETIME()")]
public DateTimeOffset CreatedAt { get; init; }
[Column("UpdatedAt")]
[AmbientValue("SYSDATETIME()")]
public DateTimeOffset ModifiedAt { get; init; }
}
SQL generation
This library also provides automatic sql generation feature using above meta data. You can get very simple and typical SQL via QueryBuilder class. Of course it's completely type-safe.
// Query records with specified columns that matched specified condition
var sql = QueryBuilder.Select<Person>(DbDialect.SqlServer, x => new { x.LastName, x.Age }).Text;
/*
select
[姓] as [LastName],
[Age] as [Age]
from [dbo].[T_People]
*/
// If wants Where / OrderBy / ThenBy, allows you to write like following
using (var builder = new QueryBuilder<Person>(DbDialect.SqlServer))
{
builder.Select(static x => new { x.Id, x.LastName });
builder.Where(static x => x.LastName == "Suzuki");
builder.OrderByDescending(static x => x.Age);
builder.ThenBy(static x => x.ModifiedAt);
var sql = builder.Build().Text;
}
/*
select
[Id] as [Id],
[姓] as [Name]
from [dbo].[T_People]
where
[姓] = @p1
order by
[Age] desc,
[UpdatedAt]
*/
// Insert record to SQL Server
var sql = QueryBuilder.Insert<Person>(DbDialect.SqlServer, useAmbientValue: true).Text;
/*
insert into [dbo].[T_People]
(
[姓],
[名],
[Age],
[HasChildren],
[CreatedAt],
[UpdatedOn]
)
values
(
@LastName,
@FirstName,
@Age,
@HasChildren,
SYSDATETIME(),
SYSDATETIME()
)
*/
// Update records with specified columns that matched specified condition
using (var builder = new QueryBuilder<Person>(DbDialect.SqlServer))
{
builder.Update(static x => new { x.LastName, x.Age, x.ModifiedAt }, useAmbientValue: true);
builder.Where(static x => x.Age < 35 || x.LastName == "Suzuki");
var sql = builder.Build().Text;
}
/*
update [dbo].[T_People]
set
[姓] = @LastName,
[Age] = @Age,
[UpdatedAt] = SYSDATETIME()
where
[Age] < @p3 or [姓] = @p4
*/
QueryBuilder class also provides some other overload functions and Count / Delete / Truncate methods, and so on.
