Vip.SqlQuery

This is a very simple library to generate SELECT queries in SQL SERVER. It is possible generate queries with many columns, prefix, many possibles where´s clause, parameters and more. ✌️ 😉

Package write in C#, framework .Net 4.8

Comments:

Adapted from the original design for use with a firebird database. Tested with Firebird 2.5 and changed the framework to 4.6.1. Original design and credits for: https://github.com/leandrovip/Vip.SqlQuery

How to use ?

Declare a using:

using Vip.SqlQuery;

Code:

var query = SqlQuery.New()
    .Select(new[] {"ProductId" "Product", "Description", "Price", "p"})
    .From("Product p")
    .OrderBy("p.ProdutoId")
    .Build();

Query return:

Console.Write(query.Command)

/*
SELECT [p].[ProductId], [p].[Product], [p].[Description], [p].[Price]
FROM [Product] [p]
ORDER BY [p].[ProdutoId]
*/

License

MIT