public void TestOrderRemains()
{
Query query = QueryFactory.CreateQuery();
query.Text = @"
SELECT TRIM(c.CategoryName) as CategoryName,
FIRST(c.Description) as Description,
FIRST(c.Picture) as Picture,
CONCAT(p.ProductName) Products,
COUNT(*) * 2 ProductCount
FROM Products p
INNER JOIN Categories c ON c.CategoryID = p.CategoryID
GROUP BY c.CategoryName
ORDER BY COUNT(*) DESC
";
using (QueryDataReader reader = query.ExecuteSchemaReader())
{
Assert.AreEqual(0, reader.GetOrdinal("CategoryName"));
Assert.AreEqual(1, reader.GetOrdinal("Description"));
Assert.AreEqual(2, reader.GetOrdinal("Picture"));
Assert.AreEqual(3, reader.GetOrdinal("Products"));
Assert.AreEqual(4, reader.GetOrdinal("ProductCount"));
}
}
static IDataReader DataReaderReady(IDataReader dataReader, IObjectActivator objectActivator)
{
if (objectActivator is RootEntityActivator)
{
dataReader = new QueryDataReader(dataReader);
}
objectActivator.Prepare(dataReader);
return(dataReader);
}
public void QueryDataReader()
{
Query query = QueryFactory.CreateQuery();
query.Text = "SELECT * FROM Employees";
using (QueryDataReader queryDataReader = query.ExecuteDataReader())
{
ExpectArgumentNull("values", delegate { queryDataReader.GetValues(null); });
ExpectArgumentNull("name", delegate { queryDataReader.GetOrdinal(null); });
ExpectArgumentNull("name", delegate { IgnoreValue(queryDataReader[null]); });
}
}
public IEnumerator <T> GetEnumerator()
{
DbCommandFactor commandFactor = this.GenerateCommandFactor();
var enumerator = QueryEnumeratorCreator.CreateEnumerator <T>(commandFactor, cmdFactor =>
{
IDataReader dataReader = this._query.DbContext.AdoSession.ExecuteReader(cmdFactor.CommandText, cmdFactor.Parameters, CommandType.Text);
if (cmdFactor.ObjectActivator is RootEntityActivator)
{
dataReader = new QueryDataReader(dataReader);
}
cmdFactor.ObjectActivator.Prepare(dataReader);
return(dataReader);
});
return(enumerator);
}
