Starts a new transaction on this connection/instance.

NOTE: provided only for ADO.NET style transactions LINQ to SQL will create its own connection instances and will close open transactions on its own.