public List <FinishedProject> fillFinishedProjectsForUser(string userId) { List <FinishedProject> fpl = new List <FinishedProject>(); //Set isolation level TransactionOptions ops = new TransactionOptions(); ops.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; //Wrapp transaction using (TransactionScope trans = new TransactionScope(TransactionScopeOption.Required, ops)) { try { var result = db.finishedProjectsForCurrentUser(userId); fpl = result.ToList(); db.SubmitChanges(); trans.Complete(); } catch (SqlException e) { MessageBox.Show(e.Message.ToString()); } catch (TransactionAbortedException tab) { MessageBox.Show(tab.Message.ToString()); } catch (TransactionInDoubtException tib) { MessageBox.Show(tib.Message.ToString()); } } return(fpl); }