SQLCE4 does not build class table inheritance query correctly

Hi,

I have two tables, Donation and RecurringDonation, where RecurringDonation is a class table that inherits from Donation using the IsRecurring discriminator.

        using ( var unitOfWork = CreateUnitOfWork() )
        {
            var donation = unitOfWork.FindById<Data.RecurringDonation>(1);
            Assert.That(donation, Is.Not.Null);
            Assert.That(donation, Is.InstanceOf<Data.RecurringDonation>());
        }

Generates the following SQL under the SQLCE4 provider

SELECT
    Donation.Id AS [Donation.Id],
    Donation.Amount AS [Donation.Amount],
    Donation.CreatedOn AS [Donation.CreatedOn],
    Donation.CustomerId AS [Donation.CustomerId],
    Donation.IsRecurring AS [Donation.IsRecurring],
    Donation.PaymentResultId AS [Donation.PaymentResultId],
    Donation.Source AS [Donation.Source],
    Donation.Type AS [Donation.Type],
    RecurringDonation.DayOfMonth AS [RecurringDonation.DayOfMonth],
    RecurringDonation.IsCreditCard AS [RecurringDonation.IsCreditCard]
FROM
    Donation
WHERE
    Donation.Id = 1

Hi Andy,

Thanks for reporting this - quite a find indeed! :) Have tracked this down and added in a fix for tonights nightly build.

Jeremy