Knight Data Access Layer
Overview ODBC and OLEDB VB.NET
Basic Tasks VB.NET > Using ODBC and OLEDB > Overview ODBC and OLEDB VB.NET

If your database is not one of the built in supported databases you have the option of using OLEDB or ODBC to interact with your database.  If your database is ANSI SQL compliant; Auto mapping, CRUD, and standard ADO.NET operations are supported out of the box.  DDL and LINQ are not inherantly supported since the SQL is different for every database.  You can however extend the ODBC or OLEDB Provider and implement specific DDL SQL, and identity SQL for your database. 

 

After inheriting from the ODBCProvider or OLEDBProvider, override and implement these methods:

 

GetDatabaseTypeForDbType
GetCreateTableSqlWithPrimaryKey
GetCreateTableSqlWithCompositeKey
GetColumnDefinitionSql
StoredProcedureExists
CreateDatabase
ChangeDatabase
NotSupportedException
GetCreateTriggerSql
GetDropSequenceSql
GetDropTriggerSql