SimpleSqlBuilder 2.0.0

SimpleSqlBuilder

Why?

Single interface to build friendly's queries SQL (Structured Query Language). It's fast, simple and you can use any database

How it Works?

The SimpleSqlBuilder provide a interface to you create queries SQL throught a commands builder.

Show me how!

First, create a SqlQueryBuilder instance:

SqlQueryBuilder sqlBuilder = SqlQueryBuilder.Create();

After you can use that instance to make queries like the example below:

string select = sqlBuilder
    .Select("Name, Email")
    .From("Person")
    .Join("User", "User.PersonId = Person.Id", JoinType.Left)
    .Join("Contact", "Person.Id = Contact.PersonId")
    .Where("Name like @Name", new { Name = "%Victor%" })
    .Limit(15)
    .Build(options => options
        .Add(Options.Distinct)
        .Add(Options.NoLock));

// select output:
// SELECT 
// DISTINCT TOP 15 Name, Email 
// FROM Person WITH(NOLOCK) 
// INNER JOIN Contact WITH(NOLOCK) ON Person.Id = Contact.PersonId 
// LEFT JOIN User WITH(NOLOCK) ON User.PersonId = Person.Id 
// WHERE Name like '%Victor%'


string insert = sqlBuilder
    .Insert()
    .Into("Product")
    .Values(new { Name = "Mouse HyperX 10000 DPI", Price = 139.9M })
    .Build();

// insert output:
// INSERT  
// INTO Product (Name, Price)
// VALUES ('Mouse HyperX 10000 DPI', 139.9)


string update = sqlBuilder
    .Update("Product")
    .Set(new { Name = "Monitor 144hz AOC G2 Hero", Price = 1500.66M })
    .Where("Id = @Id", new { Id = 12 })
    .Build();

// update output
// UPDATE Product   
// SET Name = 'Monitor 144hz AOC G2 Hero', Price = 1500.66
// WHERE Id = 12


string delete = sqlBuilder
    .Delete()
    .From("Tasks")
    .Where("Status = @Status", new { Status = 3 })
    .Build();

// delete output:
// DELETE FROM Tasks WHERE Status = 3