Post reply

Diff b/w ado.net Adaptors and Oledb Adaptors

  • 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

  • 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

  • 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.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply