Project Description
ADO.NET Sql classes wrapper; provides a clean fluent interface library that allows you to write very concise code and avoid the repetitiveness of ADO.NET. It can be used in all types of applications, even supports CLR stored procedures. It is written in C# 2.0.
AbstractSql is for those of you still using ADO.NET (or even the Data Access Application Block) for your data access, if you are doing all your data access using some ORM library, you can move on, there's nothing here for you, however I know that a lot of code still uses raw ADO.NET; with ADO.NET the code gets very repetitive and it's very error prone to copy/paste every time, there's too many things to keep track of, such as carrying around the connection string, creating the connections, creating commands, associate to the connection, opening the connection at the right time, closing the connection, parameters, multiple variables, etc... you have to tell it how to do everything.
Packed in a single assembly, this library does all the same work while letting you specify what you want to do without having to outline every single step of how to do it.
AbstractSql exposes simple and familiar methods such as: ExecuteNonQuery, ExecuteScalar<T>, ExecuteReader, and introduces a few self explaining ones ExecuteReaderSingle, AsDataTable, etc.
Worry no more about connection strings, opening connections, closing them, type conversions, etc, focus on the stuff the matters only, the query that you want to execute and getting the results, while letting this library do all the tedious repetitive coding for you, and most importantly, hiding it from you.
A very simple typical query using ADO.NET takes around 8-9 lines, the same query using AbstractSql takes 3-4 lines, reads much better and minimizes the error factor by 5X or more, and that's just for the simplest cases.