After knowing a bit about database structure, let us put our
hands on the programming part with relation to .NET. As every database has
accepted SQL as the standard language for querying, so too has DBISAM. We do
not need to worry about syntax; our same old concept on SQL will work fine
here. Now to connect to the DBISAM Database from our application, we need the
DBISAM ODBC driver. It is an ODBC level 3 driver. The driver works with
Microsoft Data Access Components (MDAC) version 2.7 or higher and many other
applications including .NET Applications.
There are still a few things missing from the driver like
support for bulk operations and a few ODBC extended scalar functions (UNION, INTERSECT, LIKE, etc).
Using ODBC Driver
To use the ODBC Driver we can either setup a DSN which we
access from our application or can directly access the database through a
connection string from our application.