public void Northwind_SimpleDynamicSelectMatchesNormalSelect()
{
using (var connection = Effort.DbConnectionFactory.CreateTransient())
using (var context = new NorthwindContext(connection, contextOwnsConnection: true))
{
var dynamicSelectQueryable = new QueryableDynamicSelector().SelectProperties(context.Customers, new HashSet<string> { "CustomerID", "ContactName" });
var dynamicSelectSql = dynamicSelectQueryable.ToString();
var normalSelectQueryable = context.Customers.Select(c => new { c.CustomerID, c.ContactName });
var normalSelectSql = normalSelectQueryable.ToString();
Assert.AreEqual(normalSelectSql, dynamicSelectSql);
}
}
public void Northwind_SimpleDynamicSelectMatchesNormalSelect()
{
using (var connection = Effort.DbConnectionFactory.CreateTransient())
using (var context = new NorthwindContext(connection, contextOwnsConnection: true))
{
var dynamicSelectQueryable = new QueryableDynamicSelector().SelectProperties(context.Customers, new HashSet <string> {
"CustomerID", "ContactName"
});
var dynamicSelectSql = dynamicSelectQueryable.ToString();
var normalSelectQueryable = context.Customers.Select(c => new { c.CustomerID, c.ContactName });
var normalSelectSql = normalSelectQueryable.ToString();
Assert.AreEqual(normalSelectSql, dynamicSelectSql);
}
}
