|
Any decent database has had the bejasus optimized out of it by experts. That is why should should let it do all the work you can express in your statements, instead of doing things piecemeal and finishing them up outside. There are a number of things you can do to help it make the most of its expertise. These will generally be detailed in a section of your documentation.
I don't know dink about ADO.NET, sorry.
|