Ado.NET - Does SQLClient and OLEdb class share the same functionality

GeekInterview.com > Interview Questions > Microsoft > Ado.NET

Go To First | Previous Question | Next Question

Ado.NET | Question 12 of 31

Does SQLClient and OLEdb class share the same functionality

Total Answers and Comments: 4

Last Update: July 10, 2008 Asked by: Anil Chauhan

Sponsored Links

Best Rated Answer

—

Submitted by: Amin

No, each have its own functionality,

ex : for sql client , there is SqlConnection object

and for oledb client , there is OleDBConnection

Above answer was rated as good by the following members:
surendra_sahu786

July 21, 2006 07:46:21

Amin

RE: Does SQLClient and OLEdb class share the same func...

No each have its own functionality

ex : for sql client there is SqlConnection object

and for oledb client there is OleDBConnection

Is this answer useful? Yes | No

1 0

Overall Rating: +1

July 31, 2006 05:59:14

pradeep

RE: Does SQLClient and OLEdb class share the same func...

No they are entirely different. Each has its own functionality. With OLEDB we can connect to any Datasource while SqlClient can be used to connect to Sql Server Database Only.

Is this answer useful? Yes | No

September 21, 2006 01:35:30

Shree

RE: Does SQLClient and OLEdb class share the same func...

Yes functionality wise both are *almost* same however there object models differ. SQLClient class has XML capabilities which are a part of feature set of SQL Server.

Is this answer useful? Yes | No

July 10, 2008 00:29:23

ynvpavan

Member Since: September 2007 Contribution: 16

RE: Does SQLClient and OLEdb class share the same functionality

sqldata provider is a native provider for the sqlserver developed by micrsoft it contains all native drivers that gets connected to the sqlserver. Where as oledbprovider is to make access to any database so it performs some what less efiiciency then that of the sqlclient.
It's the best way of using native drivers provider i.e sqlclient when using sqlserver and for any databases other then the sqlserver those don't have a dataprovider it's better to use the oledbprovider.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank