what is advantage of using System.Data.SqlClient ?

[djayakum]

Hi,

what is advantage of using System.Data.SqlClient ? we can use the System.Data.OleDb to connect the Sql Server,So for what they created namespace only for SqlServer ? is there any adavantage is there if i use System.Data.SqlClient ?

JK

 

[chrissie1]

it is optimized to work with sqlserver and therefor it will be faster

Christiaan Baes
Belgium

What a wonderfull world - Louis armstrong

 

[obislavu]

Chrissies1 is right and I found it is good to have SqlClient for the SQL Server and OracleClient (in .NET 1.1) for the Oracle database.
Take a look at SqlDbType which enumerates the data types specific to SQL.
On the other hand , OracleClient supports a number of Oracle data types, including the BFILE, LOB, and REF CURSOR data types. So when you work with SQL use System.Data.SqlClient.
When you work with Oracle use System.Data.OleDb or System.Data.OracleClient.
-obislavu-