Is there a dynamic Sql builder library for .Net?

.net sql ado.net dynamic-sql
Amitabh picture Amitabh · Apr 20, 2010 · Viewed 34.6k times · Source

Something like this.

http://code.google.com/p/squiggle-sql/wiki/Tutorial.

This is required for cases where It is required to build complex sql from the user input from UI. Currently in the project I am working is using String Manipulation which looks ugly and is difficult to maintain.

Answer

Max Toro picture Max Toro · Dec 16, 2011

Try DbExtensions, available as NuGet package.

Related questions

Check if a SQL table exists

What's the best way to check if a table exists in a Sql database in a database independant way? I came up with: bool exists; const string sqlStatement = @"SELECT COUNT(*) FROM my_table"; try { using (OdbcCommand cmd = new OdbcCommand(sqlStatement, …

Read More
Is it necessary to manually close and dispose of SqlDataReader?

I'm working with legacy code here and there are many instances of SqlDataReader that are never closed or disposed. The connection is closed but, I am not sure if it is necessary to manage the reader manually. Could this cause …

Read More
Why is OracleDataAdapter.Fill() Very Slow?

I am using a pretty complex query to retrieve some data out of one of our billing databases. I'm running in to an issue where the query seems to complete fairly quickly when executed with SQL Developer, but does not …

Read More