Re: OLEDBCommand vs. SQLCommand

I think under certain circumstances, the SqlClient namespace classes are
going to provide you with better performance. They may also provide you with
more access to SQL Server specific functionality.

If your application does not need any of this functionality, and what you
are doing is not something that the SqlClient class can optimize for you,
then I suppose you can use OleDb so that you can swap out different types of
databases. If you are always using SQL Server though, then I see no reason
to not just always use the classes in SqlClient.

"Anil Gupte" <anil-list@xxxxxxxxxxx> wrote in message
news:uqMw73SGHHA.4116@xxxxxxxxxxxxxxxxxxxxxxx
When does one use one or the other? And why? I cannot imagine too many
innstances where you would not want to use SQL statements when you
communicating with a database - even on a read-only basis. Plus there is
the ODBCCommand class too - I understand that is an older implementation
and is not used in .Net much, correct?

Thanx for any clarifications and perhaps web links to discussion on this.
--
Anil Gupte
www.keeninc.net
www.icinema.com




.

Relevant Pages

  • Re: SQL vs Access DataBase
    ... You can get better performance using the SqlClient as ... >> syntactical differences between your Access Queries and SQL Queries. ... >>> If I have code that manipulates an Access DataBase using OLEDB, ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Auslesen von Datenbanken
    ... Naja, ob der jeweilige OleDb Provider Schemarowsets implementiert, ... SQL hiesse bei der Jet z. ... Und ein SqlClient ...
    (microsoft.public.de.german.entwickler.dotnet.datenbank)
  • Trying to Create a Test Class for System.Data.SqlClient
    ... prints sql statements instead of running them on the database. ... way when I want to go into test mode I comment out the SqlClient class ... and comment in the test class. ... SqlDataReader object exactly the way it is so that I can use this test ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: (RDA = OK) + (SqlClient = PlatformNotSupportedException) + I w
    ... SQL CE replication does not care, ... > I checked that the Collation of 192.x.x.x is ... > is not due to cross wiring b/w SqlServerCe and SqlClient. ... > perhaps devices support only English/Default Collation for SQL Server. ...
    (microsoft.public.sqlserver.ce)
Loading