I think it would be pretty slick to be able to build the following type of filtering methods straight from the LLBLGen UI.

        Public Function GetByField(ByVal index As WorksheetsFieldIndex, ByVal value As Object) As WorksheetsCollection
            Dim filter As IPredicateExpression = New PredicateExpression
            filter.Add(PredicateFactory.CompareValue(index, ComparisonOperator.Equal, value))
            Dim toReturn As WorksheetsCollection = New WorksheetsCollection
            toReturn.GetMulti(filter)
            Return toReturn
        End Function

Or Like

         Public Function GetWorksheetSummary(ByVal empID As Int32) As WorksheetsCollection
            Dim filter As IPredicateExpression = New PredicateExpression
            filter.Add(PredicateFactory.CompareValue(WorksheetsFieldIndex.EmployeeID, ComparisonOperator.Equal, empID))
            filter.Add(PredicateFactory.CompareValue(WorksheetsFieldIndex.Completed, ComparisonOperator.Equal, 1))
            Dim toReturn As WorksheetsCollection = New WorksheetsCollection
            toReturn.GetMulti(filter)
            Return toReturn
        End Function

It might sound great at first, but updating filters will be horrible. The problem is that when you want to update a filter to add another predicate/change a predicate, you have to return to the designer, change the predicate, generate code etc.

It will then be much faster to simply adjust the generated code, which is probably not a good idea.

Otis wrote:

It might sound great at first, but updating filters will be horrible. The problem is that when you want to update a filter to add another predicate/change a predicate, you have to return to the designer, change the predicate, generate code etc.

It will then be much faster to simply adjust the generated code, which is probably not a good idea.

But what about a tool that just generates code that you can copy/paste into your project? It would just help you put together the proper syntax for predicate/sort expressions? I could see that being useful.

True, a plugin for vs.net for example?

Otis wrote:

True, a plugin for vs.net for example?

Oooh! I like that!

It's already on the todo