public void Execute_Integer_ScalarReturned() { SqlClient session = new SqlClientFactory().Instantiate(ConnectionStringReader.GetLocaleSql()) as SqlClient; var statement = Mock.Of <IQuery>(x => x.Statement == "SELECT VALUE count(1) FROM FoF f WHERE f.label='person'"); SqlCommandOperation cosmosdbQuery = new SqlCommandFactory().Instantiate(session, statement).Implementation as SqlCommandOperation; var engine = new SqlExecutionEngine(session.CreateClientOperation(), cosmosdbQuery); var age = engine.ExecuteScalar(); Assert.That(age, Is.EqualTo(4)); }
public void Execute_NullString_ScalarReturned() { SqlClient session = new SqlClientFactory().Instantiate(ConnectionStringReader.GetLocaleSql()) as SqlClient; var statement = Mock.Of <IQuery>(x => x.Statement == "SELECT VALUE p.lastName[0]._value FROM ROOT p WHERE p.label = 'person' and p.firstName[0]._value = 'Thomas'"); SqlCommandOperation cosmosdbQuery = new SqlCommandFactory().Instantiate(session, statement).Implementation as SqlCommandOperation; var engine = new SqlExecutionEngine(session.CreateClientOperation(), cosmosdbQuery); var count = engine.ExecuteScalar(); Assert.That(count, Is.Null); }
public void ExecuteScalar_ValidQuery_DataSetFilled() { var query = "select top(1) CurrencyCode from [Sales].[Currency] where Name like '%Canad%'"; var cmd = new SqlCommand(query, new SqlConnection(ConnectionStringReader.GetSqlClient())) { CommandTimeout = 0 }; var qe = new SqlExecutionEngine(cmd.Connection, cmd); var value = qe.ExecuteScalar(); Assert.That(value, Is.EqualTo("CAD")); }