how to set Transaction scope in c#?

[rsreddyk]

I have c# code something like below.

 
void ExecuteSomething()
{ 
    TransactionOptions transactionOptions = new TransactionOptions();
  transactionOptions.IsolationLevel = System.Transactions.IsolationLevel.ReadUncommitted;
  transactionOptions.Timeout = TimeSpan.FromSeconds(TransactionTimeOutInSeconds);
 
  using (TransactionScope transactionScope = new TransactionScope(TransactionScopeOption.Required, transactionOptions))
  {
      action();
      transactionScope.Complete();
  }
}
 
 

i am retrieving the data by using above code

From some other code i am calling some function in c# through windows service. That function is going to delete some unwanted data from sql server database. if i wanted i initiate the request it will take 30 min to delete the data.

in this 30 min time i am unable to access other pages in my website. is there any better way to design this?

[Plater]

So this is being done on the webserver? Hmm I think you can still use threads right?
I have never done it, but long running tasks like are usually implimented in a way where you have a unique token that references the "job" and you can keep refreshing the page to find out if it is complete.
You could look up ways to handle that sort of thing, there might be a good explanation of it somewhere

[frenchmarlohe]

Get the current value of the first element in the set of matched elements.You need to specify in the script which field you want to use as an input field. Assuming it's HORAS2, then the script will be och.
http://dapfor.com/en/net-suite/net-g...ial/data-types