Interacting dynamically with multiple data sources.
Our C# desktop application interacts with DB2 using DB2OleDB provider.
I am just curious to know that how can we manage our application to interact with multiple data sources (e.g. SQL Server, Oracle, DB2) dynamically.
What should be the basic methodology to achieve the same and how much changes does one need to make this happen?
I would really appreciate if you can please guide me.