Need Help to understand this error when I use join in LINQ

See more:

.NET3.0

.NET3.5

.NET

LINQ

.NET4

I am trying to join between 2 queries using LINQ, I am using the following code:

accounts = from a in accounts<br />           join ab in accountBalance<br />           on a.ACCOUNT_ID equals ab.ACCOUNT_ID<br />           where ab.CURRENCY_ID == currencyID<br />           select a;

given that accounts and accountBalance are both output of LINQ queries.

When compiling this piece of code I get the following error:

Cannot implicitly convert type 'System.Collections.Generic.IEnumerable<AnonymousType#1>' to 'System.Data.EnumerableRowCollection<AnonymousType#1>

I don't understand the reason behind this error since the query seems right.