This SqlTransaction has completed; it is no longer usable.
Hej eksperter!Jeg sidder med et meget meget irriterende problem.
Koden ser ud som følger.
db.Open();
transaction = db.BeginTransaction();
db.Close();
try
{
foreach (string varnavn in Varname)
{
cmd = new SqlCommand
(Makestring_tbl_questionrel_variables(qid,
varnavn), db, transaction);
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
cmd.Dispose();
}
// Nu forsøger vi at definere alle ejerskaber for
foreach (Owner2Unit o2u in ownerships)
{
foreach (int omraade in o2u.Omraader)
{
cmd = new SqlCommand
(Makestring_tbl_question_2_owner(o2u.Ejer_ID,
qid, omraade, o2u.IsOne), db, transaction);
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
cmd.Dispose();
}
}
foreach (int costype in Kundetyper)
{
cmd = new SqlCommand
(Makestring_tbl_questionrel_costumortype(qid,
costype), db, transaction);
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
cmd.Dispose();
}
transaction.Commit();
}
catch (SqlException sqlError)
{
transaction.Rollback();
}
//transaction.Rollback();
db.Close();
}
Jeg får på transaction.Commit() en fejl der lyder:
This SqlTransaction has completed; it is no longer usable.
Dataene bliver stadig sat i databasen korrekt, så det er egenligt bare hammer irriterende at den exception overhovedet findes.
Det sidste step i stack trace back er.
System.Data.SqlClient.SqlTransaction.ZombieCheck()
HJÆÆLP :)