Search code examples
c#.nettransactionsisolationatomic

Handling transaction context using method attribute in linq to sql

Is there a way to just put an attribute to a method so that the whole code in the method is executed in a transaction scope? I've seen this done in sharp architecture but I'm using Linq to sql not nhibernate. Thanks!

This what I would like to do:

[Transaction] 
public void InsertCustomer(Customer customer)
{ //insert customer }

So that the body of the method executes in a transaction scope.

Solution

  • Which method? If you mean SubmitChanges, then I believe that is already transactional. Otherwise, just spin up your own TransactionScope around what you want controlled, or pass in a configured connection to the DataContext overloaded constructor.