It depends entirely on round trips to the server and your use cases. Generally speaking though, if you keep your result set as narrow as possible, post process

It depends entirely on round trips to the server and your use cases. Generally speaking though, if you keep your result set as narrow as possible, post process aggregates in code, keep your join count low and keep you round trips per request low then c# will destroy stored procedures.