Re: oledbconnection v sqlconnection

The SqlClient namespace (and provider) is designed to extrude TDS directly.
The OleDb provider is a one-size-fits-all data access interface that uses
several layers to generate TDS. My tests show a significant loss of
performance and functionality.

Creating a single program that can be used with more than one backend is
problematic. No two database engines have the same SQL so you'll have to
compromise all along the design path to be sure that every targeted DBMS has
the feature or function you're trying to use. Most developers choose to
build these applications using a layered approach that dereferences the
actual low-level data access layer and exposes a common object layer that
does not care how the objects are constructed. This way you can create an
engine-specific DAL that can (to a greater extent) leverage the features and
power of each target DBMS.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"JRD" <jdnews@xxxxxxxx> wrote in message
news:Onh3qyRNHHA.448@xxxxxxxxxxxxxxxxxxxxxxx
Greetings,

I wrote a wrapper for the ado.net using oledb to make connection to the
database. At the time the purpose of this class was so that I could use it
against any kind of database type. However, I was told recently that
SqlConnection is better to use against sql server.

So I was wondering which is the best to use oledb or sqlconnection when
going against a sql server database, or is the performance minimal and
does not matter which of the two you use.

John



.

Relevant Pages

  • Re: please recommend c# and asp books
    ... T R Y this book Titled: Database programming using Visual Basic 2005, ... 2005 and SQL Server 2005 ... Design an application based on three tier architecture including Data ... Layer, Business Layer and Presentation Layer using Class Libraries, with ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: msde2000
    ... MSDE is the desktop version of SQL server. ... Basically, Access is a desktop application, MSDE is a database backend. ... go through OLEDB, so theoretically therefore it's arguably the fastest ...
    (microsoft.public.vc.language)
  • RE: Allowing user selection of a datasource at run time?
    ... but you can build connection strings to connect to any OLEDB ... the SQL Server instances, which is much easier. ... I need to allow> a user to select a database to connect to at run time via a standard dialog> box. ... This causes the 'Data Link Properties' dialog box to appear> which allows the user to select an OLEDB data provider, and a database, etc. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: OLEDBCommand vs. SQLCommand
    ... Thanx Seth & Pamela, that does help. ... Access is SQL Server lite. ... all the servers my company uses, meaning either OleDb or ODBC (and I ... but may be your only choice depending on the database. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: oledbconnection v sqlconnection
    ... I wrote a wrapper for the ado.net using oledb to make connection to the ... against any kind of database type. ... SqlConnection is better to use against sql server. ...
    (microsoft.public.dotnet.framework.adonet)
Loading