Solved

Interacting dynamically with multiple data sources.

Posted on 2004-10-16
2
174 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
2 Comments
 
LVL 4

Accepted Solution

by:
Farshid-Zaker earned 125 total points
Comment Utility
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
Comment Utility
Many thanks Farshid!
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Article by: Najam
Having new technologies does not mean they will completely replace old components.  Recently I had to create WCF that will be called by VB6 component.  Here I will describe what steps one should follow while doing so, please feel free to post any qu…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

772 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now