Error handling through SQL or C#.
How common is it to handle errors and enforce constraints through SQL, with transactions and stored procedures, instead of with C# code?
What is the best practice?
Is there any performance gain or loss by choosing one over the other?
What is the best practice?
Is there any performance gain or loss by choosing one over the other?