private void TimeoutCancel(string constr)
{
using (SqlConnection con = new SqlConnection(constr))
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandTimeout = 1;
cmd.CommandText = "WAITFOR DELAY '00:00:30';select * from Customers";
string errorMessage = SystemDataResourceManager.Instance.SQL_Timeout;
DataTestClass.ExpectFailure <SqlException>(() => cmd.ExecuteReader(), errorMessage);
VerifyConnection(cmd);
}
}
public void ExecuteCommandCancelExpected(object state)
{
var stateTuple = (Tuple <bool, SqlCommand, Barrier>)state;
bool async = stateTuple.Item1;
SqlCommand command = stateTuple.Item2;
Barrier threadsReady = stateTuple.Item3;
string errorMessage = SystemDataResourceManager.Instance.SQL_OperationCancelled;
DataTestClass.ExpectFailure <SqlException>(() =>
{
threadsReady.SignalAndWait();
using (SqlDataReader r = command.ExecuteReader())
{
do
{
while (r.Read())
{
}
} while (r.NextResult());
}
}, errorMessage);
}