BeginExecuteNonQuery - call a procedure without waiting for it to complete
Posted on 2014-07-16
I am running a query in sql that takes many minutes to execute. I want to call the query from my website and the user should not have to wait for it to finish, i.e. as soon as he gives the command to execute the query he should be able to go to do somehting else on my website. I am trying to use BeginExecuteNonQuery.
With following code I do not call the pocedure. Do you know what I am doing wrong?
public void test_T1_Insert(string t1)
SqlCommand command = new SqlCommand("test_T1_Insert", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Value = t1;