Difference between OLEDB Provider and

ShivaniX · 22-05-08, 01:42 AM

Difference between OLEDB Provider and SqlClient ?

anandkbs · 23-06-09, 03:54 PM

SQLClient --- .NET classes are highly optimized for the .net / sqlserver combination and achieve optimal results. The SqlClient data provider is fast. It's faster than the Oracle provider, and faster than accessing database via the OleDb layer. It's faster because it accesses the native library (which automatically gives you better performance), and it was written with lots of help from the SQL Server team.

22-05-08, 01:42 AM	#1 (permalink)
ShivaniX Senior Member Join Date: Apr 2008 Posts: 13,341 Thanks: 0 Thanked 26 Times in 26 Posts Rep Power: 137	Difference between OLEDB Provider and Difference between OLEDB Provider and SqlClient ?
Offline

23-06-09, 03:54 PM	#2 (permalink)
anandkbs Junior Member Join Date: Feb 2009 Age: 24 Posts: 14 Thanks: 0 Thanked 0 Times in 0 Posts Rep Power: 2	Re: Difference between OLEDB Provider and SQLClient --- .NET classes are highly optimized for the .net / sqlserver combination and achieve optimal results. The SqlClient data provider is fast. It's faster than the Oracle provider, and faster than accessing database via the OleDb layer. It's faster because it accesses the native library (which automatically gives you better performance), and it was written with lots of help from the SQL Server team.
Offline

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Selection of Web Design service provider	Halsey33	WEB DESIGNING, DEVELOPMENT ,PROMOTION & SEO	0	08-01-08 03:45 PM
Need .Net Interview Questions	vidyasagarkumar	VB / ASP.NET Technologies	6	06-09-07 12:37 AM
TCS Pacement paper 30	sridhar	TCS Placement Papers	0	12-02-07 05:45 PM
ADO.net 2.0 - Differences between OLEDB SQL SERVER , OLEDBDOTNET PROVIDER	preethisingh	vb / asp.net Interview / Technical Questions	0	25-01-07 07:39 PM
J2EE - What is the difference between Difference between doGet() and doPost()?	preethisingh	Java Interview / Technical Questions	1	24-01-07 07:28 PM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)