.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Forum >> C# >> Post New QuestionBookmark and Share Subscribe to Forum

Difference between System.Data.SQL and System.Data.SQLClient?

Posted By: Narayanan     Posted Date: August 13, 2012    Points:5   Category :C#
Difference between System.Data.SQL and System.Data.SQLClient?

Responses
Author: Baimey Rajesh             
Posted Date: August 14, 2012     Points: 20   

The System.Data.Sql namespace contains classes that support SQL Server-specific functionality and System.Data.SqlClient namespace is the.NET Framework Data Provider for SQL Server.

Author: Baimey Rajesh             
Posted Date: August 14, 2012     Points: 20   

Some more information

System.Data.SQLClient

Can only be used for connecting to SQL Server 2000 and later. But you will get optimal performance when connecting to those databases.

System.Data.OledbClient

Can be used to connected to SQL 6.5

OLEDBClient gives you ability to connect to other database like ORALCE or Access. But for working with SQL Server you will get better performance using SQLClient.

Note: For connecting to ORALCE Microsoft also has ORACLEClient.


System.Data.ODBCClient provides connection to legacy databases ( e.g. MS Access 97) using ODBC drivers.

Author: Narayanan             
Posted Date: August 15, 2012     Points: 20   

Hi ,
Thanks

Regards, Lakshmi Naraayanan.S
http://dotnettechrocks.blogspot.in/
Author: Baimey Rajesh             
Posted Date: August 16, 2012     Points: 20   

One more smarter explanation http://stackoverflow.com/questions/7150612/what-is-the-difference-between-system-data-sqlclient-and-sqlncli10-1-providers
System.Data.SqlClient is a managed provider. SQLNCLI is an OleDB provider. Which means they are as distinct as it gets. Nothing in common, really, besides the fact that they're both connecting to SQL Server. But using completely different and unrelated technologies.

In your applications, you should use SqlCLient when writing managed code (.Net). OleDB is for native applications (C++).

Author: Baimey Rajesh             
Posted Date: August 16, 2012     Points: 20   

If you want more explanations the same heading in Google will provide a thousands of results.

I hope things are clear.

Thanks
Baimey

Author: Narayanan             
Posted Date: August 20, 2012     Points: 20   

Hi,
Thanks

Regards, Lakshmi Naraayanan.S
http://dotnettechrocks.blogspot.in/


Post Reply

You must Sign In To post reply
 
 
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend