public void AndGroup_SqlFilter_Success() { var filter = SqlFilter <Person> .From(m => m.Id).EqualTo(5); Assert.Equal("pe.Id = 5 AND (pe.Id = 5)", filter.AndGroup(filter).RawSql); }
public void AndGroup_EmptyFilterWithSqlFilter_Success() { var filter = SqlFilter <Person> .From(m => m.Id).EqualTo(5); Assert.Equal("(pe.Id = 5)", SqlFilter <Person> .Empty.AndGroup(filter).RawSql); }
public void Or_EmptyFilterWithSqlFilterBase_Success() { var filter = SqlFilter <Passport> .From(m => m.Id).EqualTo(6); Assert.Equal("pa.Id = 6", SqlFilter <Person> .Empty.Or(filter).RawSql); }
public void From_GenericSqlField_Success() { var filter = SqlFilter <Person> .From(SqlField <Person> .From(m => m.Id)).EqualTo(5); Assert.Equal("pe.Id = 5", filter.RawSql); }
public void Or_SqlFilter_Success() { var filter = SqlFilter <Person> .From(m => m.Id).EqualTo(5); Assert.Equal("pe.Id = 5 OR pe.Id = 5", filter.Or(filter).RawSql); }
public void Or_EmptyFilterWithSqlFilter_Success() { var filter = SqlFilter <Person> .From(m => m.Id).EqualTo(5); Assert.Equal("pe.Id = 5", SqlFilter <Person> .Empty.Or(filter).RawSql); }
public void From_LambdaExpressionWithAlias_Success() { var filter = SqlFilter <Person> .From(m => m.Id, new SqlAlias <Person>("al")).EqualTo(5); Assert.Equal("al.Id = 5", filter.RawSql); }
public void From_LambdaExpression_Success() { var filter = SqlFilter <Person> .From(m => m.Id).EqualTo(5); Assert.Equal("pe.Id = 5", filter.RawSql); }
public void And_EmptyFilterWithSqlFilter_Success() { var filter = SqlFilter <Person> .From(m => m.Id).EqualTo(5); Assert.Equal("pe.Id = 5", SqlFilter <Passport> .Empty.And(SqlFilter <Person> .Empty).And(filter).RawSql); }
public void OrGroup_EmptyFilterWithSqlFilterBase_Success() { var filter = SqlFilter <Passport> .From(m => m.Id).EqualTo(6); Assert.Equal("(pa.Id = 6)", SqlFilter <Passport> .Empty.And(SqlFilter <Person> .Empty).OrGroup(filter).RawSql); }
public void OrGroup_SqlFilter_Success() { var filter = SqlFilter <Person> .From(m => m.Id).EqualTo(5); Assert.Equal("pe.Id = 5 OR (pe.Id = 5)", SqlFilter <Passport> .Empty.And(filter).OrGroup(filter).RawSql); }