Sequel

An efficient SQL builder with an interface that emulates writing actual SQL queries.

Getting Started

SELECT

var sqlBuilder = new SqlBuilder() .Select("Id", "Salary") .From("dbo.Test"); var sql = sqlBuilder.ToSql(); // .ToString() also works /* SELECT Id, Salary FROM dbo.Test */ // SELECT with INNER & LEFT JOIN var sqlBuilder = new SqlBuilder() .Select("*") .From("dbo.Test t") .Join("dbo.Employee e on e.Id = t.EmployeeId") .LeftJoin("dbo.Manager m on m.Id = e.ManagerId"); var sql = sqlBuilder.ToSql(); /* SELECT * FROM dbo.Test t INNER JOIN dbo.Employee e on e.Id = t.EmployeeId LEFT JOIN dbo.Manager m on m.Id = e.ManagerId */

INSERT

var sqlBuilder = new SqlBuilder() .Insert("dbo.Test") .Columns("Name", "Salary") .Values("'John'", "50") .Values("'Jane'", "100"); var sql = sqlBuilder.ToSql(); // .ToString() also works /* INSERT INTO dbo.Test (Name, Salary) VALUES ('John', 50), ('Jane', 100) */

UPDATE

var sqlBuilder = new SqlBuilder() .Update("dbo.Test") .Set("Salary = 100", "ManagerId = 2") .Where("EmployeeId = 1"); var sql = sqlBuilder.ToSql(); // .ToString() also works /* UPDATE dbo.Test SET Salary = 100, ManagerId = 2 WHERE EmployeeId = 1 */

DELETE

var sqlBuilder = new SqlBuilder() .Delete() .From("dbo.Test") .Where("EmployeeId = 1"); var sql = sqlBuilder.ToSql(); // .ToString() also works /* DELETE FROM dbo.Test WHERE EmployeeId = 1 */

Injecting custom SQL

You are granted pre- & post-hooks into the final SQL string literaly, for the purpose of injecting custom SQL.