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, sessions);
var nhNewYork = new NhLinqExpression(title.Body, sessions);
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, sessions);
var nhLondon2 = new NhLinqExpression(london2.Body, sessions);
Assert.AreEqual(nhLondon1.Key, nhLondon2.Key);
}
}
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, sessions);
var nhNewYork = new NhLinqExpression(company.Body, sessions);
Assert.AreNotEqual(nhLondon.Key, nhNewYork.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, sessions);
var nhNewYork = new NhLinqExpression(newYork.Body, sessions);
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.Item1);
Assert.AreEqual("New York", nhNewYork.ParameterValuesByName.First().Value.Item1);
}
}
public void CanSpecifyParameterTypeInfo()
{
using (var s = OpenSession())
{
var db = new Northwind(s);
Expression<Func<IEnumerable<Customer>>> london =
() => from c in db.Customers where c.Address.City == "London".MappedAs(NHibernateUtil.StringClob) select c;
Expression<Func<IEnumerable<Customer>>> newYork =
() => from c in db.Customers where c.Address.City == "New York".MappedAs(NHibernateUtil.AnsiString) select c;
var nhLondon = new NhLinqExpression(london.Body, sessions);
var nhNewYork = new NhLinqExpression(newYork.Body, sessions);
var londonParameter = nhLondon.ParameterValuesByName.Single().Value;
Assert.That(londonParameter.Item1, Is.EqualTo("London"));
Assert.That(londonParameter.Item2, Is.EqualTo(NHibernateUtil.StringClob));
var newYorkParameter = nhNewYork.ParameterValuesByName.Single().Value;
Assert.That(newYorkParameter.Item1, Is.EqualTo("New York"));
Assert.That(newYorkParameter.Item2, Is.EqualTo(NHibernateUtil.AnsiString));
}
}
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, sessions);
var nhNewYork = new NhLinqExpression(customerId.Body, sessions);
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, sessions);
var nhNewYork = new NhLinqExpression(customerId.Body, sessions);
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, sessions);
var nhNewYork = new NhLinqExpression(customerId.Body, sessions);
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, sessions);
var nhNewYork = new NhLinqExpression(customerId.Body, sessions);
Assert.AreNotEqual(nhLondon.Key, nhNewYork.Key);
}
}
