Populate Children Command Builder

[Grauenwolf]

Here is how we currently populate child records:

var children = m_DataSource.GetByKeyList(ProductTable, "ProductLineKey",
                results.Select(pl => pl.ProductLineKey)).ToCollection<Product>().Execute();

It would be nice if we could write this:

m_DataSource.LoadChildern(productLines, p => p.Products).Execute();

• productLines is the parent collection
• p => p.Products is the pointer to the child collection
• This would use GetByKeyList to find the records.
• The primary key on parent table will determine the mappings
• Optionally, a primary/foreign key pair may be specified.
• It will have to dynamically determine the TKey type parameter. This means some fancy reflection work.