Diff b/w ado.net Adaptors and Oledb Adaptors

• inampudianil

  Ten Centuries

  Points: 1274

  More actions

  February 8, 2011 at 9:35 pm

  #234711

  Could you plz let me know what is the basic difference b/w Ado.net Adaptors and Oledb Adaptors.If possible can you exaplain with the help of an example?

  Thanks in Advance

  Anil Inampudi

• Koen Verbeeck

  SSC Guru

  Points: 259015

  More actions

  February 9, 2011 at 2:32 am

  #1284281

  ADO.NET --> uses ActiveX Data Objects for .NET

  OLE DB --> uses COM interfaces (in my opinion the easiest and the fastest to work with)

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• pmm.sudarsan

  Old Hand

  Points: 370

  More actions

  February 9, 2011 at 3:35 am

  #1284309

  Yes,

  ADO.NET --> uses ActiveX Data Objects for .NET

  OLE DB --> uses COM interfaces (in my opinion the easiest and the fastest to work with)

  While using ADO.net connection in the execute sqltask you have mention the parameter as @parameter as the parameter name.

  ex:select * from table1 where column1 = @column1

  While using Oledb connection you have set the parameter index start with 0

  Ex:Select * from table1 where column1=?.so it will the value from the index as "0" as a parameter name.