Solved

Interacting dynamically with multiple data sources.

Posted on 2004-10-16
2
178 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 125 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Change to file doesn't show up 16 93
Unlocking a column in excel using C# 17 33
linq .concat equivalent with expression syntax 4 42
Web page design problem 3 41
Extention Methods in C# 3.0 by Ivo Stoykov C# 3.0 offers extension methods. They allow extending existing classes without changing the class's source code or relying on inheritance. These are static methods invoked as instance method. This…
Article by: Ivo
C# And Nullable Types Since 2.0 C# has Nullable(T) Generic Structure. The idea behind is to allow value type objects to have null values just like reference types have. This concerns scenarios where not all data sources have values (like a databa…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

734 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