C Sharp Class For Access Databases

There are those occasions when technicians programming in c# are required to communicate with an a Microsoft Access Data Base Management System (DBMS). This newly created class provides all the necessary communications to create, read, update and delete records in associated tables. The Visual Studio allows the programmer to design this as well as other classes with relative ease.

Yankee ingenuity gets the lion’s share of the kudos for the success of this tool. Effective use of the namespace feature totally encapsulates the aforementioned code.

The second consideration is for a couple of variable that are essential to successful creation of the tool. Object linking and embedding for databases (OleDB) for dot net, the lifeblood of the class requires a connection to the database. Once connected a command processor must be created to handle Structured Query Language (SQL) syntax that actually caries out the operations on the associated tables.

Typically result sets are yielded from successful SQL execution. A unique data reader is normally used to peruse the result set of records. This reader is employed if there is one record or many records in the result set.

There are certain SQL commands that do not return result sets but instead perform functions such as create, read, update and delete against records in the associated table.

Often SQL queries have parameters which substitutes specific values into the structured query language. This type of mechanism allows the insert, select, update and deletes commands to handle a single record or affect numerous records in the associated table.

Another benefit of using this approach allows for centrally locating the required syntax for carrying out these types of database manipulation techniques.

These as well as other classes are kept in a central repository until they are copied and pasted into .NET projects as the need arises.

I have also authored c# classes for other DBMS’s such as Oracle, DB2, and Sybase in addition to flat file access.