What is the differences between OLE DB and ODBC technologies. Having Firebird and Interbase databases as the examples, there are some tips that can help choosing the data access provider.
Most interesting features of Firebird 2.1 are common table expressions CTE), global database triggers, temporary tables, database monitoring through the SQL, canceling running queries and new SQL statements
New SQL instructions and features were added to Firebird 2.0: Derived Tables, EXECUTE BLOCK, INSERT RETURNING, ROLLBACK RETAIN, ROWS. Lets write a few c# examples for ADO .Net