public void ShouldReturnCorrectDetachedCriteriaGivenJoinRelationshipWithEqualAllowingNull()
{
CriteriaBuilder <MockClass> c = new CriteriaBuilder <MockClass>().EqJoinAllowingNull("mock", m => m.mock.StringField, "test");
string test = c.GetDetachedCriteria().ToString();
Assert.True(test == "DetachableCriteria(mock.StringField = test)", "Current value: " + test);
}
public void ShouldReturnCorrectDetachedCriteriaGivenWhereClouseOrWithEqualsAndLike()
{
CriteriaBuilder <MockClass> c = new CriteriaBuilder <MockClass>().OrEqLike(m => m.Id, 1, t => t.StringField, "test");
string test = c.GetDetachedCriteria().ToString();
Assert.True(test == "DetachableCriteria((this_.Id = 1 or this_.StringField like %test%))", "Current value: " + test);
}
public void ShouldReturnCorrectDetachedCriteriaGivenWhereClouseEqPassingParameterDatePart()
{
CriteriaBuilder <MockClass> c = new CriteriaBuilder <MockClass>().EqDatePartAllowingNull(m => m.DateTimeField, 2013, DatePart.Year);
string test = c.GetDetachedCriteria().ToString();
Assert.True(test == "DetachableCriteria(NHibernate.Criterion.SqlFunctionProjection = 2013)", "Current value: " + test);
}
public void ShouldReturnCorrectDetachedCriteriaGivenWhereClauseLessThanPassingParameter()
{
CriteriaBuilder <MockClass> c = new CriteriaBuilder <MockClass>().LessThan(m => m.Id, 2);
string test = c.GetDetachedCriteria().ToString();
Assert.True(test == "DetachableCriteria(this_.Id < 2)", "Current value: " + test);
}
public void ShouldReturnCorrectDetachedCriteriaGivenWhereClauseBetween()
{
CriteriaBuilder <MockClass> c = new CriteriaBuilder <MockClass>().Between(m => m.DecimalField, 1.3, 100.5);
string test = c.GetDetachedCriteria().ToString();
Assert.True(test == "DetachableCriteria(this_.DecimalField between 1,3 and 100,5)", "Current value: " + test);
}
public void ShouldReturnCorrectDetachedCriteriaGivenWhereClauseLikePassingParameterNull()
{
CriteriaBuilder <MockClass> c = new CriteriaBuilder <MockClass>().LikeAllowingNull(m => m.StringField, null);
string test = c.GetDetachedCriteria().ToString();
Assert.True(test == "DetachableCriteria()", "Current value: " + test);
}
public void ShouldReturnCorrectDetachedCriteriaGivenWhereClauseLikeAndEqualPassingParameter()
{
CriteriaBuilder <MockClass> c = new CriteriaBuilder <MockClass>().Like(m => m.StringField, "test")
.Eq(m => m.Id, 1);
string test = c.GetDetachedCriteria().ToString();
Assert.True(test == "DetachableCriteria(this_.StringField like %test% and this_.Id = 1)", "Current value: " + test);
}
