The best thing ever in ADO and VBA is that you can execute stored procedures on the database like a usual method (see Avoid using the Command object) of the connection object.
No any additional code, mapping or anything, just a magic.
That's it - we have the recordset with 10 products at page 2 for catId category.
I would love to have similar ability in .NET.
No any additional code, mapping or anything, just a magic.
Set products = New ADODB.Recordset Connection.GetCategoryProductsPage catId, 2, 10, products
I would love to have similar ability in .NET.