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