string source="database connections";
using (TranscationScope scope=new TranscationScope(TranscationScope.Required))
{
  using(SQLiteConnection cn =new SQLiteConnection(scource))
  {
     //do something in sql
//update three table
     scope.Complete();
  }
}