public string GetExpression() { var filterExp = GetSqlExpression(); filterExp = Fields.Aggregate(filterExp, (current, f) => current.Replace(f.SourceName, f.Caption)); filterExp = filterExp.Replace("ROWNUM", StringResources.FilterMaxRowCount); var ar = new[] { "AND", "And", "and", "OR", "Or", "or" }; filterExp = ar.Aggregate(filterExp, (current, s) => current.Replace(s + " ", s + "\r")); filterExp = filterExp.Replace("(", "").Replace(")", ""); return(filterExp); }