Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Interacting dynamically with multiple data sources.

Posted on 2004-10-16
2
Medium Priority
?
186 Views
Last Modified: 2010-04-15
Hi!

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.

Thanks and regards
Rajesh Khatri
0
Comment
Question by:rj_khatri
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 4

Accepted Solution

by:
Farshid-Zaker earned 375 total points
ID: 12328847
Hi Rajesh,
Microsoft has published a 5 layer architecture in Petshop sample (downloadable from MSDN site). There are 2 layers for data access in it. One of them is independent of used RDBMS and the other one is dependent. So, if you want to switch from one database to another one, you will make minimum attempt. Microsoft has published 2 implementation for last layer, one for SQL Server and the other for Oracle. (These layers are named IDAL and DAL Factory, I'm not sure about the exact names.) Take a look at these sample.

Farshid
0
 

Author Comment

by:rj_khatri
ID: 12345204
Many thanks Farshid!
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question