How to handle Transaction in C# Code as well as Store Proc

Question

We want to insert record in multiple databases then how to handle Transaction in C# Code as well as Store Procedure?