Hi all,
actually i have to develop a project to monitor EDI/Edifact data that are send between different EPR systems.
Different erp systems means also different database systems. So i have to develop an app to monitor up to 5 tables.
These tables can be stored in SQL Server, Oracle, MySQL or DB2.
What kind of data access do i have to use ? ODBC ? ADO.NET ?? I actually don't have an idea how to handle this.
In the app (i have to write) there should be something like a "DB Configuration for EDI" and there i want to configure if it is SQL, MySQL or what ever that i have to access.
In the different Databases all the tables have the same name (means in SQL there is a table called Actlog and in Mysql also a table called Actlog)....
How can i write my app that it is DB independent ??

Greetings
H.

MySQL AdoNet with OleDB
SQL Server AdoNet with SqlClient or Linq to SQL or Linq to EF
Oracle AdoNet with OracleClient
From DB2, I don't know if the have still a dedicated Net provider otherwise AdoNet and OleDB

Have a look for factory for databases in AdoNet

Here an article from David Sceppa a known Microsoft bookwriter for AdoNet, it should fit you

http://blogs.msdn.com/adonet/archive/2007/03/16/ado-net-orcas-sample-provider.aspx

---

Success
Cor