Database

Dim ConnectionString As String = "Data Source=s-1\SQLEXPRESS;Initial Catalog=abc;Integrated Security=True"

<br />
        public static Step Save(Step step)<br />
        {<br />
			using ( KRATDataContext context = new KRATDataContext( Helpers.EnvironmentState.CurrentConnectionString ) )<br />
			{<br />
				Step oldStep = step.StepID > 0 ? context.Steps.Single( p => p.StepID == step.StepID ) : null;<br />
<br />
				if ( oldStep == null )<br />
				{<br />
					context.Steps.InsertOnSubmit( step );<br />
				}<br />
				else<br />
				{<br />
					oldStep.Description = step.Description;<br />
					oldStep.PotentialHazard = step.PotentialHazard;<br />
					oldStep.ActionsToReduceRisk = step.ActionsToReduceRisk;<br />
					oldStep.InitialRiskCellID = step.InitialRiskCellID;<br />
					oldStep.PostRiskCellID = step.PostRiskCellID;<br />
					oldStep.DateCreated = step.DateCreated;<br />
					oldStep.RiskAnalysisID = step.RiskAnalysisID;<br />
					oldStep.DisplayIndex = step.DisplayIndex;<br />
				}<br />
				context.SubmitChanges();<br />
<br />
				return step;<br />
			}<br />
        }<br />
<br />

<br />
protected void Swap(int stepId1, stepId2)<br />
{<br />
  // get the actual records<br />
  Step step1 = Step.GetOne(stepId1);<br />
  Step step2 = Step.GetOne(stepId2);<br />
<br />
  // do the real swap (left out logic on purpose to focus on issue)<br />
  Swap(step1, step2);<br />
<br />
  using( System.Transactions.TransactionScope txCtx = new System.Transactions.TransactionScope()){<br />
    Step.Save(step1);<br />
    Step.Save(step2);<br />
<br />
    txCtx.Complete();<br />
  }<br />
}<br />