The member [class] has no supported translation to SQL?

I think this is what you're after (you need to reference the email address directly, through a known mapping), but I can't be 100% sure without knowing your structure: account = (from a in dc. Accounts join em in dc. Emails on a.

AccountId equals em. AccountId where em. EmailAddress == email select a).FirstOrDefault() The why?

Part: In short, LINQ has no mapping knowledge of what that property is...and can't make a SQL query because it doesn't know, so you'll get a runtime error when it tries to generate a query from the expression tree You can't use a property in a query unless LINQ knows what table/column/function it maps to, without this...it simply can't convert it to or from SQL.

I think this is what you're after (you need to reference the email address directly, through a known mapping), but I can't be 100% sure without knowing your structure: account = (from a in dc. Accounts join em in dc. Emails on a.

AccountId equals em. AccountId where em. EmailAddress == email select a).FirstOrDefault(); The why?

Part: In short, LINQ has no mapping knowledge of what that property is...and can't make a SQL query because it doesn't know, so you'll get a runtime error when it tries to generate a query from the expression tree. You can't use a property in a query unless LINQ knows what table/column/function it maps to, without this...it simply can't convert it to or from SQL.

Thanks Nick - that was it. – Code Sherpa May 23 '10 at 23:45.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.