C# - Get A Result In A Grouping Query Which Is Value Agnostic And Has Dynamic Columns?

I have a table called Foo and I have two columns: Lorem and Ipsum, so the scheme of the table is:

Foo(Lorem, IpsumID)

I also have a table called IpsumTypes, which looks like this:

IpsumTypes(IpsumID, IpsumName)

I would like to write a LINQ query which will have the following result:

Headers: Lorem, IpsumName1, IpsumName2, ..., IpsumNamen
Values: Loremi, count(IpsumName1), ..., count(IpsumNamen)

Each row represents a group of Lorem value and the number of each possible IpsumID in the group. New rows can be added to the IpsumTypes table, rows can be deleted too, so I need dynamically generated columns, because at the time of writing the code I'm not aware of the possible values of Ipsum. How can I achieve this? Is there a magical Linq query which solves this problem, or should I get the values from the database and parse them separately, if speed counts?