Data Providers in .Net

Question

0.00/5 (No votes)

See more:

Dear All,

I had a small doubt regarding the data providers.

Why we are using different providers like Orcaledb, SqlClient for diferrent database connectivity, I want to know is there any specific reason of using different providers.

Thanks,
Sreekanth

Posted 17-Oct-11 22:43pm

Member 3975858

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2011-10-17T22:48:00

Because each database system works differently. They are the same general plan, and the same SQL will work (pretty much) unchanged. But the actual interface is different. For example, with an SQLCE database you can't use Stored Procedures. It would be possible to make a "generic" interface, but then you would have to remember which one you are using to get the SQL right.

It's a bit like cars: Left hand drive and right hand drive. They are both driven the same way, but using different hands to change gear and work the handbrake.

Mehdi Gholam · Answer 2 · 2011-10-17T22:51:00

Different providers are maintained by different people and are optimized for their respective RDBM platform.

They cannot be all the same because of different underlying connection semantics such as packets ports etc.

To isolate yourself from these you can use the generic interfaces such as IDBconnection, IDBCommand etc. and pass the implementation at runtime ie change for different RDBMs without changing your code.

uspatel · Answer 3 · 2011-10-17T23:25:00

Solution 3

DataProviders works as a Bridge to intract your application with database.
see a picture in
CP Article.
Hope it will clear more.

Posted 17-Oct-11 23:25pm

uspatel

Data Providers in .Net

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0