Filtering problem when using IQueryable

[FISCAL]

HI,

I am using IQueryable approach to create dynamic query. All seems okay apart from OpenAccess not supporting something like..

..

  if (m_dataContext.Transaction.IsActive == false) m_dataContext.Transaction.Begin();

            IQueryable<AdmAudit> audits = m_dataContext.Extent<AdmAudit>();

            if (dateTo.HasValue)

            {

                //Convert.ToDateTime is not supported in where clause to it needs to be converted before passing it

                //OpenAccess implementation lacking

                dateTo = Convert.ToDateTime(dateTo).Date;

                audits.Where(audit=> audit.AdmAuditRecordEntered <= dateTo);

            }

//Search for string..

               audits = audits.Where(audit => audit.Log.Contains(strSeachString));

Above bold instruction is failing.

Any help would be highly appreciated.

Many thanks.

M G

[Thomas]

Hi M G,

I think the issue is that in the (potential) first invocation the audits variable is not updated with the new queryable instance that contains the date filter. You did that for the second .Where() though!

Sincerely yours,
Thomas
the Telerik team