I have the following code that throws the following exception sporatically and I was wondering if anyone has any ideas.
public static void StartTransaction(this IDataAccessAdapter adapter, Action action)
{
try
{
adapter.StartTransaction(IsolationLevel.ReadCommitted, "execute");
action();
adapter.Commit();
}
catch (Exception ex)
{
adapter.Rollback();
throw ex;
}
}
Here is the exception info.
Exception Stack Trace: at System.Data.SqlClient.SqlTransaction.ZombieCheck()
at System.Data.SqlClient.SqlTransaction.Rollback()
at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.Rollback()
at HIA.DataAccessAdapterExtensions.StartTransaction(IDataAccessAdapter adapter, Action action) in C:\development\4.0\HIA\src\HIA.Core\Extensions\DataAccessAdapterExtensions.cs:line 22
at HIA.Core.Events.Commands.GrantPointsCommandHandler.Execute(GrantPointsCommand command) in C:\development\4.0\HIA\src\HIA.Core\Events\Commands\GrantPointsCommand.cs:line 86
at Touchstone.Common.Commands.CommandHandler`2.Execute(Command command)
at Touchstone.Common.Commands.CommandExecuter.Execute[TCommandResult](Command command)
at HIA.Web.Views.Events.GrantPointsPresenter.GrantPointsFromRequest() in C:\development\4.0\HIA\src\website\DesktopModules\HIA.Web\Views\Events\GrantPointsPresenter.cs:line 103
at HIA.Web.Views.Events.GrantPointsPresenter.OnViewInitialized() in C:\development\4.0\HIA\src\website\DesktopModules\HIA.Web\Views\Events\GrantPointsPresenter.cs:line 42 Additional Info:
Thanks