Ling problems

I have two tables: Countries and CountryDescription. Each country have 0 or many descriptions based on language code

Countries (Id, Code)

CountryDescriptions (Id, CountryId, LanguageCode, Description)

I want to select id, country code and a description in specific language if description for specified language exists

var results = 
from c in uow.Countries 
select new 
{
    c.id, 
    c.Code, 
    EnglishDescription = c.CountryDescriptions.where(cd => cd.LanguageCode == "en").Select(cd => cd.Description).FirstOrDefault()
};

I get the following error

The method 'Where' is not supported.

I don't know how can I construct linq query to get expected result. Some other ORMs I have tested haven't got any difficulties to generate this query.

Any help or info would be appreciated

This is working for me in our test environment. Could you try downloading the latest nightly build and seeing if the problem still occurs with that? Thanks!

Note, however, that even in current builds we are not able to perform the projection on the database -- instead we will download the country descriptions for each country and perform the projection on the client. You will therefore want to eager load the CountryDescriptions association to avoid a n+1 problem.