public void Execute_ListOfString_ListReturned() { 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'"); SqlCommandOperation cosmosdbQuery = new SqlCommandFactory().Instantiate(session, statement).Implementation as SqlCommandOperation; var engine = new SqlExecutionEngine(session.CreateClientOperation(), cosmosdbQuery); var count = engine.ExecuteList <object>(); Assert.That(count, Has.Member("Andersen")); Assert.That(count, Has.Member("Miller")); Assert.That(count, Has.Member("Wakefield")); }
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 SqlCommand(query, new SqlConnection(ConnectionStringReader.GetSqlClient())) { CommandTimeout = 0 }; var qe = new SqlExecutionEngine(cmd.Connection, cmd); var values = qe.ExecuteList <string>(); Assert.That(values, Has.Count.EqualTo(10)); Assert.That(values, Has.Member("CAD")); }