Could not format node 'Link' for execution as SQL

Table1 with
Name, 
Address
CityID(foreign key from Table2) 

and Table2 with

CityID,
CityName.

I am using LINQ to SQL to retrieve data. When I try to oderby CityName I get the following error: base {System.SystemException} = {"Could not format node 'Link' for execution as SQL."}

Here's my LINQ code to retrieve data :

var Person = from person in db.Ta开发者_JS百科ble1 
                orderby person.Table2.CityName
                select person;

Can someone point me why its causing the above mentioned error.

Thanks!

---

Based on this bug report and my own testing (I was able to reproduce this), it looks like your Table2.CityName property may have Delay Loaded = True in the dbml designer.

Apparently you can't order by a delay-loaded property, so changing Delay Loaded to False on your Table2.CityName property in the DBML designer should take care of it.