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 ExecuteScalar_ValidQuery_DataSetFilled()
{
var query = "select top(1) CurrencyCode from [Sales].[Currency] where Name like '%Canad%'";
var cmd = new OdbcCommand(query, new OdbcConnection(ConnectionStringReader.GetOdbcSql()))
{
CommandTimeout = 0
};
var qe = new OdbcExecutionEngine(cmd.Connection, cmd);
var value = qe.ExecuteScalar();
Assert.That(value, Is.EqualTo("CAD"));
}
public void ExecuteList_ValidQuery_DataSetFilled()
{
var query = "select top(10) CurrencyCode from [Sales].[Currency] where CurrencyCode like '%D' order by 1 asc";
var cmd = new OdbcCommand(query, new OdbcConnection(ConnectionStringReader.GetOdbcSql()))
{
CommandTimeout = 0
};
var qe = new OdbcExecutionEngine(cmd.Connection, cmd);
var values = qe.ExecuteList <string>();
Assert.That(values, Has.Count.EqualTo(10));
Assert.That(values, Has.Member("CAD"));
}
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));
}
