Tries to use an alias it hasn't created

Using the binaries in the installer for 3.1 and the nightly (7-15-2010), the following method creates sql that uses an alias that it hasn't made. In 3.0, it works correctly

by using the view's name.

public IQueryable<CurrentContinuousAnalysisRunOverview> GetCurrentContinuousAnalysisRunOverviews(DateTime date)

{ 

return from overview in UnitOfWork.Query<CurrentContinuousAnalysisRunOverview>().WithAggregate("HistoricalCA") 

		where overview.AnalysisCategory.AnalysisApplication.AnalysisApplicationGroupId == 		this.Id && (overview.AnalysisDate == (date.Date - TimeSpan.FromDays(1)) || 		overview.RequiresComment)		

		orderby overview.MaterialApplicationName, overview.TestShortName,  		overview.FieldName									

 

		select overview;

 

}

Creates SQL like : 

SELECT

  VW_I2MS_BODY_FIELD.Id,

  VW_I2MS_BODY_FIELD.body_table_id,

  VW_I2MS_BODY_FIELD.can_subcategorize_by,

  VW_I2MS_BODY_FIELD.cqaf_required,

  VW_I2MS_BODY_FIELD.datatype,

  VW_I2MS_BODY_FIELD.field_id,

  VW_I2MS_BODY_FIELD.is_result,

  VW_I2MS_BODY_FIELD.Length,

  VW_I2MS_BODY_FIELD.Nullable,

  VW_I2MS_BODY_FIELD.subcategory_suffix_format,

  VW_I2MS_BODY_FIELD.tested_date_body_field_id

FROM

  dbo.VW_I2MS_BODY_FIELD

WHERE

  EXISTS (

    SELECT

      t2.*

    FROM

      AnalysisConfig.ANALYSIS_APPLICATION t2

    INNER JOIN

      AnalysisData.ANALYSIS_CATEGORY t1

    ON

      t0.analysis_category_id = t1.Id

    INNER JOIN

      AnalysisData.ANALYSIS_CATEGORY t1

    ON

      t2.Id = t1.analysis_application_id

    WHERE

      t2.body_field_id = VW_I2MS_BODY_FIELD.Id AND

      EXISTS (

        SELECT

          t1.*

        FROM

          AnalysisData.ANALYSIS_CATEGORY t1

        WHERE

          t1.analysis_application_id = t2.Id AND

          EXISTS (

            SELECT

              t0.*

            FROM

              AnalysisData.VW_CONTINUOUS_ANALYSIS_RUN_OVERVIEW t0

            WHERE

              t0.analysis_category_id = t1.Id AND

              ((EXISTS (

                SELECT

                  t1.*

                FROM

                  AnalysisData.ANALYSIS_CATEGORY t1

                WHERE

                  t1.Id = t0.analysis_category_id AND

                  EXISTS (

                    SELECT

                      t2.*

                    FROM

                      AnalysisConfig.ANALYSIS_APPLICATION t2

                    WHERE

                      t2.Id = t1.analysis_application_id AND

                      t2.analysis_application_group_id = 1

                  )

              ) AND (t0.analysis_date = '7/13/2010 12:00:00 AM' OR t0.requires_comment = True)) AND t0.DeletedOn IS NULL)

          )

      )

);

 

Any ideas?

Hi Karen,

This sounds like a bug, are you able to send through (either by attaching a sample project without any binaries to this forum post, or emailing it through to the support address) a small repro sample of this behavior and we can have a look into what is causing this.

 

Thanks!

Jeremy