LS 4 & Count() issue against Soft Delete based entity

I have a standard Paging class that accepts an IQueryable and internally performs 2 executions.

1st is to get the total records and is nothing more than a Count() on the query.

2nd is a ToList() skipping and taking accordingly.

When doing this on a SoftDelete based entity the generated SQL doesn't include DeletedOn in the subquery so the outer where clause fails as that has the an additional where for the DeletedOn IS NULL.

Below is some sql generated from out Linq query which describes the problem.  Not sure we need the outer where clause as it is already defined in the inner query.

SELECT
  COUNT(*)
FROM
  (
    SELECT
      [t0].[Id]
    FROM
      [Job] [t0]
    INNER JOIN
      [Employer] [t1]
    ON
      [t0].[EmployerId] = [t1].[Id]
    INNER JOIN
      [Employer] [t2]
    ON
      [t0].[EmployerId] = [t2].[Id]
    LEFT OUTER JOIN
      [BusinessUnit] [t3]
    ON
      [t0].[BusinessUnitId] = [t3].[Id]
    WHERE
      (((EXISTS (
        SELECT
          [t1].*
        FROM
          [Employer] [t1]
        WHERE
          [t1].[Id] = [t0].[EmployerId] AND
          [t1].[Id] = 29441
      ) AND [t0].[JobStatus] = 1) AND [t2].[Id] = 29441) AND [t0].[DeletedOn] IS NULL)
  )
  [t0]
WHERE
  [t0].[DeletedOn] IS NULL -- << this isn't in the result set returned by [t0]

I have tried this with the 11/11/2011 nightly build and the problem exists.
This wasn't a problem with LS3.

Thanks,

Jim

Hi Jim,

Just a quick note to let you know I have looked into this and we are currently applying a fix for this. Its not likely to be in time for tonight's build but we should have it in for tomorrow. Will update you once this is committed for the nightlies.

The issue manifests where you have a query which will force a sub-query (such as a count over a projection from a joined query) and the primary entity has soft delete enabled.

Jeremy

Hi Jim,

This fix has now been committed and will be available in the next nightly build.

Jeremy