Comparison of '.NET SqlClient' and 'Microsoft OLEDB' for accessing MSSQL 7 and above
-
In the .NET documentation Microsoft is recommending usage of SQL server .NET data provider for accessing MSSQL 7 and above. Will any one please tell me what are the advantages of using .NET library over OLEDB? Uday
-
In the .NET documentation Microsoft is recommending usage of SQL server .NET data provider for accessing MSSQL 7 and above. Will any one please tell me what are the advantages of using .NET library over OLEDB? Uday
Uday Patil wrote: In the .NET documentation Microsoft is recommending usage of SQL server .NET data provider for accessing MSSQL 7 and above. I believe the main differences are in optimization for speed. -Nick Parker
-
In the .NET documentation Microsoft is recommending usage of SQL server .NET data provider for accessing MSSQL 7 and above. Will any one please tell me what are the advantages of using .NET library over OLEDB? Uday
Hi Uday, I think using SqlClient for accessing SQL Server 2000 in ADO.NET has good speed enhancments w.r.t. make-n-break connections, query update speeds and lot more. DataSet too seems to have real good methods to update directly to the db. I have'nt fully explored this, since I am currently working with OleDb and IBM Db2 database. Did this attend to your query? Deepak Kumar Vasudevan http://deepak.portland.co.uk/
-
Hi Uday, I think using SqlClient for accessing SQL Server 2000 in ADO.NET has good speed enhancments w.r.t. make-n-break connections, query update speeds and lot more. DataSet too seems to have real good methods to update directly to the db. I have'nt fully explored this, since I am currently working with OleDb and IBM Db2 database. Did this attend to your query? Deepak Kumar Vasudevan http://deepak.portland.co.uk/
Thank you Deepak and Nick, :) I gone through many documents related to this. I found some good things abt SqlClient. But I dont think them sufficient enough for change my application to support SqlClient. For this I am conducting a benchmark test. I will be having results in my hands within a day or two. I will definately update you regarding results. Thanks and regards Uday