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)); }