Here comes the query!
A small and fast library for building SQL queries from entity classes in a better way than regular string concatenation.
| # | |
|---|---|
| 1 | Get Started |
| 1.1 | Install Package |
| 1.2 | Import the namespace |
| 1.3 | Sample Code |
| 2 | How to use |
| 2.1 | Prepare your Entity |
| 2.1.1 | Table Attribute |
| 2.1.2 | IsPrimaryKey Attribute |
| 2.1.3 | IsNotInsertable Attribute |
| 2.1.4 | IsNotUpdatable Attribute |
| 2.1.5 | Field Attribute |
| 2.1.6 | CustomField Attribute |
| 2.2 | APIs |
| 3 | Dapper Example |
| 3.1 | Crud Operations |
| 3.1.1 | Create (Insert) |
| 3.1.1 | Read (Select) |
| 3.1.1 | Update |
| 3.1.1 | Delete |
⚡ Add package to your existing project from NuGet Package Manager.
⚡ Or download the source code from GitHub.
using Fastsql;
Check out the Fastql Sample Project with Unit of Work in Repository Pattern using Dapper.
Fastql can be used with two way: using object and using helper class.
Define a FastqlBuilder variable in your database related class. TEntity should be your poco to generate CRUD queries.
⚡ This class fits perfect to Repository Pattern with Dapper Micro ORM.
private FastqlBuilder<TEntity> fastql = new FastqlBuilder<TEntity>();
Call FastqlHelper with your TEntity. TEntity should be your poco to generate CRUD queries.
⚡ This class fits perfect to Repository Pattern with Dapper Micro ORM.
FastqlHelper<TEntity>.InsertQuery(); // insert query for TEntity
Fastql has 5 attributes to handle your queries.
Define your table and schema name. If you don't set your schema, it'll use dbo as default.
[Table("Customer", "Sales")]
public class Customer
{
It will be rendered like [Sales].[Customer] for your query.
If your database table has PK and auto increment, you should define this attribute to your PK field. If your field has this key, your field won't be used in Insert or Update query.
[Table("Customer", "Sales")]
public class Customer
{
[IsPrimaryKey]
public int Id { get; set; }
}
Fields have this attribute won't be placed in your Insert query. You don't need to define this key for your PK field.
[IsNotInsertable]
public DateTime UpdatedOn { get; set; }
Fields have this attribute won't be placed in your Update query. You don't need to define this key for your PK field.
[IsNotUpdatable]
public DateTime CreatedOn { get; set; }
Fields have this attribute will be replaced in your Insert and Update query. You can define CreatedAt field on your code and your field attribute can contain the original version of database property like created_at.
[Field("created_at")]
public DateTime CreatedAt { get; set; }
Custom Fields have this attribute will be not included in your Select, Insert and Update queries. You can define CustomField attribute like this:
[CustomField]
public string FullName => $"{FirstName} {LastName}";
⚡ TableName ⚡ InsertQuery ⚡ UpdateQuery ⚡ SelectQuery ⚡ DeleteQuery
⚡Fastql is a great extension for Dapper Micro ORM. You can handle all of your CRUD operations easily with ⚡Fastql.
InsertQuery() function returns you the insert query based on your decisions.
Connection.Execute(
fastql.InsertQuery(),
param: entity,
transaction: Transaction
);
SelectQuery(where) function returns you the select query based on your where condition.
Connection.Query<TEntity>(
fastql.SelectQuery("Id=@Id"),
param: new { Id = id },
transaction: Transaction
);
SelectQuery(columns,where,top) function returns you the select query based on desired columns, where conditions and top records.
Connection.Query<TEntity>(
fastql.SelectQuery(new string[] {"Field1","Field2","Field3"},"Id=@Id"),
param: new { Id = id },
transaction: Transaction
);
Sample output: Select TOP(1000) [Field1],[Field2],[Field3] from [TableName] where Id=@Id
Connection.Query<TEntity>(
fastql.SelectQuery(new string[] {"Field1","Field2","Field3"},"Id=@Id",500),
param: new { Id = id },
transaction: Transaction
);
Sample output: Select TOP(500) [Field1],[Field2],[Field3] from [TableName] where Id=@Id
UpdateQuery(TEntity,string) returns you the update query with parameter tags added. You can bind your entity to query as parameter. Where string can include data or you can set your param tag to use it. (For.ex.) "Id=@Id" or $"Id={id}"
Connection.Execute(
fastql.UpdateQuery(entity, where),
param: entity,
transaction: Transaction
);
DeleteQuery(where) function returns you the delete query based on your where condition.
Connection.Execute(
fastql.DeleteQuery(where),
// param: entity,
transaction: Transaction
);