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); }