Popsql (pronounced 'popsicle') is a library eliminating the need for magic SQL strings in your code. It works by providing an API that allows you to build complex SQL expression trees from code and later render them into valid SQL text that goes right into your ADO.NET code or your favorite micro-ORM.
Popsql is Open Source software and is released under the MIT license. This license allows the use of Popsql in free and commercial applications and libraries without restrictions.
You can just add a reference to Popsql from NuGet using the Visual Studio UI or by running the following command in the package manager console.
Install-Package popsql
Alternatively, you can also install from the NuGet command line.
nuget install popsql
Documentation is available from the Popsql Wiki.