Click here to Skip to main content
15,887,886 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
I am geeting the below error


Stack trace: at Microsoft.Practices.EnterpriseLibrary.Data.Database.PrepareCommand(DbCommand command, DbConnection connection)
at Microsoft.Practices.EnterpriseLibrary.Data.Database.PrepareCommand(DbCommand command, DbTransaction transaction)
at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteNonQuery(DbCommand command, DbTransaction transaction)
Posted
Updated 3-Apr-12 5:39am
v2
Comments
fjdiewornncalwe 3-Apr-12 11:40am    
If you don't show us the code with the query that is causing the error, then it would be quite magical for anyone to have the correct solution for you. Please use the Improve question widget to add this information to your question. Cheers.

1 solution

I am geeting the below error


Stack trace: at Microsoft.Practices.EnterpriseLibrary.Data.Database.PrepareCommand(DbCommand command, DbConnection connection)
at Microsoft.Practices.EnterpriseLibrary.Data.Database.PrepareCommand(DbCommand command, DbTransaction transaction)
at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteNonQuery(DbCommand command, DbTransaction transaction) Please find the code

C#
try
           {
               assessmentDao.BeginTransaction();
               UpdateAssessmentStatus(Assessment);
               tempDataDao.DeleteAssessmentTemp(Assessment.ID, IdDomain, IdSubDomain);
               notInUseBL.Delete(Assessment.ID, IdDomain, IdSubDomain);
               if (!isSkip)
               {
                   foreach (AssessmentTempInfo tempData in sourceTemp)
                   {
                       tempDataDao.SaveTempData(tempData);
                   }
               }
               else
               {
                   notInUseBL.SaveOrUpdate(Assessment.ID, IdDomain, IdSubDomain);
               }
               assessmentDao.Commit();
               return true;
           }
           catch (Exception ex)
           {
               assessmentDao.Rollback();
               return false;
           }



Also find the code for begin transaction and rollback tranaction

public IDbTransaction BeginTransaction()
{
DbConnection connection = GetConnection();
_dbTransaction = connection.BeginTransaction();

//Set Transaction Indicator
IsInTransaction = true;

return _dbTransaction;
}

public void CommitTransaction()
{
_dbTransaction.Commit();
_dbConnection.Close();

_dbTransaction = null;

//Set Transaction Indicator
IsInTransaction = false;
}

public void RollbackTransaction()
{
_dbTransaction.Rollback();
_dbTransaction.Dispose();
_dbConnection.Close();

//Set Transaction Indicator
_dbTransaction = null;
IsInTransaction = false;
}

private DbConnection GetConnection()
{
_dbConnection = Database.CreateConnection();
_dbConnection.Open();
return _dbConnection;
}

#endregion

///
/// Exposing the database property
///

public Database Database
{
get
{
return DatabaseFactorySingleton.GetDatabase();
}
}

}
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900