How to write transactions in C# and SQL

Question

Hello Every one,

im new to Development

my question is how to write transactions in C# and SQL  and is it good practice to write transactions in C# or SQL 

thanks in advance