This isn't specific to .NET really, but you'll substantially improve your performance and simplify your .NET code by doing as much of this as possible with Stored Procedures within SQL itself.