Art Of Programming

musings by Dmytrii Nagirniak

Execute Stored Procedures From ADO

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.
Set products = New ADODB.Recordset
Connection.GetCategoryProductsPage catId, 2, 10, products
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.