Not sure what you mean by using a Transaction in C#... What you show pretty much looks like SQL to me.
Perhaps you need to use a
Transaction Object[
^]?
It can be found in the
System.Transaction Namespace[
^].
Alternatively you can use
TransactionScope[
^]. You can now have multiple queries in a single Transaction without having to commit until you explicitly say so from your code. I guess it's the next best thing after SQL's own
begin tran
and
end tran
:)
Hope this helps!