dotConnect is calling the stored procedure 2x
Posted: Tue 01 Dec 2009 17:08
I have verified that from my C# code the stored procedure is getting called 2x.
I added this line into ALL my stored procedures called by my C#/ASP code and confirmed that this line is executing 2x for every 1 call to a stored procedure.
INSERT INTO test (`count`) VALUES (2);
Is there a property on the dotConnect objects I am using I need to set, or is this a bug? It is a serious bug that is a show stopper for me right now.
-- Sample Code --
Thanks
I added this line into ALL my stored procedures called by my C#/ASP code and confirmed that this line is executing 2x for every 1 call to a stored procedure.
INSERT INTO test (`count`) VALUES (2);
Is there a property on the dotConnect objects I am using I need to set, or is this a bug? It is a serious bug that is a show stopper for me right now.
-- Sample Code --
Code: Select all
Devart.Data.MySql.Web.MySqlDataSource mySqlDataSource = new Devart.Data.MySql.Web.MySqlDataSource(Constants.Config.ConnectionString, "foo");
mySqlDataSource.SelectCommandType = SqlDataSourceCommandType.StoredProcedure;
mySqlDataSource.Selected += new SqlDataSourceStatusEventHandler(Call_OnSelected);
mySqlDataSource.SelectParameters.Add("id1", System.Data.DbType.Int64, "1");
mySqlDataSource.SelectParameters.Add("id2", System.Data.DbType.Int64, "2");
Parameter result = new Parameter("result", System.Data.DbType.String);
result.Direction = System.Data.ParameterDirection.Output;
mySqlDataSource.SelectParameters.Add(result);
// Tried with and without this statement...
// mySqlDataSource.DataBind();
mySqlDataSource.Select(DataSourceSelectArguments.Empty);