Invalid column name

Hi,

I have a case where when I try to execute a linq query with an special order by, I have this error: "Invalid column name".

To reproduce this error, you must have two tables with one linked with a relation "one to one" to the other in the model.

The query is on the table without reference key and the order by is on the other.

Here is the script of my sample database:

CREATE TABLE [Invoice](
    [Id] [int] NOT NULL,
    [Number] [varchar](50) NOT NULL,
 CONSTRAINT [PK_Order] PRIMARY KEY CLUSTERED 
(
    [Id] ASC
)

CREATE TABLE [InvoiceOption](
    [Id] [int] NOT NULL,
    [Name] [varchar](50) NOT NULL,
    [Value] [varchar](50) NULL,
    [InvoiceId] [int] NOT NULL,
 CONSTRAINT [PK_ActionType] PRIMARY KEY CLUSTERED 
(
    [Id] ASC
)

ALTER TABLE [InvoiceOption]  WITH CHECK ADD  CONSTRAINT [FK_Option_Order] FOREIGN KEY([InvoiceId])
REFERENCES [Invoice] ([Id])

In my case, this is possible to have an invoice without invoiceoption. This is why my query looks like that:

List<Invoice> orders = unitOfWork.Invoices.OrderBy(x => (x.InvoiceOption != null ? x.InvoiceOption.Name : string.Empty)).ToList();

Why I have the 'Invalid column name' when I try to execute this query and how if it possible can I correct this problem?

Thank you very much.

P.S. I've attached a sample project to reproduce this problem.

Thanks for reporting this and for the concise repro. We are currently tracking this one down so we will post an update once we have made some progress on a fix for this.

Jeremy

Hi,

How will I know when a fix will be available for this bug.

I don't found any feature on your web site for display all my post and the list of change published each week don't have enough detail to be sure that this will correct my bug.

Have you any idea how I can track all these things?

Thank you.

We will post an update on this thread once we have made progress on this issue. We have a reasonable understanding of the issue at this point which is the lack of the core querying engine translating the one-to-one association (when referenced from the non FK side) into a sub-select in this specific case but unfortunately this is going to be fairly involved to fix so it may be a while yet before we are able to resolve this.

Jeremy

Has there been an update to this issue? I am experiencing the same thing.

-Keith

Hi Keith,

No, this issue is still outstanding. No ETA still at this stage unfortunately.

Jeremy

Just a quick update to report that we have now address this as part of 5.0 and this should now be resolved in the beta builds. Let us know if you continue to see any problems here.

Jeremy

Thank you Jeremy.

I'm not able to try right now with a beta version but immediatly when you will have a RC, I will surely try it.

Thank you again for the email notification about this correction, it's greatly appreciated.