A simple to use open source class file for DAL implementation. Provides easy means of accessing a database and prevents common mistakes. It is efficient and has many options for interacting with data both synchronously and asynchronously.
It is a common mistake to leave a database connection open. We have all done it before. Just as easy as it is to leave a connection open it is also often overlooked how many connections are being used. Both, using too many connections and leaving them open results in poor performance and can lead to errors. This DAL avoids common mistakes by managing database connections for you. When properly used, connections are automatically closed when no longer needed. A SqlDatabase object acts as your session with the database and can be reused as needed.
This also supports output and return parameters and subsets of data as often used with paging.