I've been wondering about this using C# to write store procedure thing. From my understanding, it is just using a different syntax to write the same store procedure. Since most of the code in a store proc are SELECT/INSERT/UPDATE statements, I really don't see that much different. Are there other enhancements that I don't know about?