Hi,

I know its not the way of doing this normally, but sometimes i want to add some query-text to a query which is a LLBLGen Pro - Collection.

I've for example the following for the WHERE clause:

AND DocID IN (
    SELECT DocID
    FROM Documenten
    WHERE (DocContactID = 2 OR DocContactID IN (SELECT CGContactID FROM ContactGebr WHERE CGGebrID=12)
    UNION
    SELECT DocID
        FROM Documenten, DocDoc, DocRoutes, DocRouteGebruikers
    WHERE DDDocID2 = DocID
    AND DDDocID1 = RouteDocID
    AND RGRouteID = RouteID
    AND RGGebrID = 12))

I know it's all possible to put this in a PredicateExpression but is there a way to add this standard SQL to a LLBLGenPro - Collection?

I know it's all possible to put this in a PredicateExpression but is there a way to add this standard SQL to a LLBLGenPro - Collection?

Regardeless of the query itself (coz I can't understand it without knowing the relevant tables structures and which is the collection you are fetching)

If you are using SelfServicing, you may extend the EntityCollection class (using the partial keyword), add a new method that wraps the base.GetMulti() method. So you can add the predicate expression that you want, and pass it to the GetMulti().

In adapter this can be better done in a BL method that calls the DAL ( adpater.FetchEntityCollection() )

Is it possible to add this SQL-WHERE clause (of course without the keyword WHERE) in a predicate expression without writing it the normal (Object Orientied) way. So without writing a RelationCollection etc, just plump the text in de predicate expression? I need it only one time, so I know I wan't it in a quick and dirty way....

I need it only one time, so I know I wan't it in a quick and dirty way....

If you are gonna write it once, why do you want to write it in a dirty way?

Otherwise you may want to use a storedProcedure, and then you can project the returned resultSet to a an EntityCollection.

So is my conclusion right that there is no other way to add "navtive SQL" to an entitycollection / predicate-expression?

You could create a class that inherits from SD.LLBLGen.Pro.ORMSupportClasses.IPredicate and embed your custom SQL in the ToQueryText method.

Thanks,

I created the following class and all works fine:

    public class FreePredicate : SD.LLBLGen.Pro.ORMSupportClasses.Predicate
    {
        string _filter;

        public FreePredicate(string filter)
        {
            _filter = filter;
        }

        public override string ToQueryText(ref int uniqueMarker)
        {
            return _filter;
        }

        public override string ToQueryText(ref int uniqueMarker, bool inHavingClause)
        {
            return _filter;
        }
    }