Please Note: Typed-Query is no longer actively developed and has been replaced by the newer library called 'Query Lite'

Please Use => https://github.com/EndsOfTheEarth/QueryLite

Typed Query

Typed Query (TQ) is a C# API for querying databases in a type safe manor. The aim of TQ is to closely follow standard sql, be fully in code (i.e. No configuration files) and have helpful debugging features.

Features

• Type safe queries - (Select, Insert, Insert Select, Update, Update Select, Delete, Truncate);
• Sql queries in code - Syntax 'select', 'top', 'distinct', 'from', 'join', 'where', 'group by', 'having', 'order by', 'union', 'nested queries'
• Sql functions, auto id's, parameters, set timeouts for indvidual queries
• Work with jpa style row objects to insert/update/delete or use normal queries
• Stored procedures, Temporary tables
• Database independent - (SqlServer, PostgreSql currently supported). Easy to support more
• No configuration files. Everything is compiled in code.
• Table definition creation and validation tool (UI)
• Transactions - Commit, Rollback, resource blocks so transactions don't accidentally get left open
• TQ can output query details as they are executed. These details include - sql, query duration, result size, exception, isolation level, transaction id
• Set transaction to be only one used on current thread. (Great for finding potential dead locks in code)

Documentation

Documentation can be found here

Examples

Compile time join checking on key columns.

Select Query

User.Table userTable = new User.Table();
Order.Table orderTable = new Order.Table();
 
Sql.Function.CountAll count = new Sql.Function.CountAll();
 
Sql.IResult result = Sql.Query
    .Select(userTable.Id, count)
    .From(userTable)
    .Join(orderTable, userTable.Id == orderTable.UserId)
    .GroupBy(userTable.Id)
    .Having(count > 1)
    .Execute(MyDatabase.Instance);
 
for (int index = 0; index < result.Count; index++) {
    int userId = userTable.GetRow(index, result).Id;
    int? countValue = count[index, result];
}

Insert Query

Table table = new Table();
 
using (Sql.Transaction transaction = new Sql.Transaction(MyDatabase.Instance)) {
 
    Sql.Query.InsertInto(table)
        .Set(table.FirstName, "jo")
        .Set(table.LasName, "smith")
        .Execute(transaction);
 
    transaction.Commit();
}

Nested Query

User.Table userTable = new User.Table();
Order.Table orderTable = new Order.Table();
 
Sql.Query.Select(userTable.Id)
    .From(userTable)
    .Where(
        userTable.Id.In(
            Sql.Query.Select(orderTable.UserId)
            .From(orderTable))
     ).Execute(MyDatabase.Instance);

Code Generator

TQ has a tool to generate C# schema definitions.

Licensing

TQ is released under the GNU Lesser General Public License (LGLP) version 3 license. This means the library can be used by both open and closed source applications.