//-----------------------------------------------------------------------------------------------------
public SqlFilter <TEntity> WithParameterPrefix(string prefix)
{
var filter = new SqlFilter <TEntity>(FilterItems);
filter.ParamPrefix = prefix;
return(filter);
}
public SqlFilter <TEntity> WithAliases()
{
var filter = new SqlFilter <TEntity>(FilterItems);
filter.MustBeWithoutAliases = false;
return(filter);
}
//-----------------------------------------------------------------------------------------------------
public SqlFilter <TEntity> OrGroup(SqlFilter <TEntity> filter)
{
var items = AddItem(SqlFilterItems.Or)
.Add(SqlFilterItems.Build("("))
.AddRange(filter.FilterItems)
.Add(SqlFilterItems.Build(")"));
return(new SqlFilter <TEntity>(items));
}
public SqlFilter <TEntity> And(SqlFilter <TEntity> filter)
{
return(new SqlFilter <TEntity>(AddItem(SqlFilterItems.And).AddRange(filter.FilterItems)));
}