return parent child data through sql

Question

Hi,

I am in a situation where I want to return a list of article objects. The properties of Article object looks as follows.

private int _articleId;

private string _articleName;

private List<Tag> _tags;

Now as you can see the article object has a property called _tags which is a list of type "Tag". Now assuming that I want to return a list of Article objects, how can i populate this list of type Tags when I am returning the list of Article objects.

I am looking to display the result as follows:

ArticleName 

Tag1 Tag2 Tag3

Answer 1

Get the list of Articles.

Then use a SQL query to get the list of Tags (assuming the resulting data has some sort of identifier as to what article it applies to.

Loop over these tags and build the lists for the correct Articles accordingly.

Answer 2

This is the sort of thing I would employ Hibernate or NHibernate for.

This answer actually provides a great leg up.