Re: OLEDBCommand vs. SQLCommand

Thanx for the clarification. By the way, it surprises me that Oracle is not
SQL compliant - assuming that SQL is a general specification, not something
invented by MS.

--
Anil Gupte
www.keeninc.net
www.icinema.com

"Marina Levit [MVP]" <someone@xxxxxxxxxx> wrote in message
news:OeaZDNUGHHA.4712@xxxxxxxxxxxxxxxxxxxxxxx
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
    ... funny enough i was reading about that last night ... > Thanks for the further clarification. ... This involves an INSERT INTO statement in SQL. ...
    (microsoft.public.access.queries)
  • Re: Simple Query Question
    ... Just for clarification - I guess I have to enter the cls.dbo.enquiries ... instead of dbo.enquiries because I have multiple databases within SQL ... Server? ...
    (comp.databases.ms-sqlserver)
  • Re: Append results from ADODataset
    ... Clarification ... I'm looking for a simple way to do this with SQL ... statements and a wildcard. ... All fields match in both tables. ...
    (borland.public.delphi.database.ado)
  • Re: BizTalk eating up SQL Server (Virii Behaviour)
    ... Yes, one gig is the least to run sql & bts in the same box, ... uninstall procedure, i manually deleted all databases, and run the ... and it was leaving like 20 mbs free memory, ... BizTalk Solution Developer ...
    (microsoft.public.biztalk.general)
  • Re: Dont understand what version of SQL to install
    ... I'm talking about developing and testing databases for my client and ... To my XP, I can add SQL Developer 2008 to develop (I guess I should say, ... So I can use SQL Developer 2008 to create a database in standard 2005, ... installed on Client OSs such as Windows Vista. ...
    (microsoft.public.sqlserver.setup)