Hi

In a situation where a [User] can have multiple [Accounts]

Apart from fetching all the entities by User.Accounts is there a method for fetching only an arraylist of [Account].[Id] for a particular user without actually fetching the collection?

I looked into projections but can't find a suitable example.

You can use DynamicLists. Something like this:

var fields = new EntityFields2(1);
fields.DefineField(AccountFields.Id, 0);

var results = new DataTable();
using (var adapter = new DataAccessAdapter())
{
    adapter.FetchTypedList(fields, results, null);
}

... or the Linq2LLBL version:

var metaData = new LinqMetaData(adapter);
var q = from a in metaData.Account
            select a.Id;