Hi,

I'm fetching an entity collection from a table using the Adapter Scenario, however I'd also like to get the count of related records, I could also fetch that collection but i'd imagine its a waste of memory. Is it possible to get the first entity collection, and use an aggregate to get the count of the related collection?

Rgds, Martin

I would suggest, creating a view in the database. And then use the Designer to map this view to a typed view, or to an Entity if you want to relate it to other entities.

Using Customers-Orders tables in Northind as an example the database view may look like this:

select Customers.ContactName, RelatedTable.OrdersCount from Customers Inner join ( select CustomerID, Count(OrderID) as OrdersCount from Orders Group By CustomerID ) RelatedTable On RelatedTable.CustomerID = Customers.CustomerID

Additionally: you can't fetch the 'count' of a related table as a field in the parent table. You could fetch that count ONCE of course, by using the GetDbCount feature of the DataAccessAdapter object.