If you write all your SQL commands in MS Access syntax, you can create your own sql syntax convertor by inheriting SqlServerQuerySqlGenerator class and overriding GenerateSql method.
This method is called every time you use IDatabase.Query or IDatabase.ExecuteScalar, but is not called in case of IDatabase.ExecuteNonQuery.
If you write all your SQL commands in MS Access syntax, you can create your own sql syntax convertor by inheriting SqlServerQuerySqlGenerator class and overriding GenerateSql method. This method is called every time you use IDatabase.Query or IDatabase.ExecuteScalar, but is not called in case of IDatabase.ExecuteNonQuery.