Problem with Compiled Query

Hi,

I have some problems trying to change my queries in compiled queries. First I wanted to check if string parameter is empty and I always got error. My linq looked like this:

                GetUnreadListQuery =
                (
                    from
                        notification in unitOfWork.Notifications
                    join un in unitOfWork.UserNotifications on notification.Id equals un.NotificationId
                    orderby notification.Date descending
                    where
                        un.UserId == CompiledQuery.Parameter<int>("userId") && un.WasRead == false
                        &&(
                        CompiledQuery.Parameter<string>("filterValue") == ""
                        || (notification.Message != null && notification.Message.Contains(CompiledQuery.Parameter<string>("filterValue")))
                        || (notification.RelatedToName != null && notification.RelatedToName.Contains(CompiledQuery.Parameter<string>("filterValue")))
                        || (notification.VersionName != null && notification.VersionName.Contains(CompiledQuery.Parameter<string>("filterValue")))
                        )
                    select
                           (DTO.NotificationDTO.Notification)notification
                ).Compile();

Then I changed it to (so I only passed the result of checking if filterValue was empty):

                GetUnreadListQuery =
                (
                    from
                        notification in unitOfWork.Notifications
                    join un in unitOfWork.UserNotifications on notification.Id equals un.NotificationId
                    orderby notification.Date descending
                    where
                        un.UserId == CompiledQuery.Parameter<int>("userId") && un.WasRead == false
                        &&(
                        CompiledQuery.Parameter<bool>("isEmptyFilter")
                        || (notification.Message != null && notification.Message.Contains(CompiledQuery.Parameter<string>("filterValue")))
                        || (notification.RelatedToName != null && notification.RelatedToName.Contains(CompiledQuery.Parameter<string>("filterValue")))
                        || (notification.VersionName != null && notification.VersionName.Contains(CompiledQuery.Parameter<string>("filterValue")))
                        )
                    select
                           (DTO.NotificationDTO.Notification)notification
                ).Compile();

And at least the error disappeared but I got a problem:

Every time when filterValue parameter was not empty (so CompiledQuery.Parameter("isEmptyFilter") was false) I got no results. Like parameters with 'Contains' operation didn't work... Is this correct?

Cause the whole query worked fine before I used compiled query and CompiledQuery.Parameter...

I'll be grateful for your help and some explanation.

Best regards, Lukasz

Yes, unfortunately this is not supported as we need to escape and add the surrounding wildcards which is not something we can handle within the compiled query framework.

I will add a check for this to provide a better message which would be triggered on the .Compile() call to alert you to the issue.

Jeremy