public void Execute_WaitFor3SecondsTimeoutSetTo0_NoTimeOut()
{
var query = "WAITFOR DELAY '00:00:03';";
var cmd = new OdbcCommand(query, new OdbcConnection(ConnectionStringReader.GetOdbcSql()))
{
CommandTimeout = 0
};
var qe = new OdbcExecutionEngine(cmd.Connection, cmd);
Assert.DoesNotThrow(delegate { qe.Execute(); });
}
public void Execute_ValidQuery_DataSetFilled()
{
var query = "select * from [Sales].[Currency];";
var cmd = new OdbcCommand(query, new OdbcConnection(ConnectionStringReader.GetOdbcSql()))
{
CommandTimeout = 0
};
var qe = new OdbcExecutionEngine(cmd.Connection, cmd);
var ds = qe.Execute();
Assert.That(ds.Tables, Has.Count.EqualTo(1));
Assert.That(ds.Tables[0].Columns, Has.Count.EqualTo(3));
Assert.That(ds.Tables[0].Rows, Has.Count.EqualTo(105));
}
