Re: Implicit Transaction

Shiva — Fri, 05 Dec 2008 13:19:00 GMT

Hello,

Here is the code to execute StoreProcedure,

SqlCommand command = new SqlCommand("dbo.SaveSQLComplexDBinfo", sqlConnection);

command.CommandType = System.Data.CommandType.StoredProcedure;

command.Parameters.Add("@SQLComplexDBID", SqlDbType.Int).Value = "96";

command.Parameters.Add("@SQLComplexDBID", SqlDbType.Int).Value = "SQLDA-CX02";

command.Parameters.Add("@ComplexName ", SqlDbType.Int).Value = "ATT25";

command.Parameters.Add("@DBName", SqlDbType.Int).Value = "ACTT";

int i = command.ExecuteNonQuery();

Implicit Transaction

AliMalek — Fri, 28 Nov 2008 21:20:10 GMT

I use something like the following code when I need to save data fields on SQL Server:

XDocument.QueryAdapter.Command = "exec dbo.SaveSQLComplexDBinfo " + SQLComplexDBID + ",'" + ComplexName + "','" + DBName + "','" + AppCode + "'";
XDocument.Query();

When I check database activity, I see that something like this will be issued to SQL Server:

set implicit_transactions on SET NO_BROWSETABLE ON
exec dbo.SaveSQLComplexDBinfo 96,SQLDA-CX02','ATT25','ACTT'
IF @@TRANCOUNT > 0 ROLLBACK TRAN

I need the data to be saved. Why does Query() method wrap the actual query in a transaction and how can I prevent that?

Thanks

SQL Database Integration

Re: Implicit Transaction

Implicit Transaction