>>Given two scenarios:
>>1) A pure .NET app using the sqlclient.
>>2) A pure COM app using OLEDB and ADO. If it matters, lets say its written in VB 6.0.
>
>Hi, Craig.
>
>I´ve done a very stupid test here... 1 Console app (in C#), and 2 PRG in VFP (using ADO - oledb, and SPT - odbc) - I don´t have VB6 aqui...
>
>the test is some stupid, but I think it´s what you want: data access... I just make the routines create the objects, connect to SQL Server, "select * from authors" (Pubs database), and close the connection... everything´s on a for..next with 500 iterations... in C#, or in VFP with ADO or SPT, everything went equal = 2 seconds.
>

You are opening and closing the connection in the loop? In the VFP versions, do you open and close the connection in the loop, or you do also instantiate the ADO and destroy it in the loop?

Just curious. I would expect VFP using ODBC (of the two VFP examples) would be faster due to all the COM marshing that needs to be done with ADO.

In C# did you use OLEDb objects of SQLDb objects?

Thanks,
BOb