public void Different_Where_Clauses_Return_Different_Keys()
{
using (var s = OpenSession())
{
var db = new Northwind(s);
Expression<Func<IEnumerable<Customer>>> london =
() => from c in db.Customers where c.Address.City == "London" select c;
Expression<Func<IEnumerable<Customer>>> company =
() => from c in db.Customers where c.CompanyName == "Acme" select c;
var nhLondon = new NhLinqExpression(london.Body);
var nhNewYork = new NhLinqExpression(company.Body);
Assert.AreNotEqual(nhLondon.Key, nhNewYork.Key);
}
}
public void Different_Select_Properties_Return_Different_Keys()
{
using (var s = OpenSession())
{
var db = new Northwind(s);
Expression<Func<IEnumerable<string>>> customerId =
() => from c in db.Customers select c.CustomerId;
Expression<Func<IEnumerable<string>>> title =
() => from c in db.Customers select c.ContactTitle;
var nhLondon = new NhLinqExpression(customerId.Body);
var nhNewYork = new NhLinqExpression(title.Body);
Assert.AreNotEqual(nhLondon.Key, nhNewYork.Key);
}
}
public void Identical_Expressions_Return_The_Same_Key()
{
using (var s = OpenSession())
{
var db = new Northwind(s);
Expression<Func<IEnumerable<Customer>>> london1 =
() => from c in db.Customers where c.Address.City == "London" select c;
Expression<Func<IEnumerable<Customer>>> london2 =
() => from c in db.Customers where c.Address.City == "London" select c;
var nhLondon1 = new NhLinqExpression(london1.Body);
var nhLondon2 = new NhLinqExpression(london2.Body);
Assert.AreEqual(nhLondon1.Key, nhLondon2.Key);
}
}
public void Expressions_Differing_Only_By_Constants_Return_The_Same_Key()
{
using (var s = OpenSession())
{
var db = new Northwind(s);
Expression<Func<IEnumerable<Customer>>> london =
() => from c in db.Customers where c.Address.City == "London" select c;
Expression<Func<IEnumerable<Customer>>> newYork =
() => from c in db.Customers where c.Address.City == "New York" select c;
var nhLondon = new NhLinqExpression(london.Body);
var nhNewYork = new NhLinqExpression(newYork.Body);
Assert.AreEqual(nhLondon.Key, nhNewYork.Key);
Assert.AreEqual(1, nhLondon.ParameterValuesByName.Count);
Assert.AreEqual(1, nhNewYork.ParameterValuesByName.Count);
Assert.AreEqual("London", nhLondon.ParameterValuesByName.First().Value.First);
Assert.AreEqual("New York", nhNewYork.ParameterValuesByName.First().Value.First);
}
}
protected override void OnSetUp()
{
base.OnSetUp();
_session = OpenSession();
_northwind = new Northwind(_session);
}
public void Different_Select_Types_Return_Different_Keys()
{
using (var s = OpenSession())
{
var db = new Northwind(s);
Expression<Func<IEnumerable>> newCustomerId =
() => from c in db.Customers select new {c.CustomerId};
Expression<Func<IEnumerable>> customerId =
() => from c in db.Customers select c.CustomerId;
var nhLondon = new NhLinqExpression(newCustomerId.Body);
var nhNewYork = new NhLinqExpression(customerId.Body);
Assert.AreNotEqual(nhLondon.Key, nhNewYork.Key);
}
}
public void Different_Unary_Operation_Returns_Different_Keys()
{
using (var s = OpenSession())
{
var db = new Northwind(s);
Expression<Func<IEnumerable>> newCustomerId =
() => from c in db.Customers where c.CustomerId == "1" select c;
Expression<Func<IEnumerable>> customerId =
() => from c in db.Customers where !(c.CustomerId == "1") select c;
var nhLondon = new NhLinqExpression(newCustomerId.Body);
var nhNewYork = new NhLinqExpression(customerId.Body);
Assert.AreNotEqual(nhLondon.Key, nhNewYork.Key);
}
}
public void Different_Conditionals_Return_Different_Keys()
{
using (var s = OpenSession())
{
var db = new Northwind(s);
Expression<Func<IEnumerable>> newCustomerId =
() => from c in db.Customers select new { Desc = c.CustomerId == "1" ? "First" : "Not First" };
Expression<Func<IEnumerable>> customerId =
() => from c in db.Customers select new { Desc = c.CustomerId != "1" ? "First" : "Not First" };
var nhLondon = new NhLinqExpression(newCustomerId.Body);
var nhNewYork = new NhLinqExpression(customerId.Body);
Assert.AreNotEqual(nhLondon.Key, nhNewYork.Key);
}
}
public void Different_Select_Member_Initialisation_Returns_Different_Keys()
{
using (var s = OpenSession())
{
var db = new Northwind(s);
Expression<Func<IEnumerable>> newCustomerId =
() => from c in db.Customers select new { Id = c.CustomerId, Title = c.ContactTitle };
Expression<Func<IEnumerable>> customerId =
() => from c in db.Customers select new { Title = c.ContactTitle, Id = c.CustomerId };
var nhLondon = new NhLinqExpression(newCustomerId.Body);
var nhNewYork = new NhLinqExpression(customerId.Body);
Assert.AreNotEqual(nhLondon.Key, nhNewYork.Key);
}
}
