Architecture to support multiple db

� 

Hi,

We are in the midst of designing ASP.NET application using Visual Studio 2005(vb) . At the moment, it's being developed using Oracle 10g. One of the main requirement is to be database INDEPENDENT. Normally we also use triggers, stored procedures. the projects are separated into 3 layers.

� 

At the minimum it should support at least Oracle db and MS SQL server 2005.�  How would be the architecture would be in this scenario? The software may be deployed at place where the end customer may already have license for Oracle or SQL server 2005. So, we cannot ask them to get addtional license for the moment.

� 

Also, some of the SQL syntax for both oracle and sql server may be different? So, how to tackle this issue?

Even the stored proc's syntax different?? Also, any main issues when developing Transaction screens??

� 

Any sugges ...