provider-independent

How to design a provider independet DAL (.Net)

I am currently developing a query builder application, basically a simple graphical interface that should allow users with no knowledge of SQL to define various queries on a database (joins, select, update, insert, delete). I will be using .Net 3.5. My application should support multiple databases, it should work with MS-SQL Server, MySQ...

.net : Are DataSet and TableAdapters agnostic of database and vendor?

Hi all, We need the application we are building to be Database-agnostic. In particular, I need it to be able work with SQL Server, Oracle and MySQL. In the future, possibly other DB Vendors will be added to the list. Of course, whatever DB is to be used will have the same schema. In order to build a prototype to demonstrate the interfa...