This project is read-only.

Denormalizing list with LookupMulti fields

Feb 20, 2008 at 7:57 PM
I have a SharePoint list with a few multi-choice lookup fields. With LINQ to SharePoint, I'd like to get a flat table that includes those lookup fields. For example, suppose my SharePoint list has the following fields:

  • Name
  • Title
  • ReportsTo (a lookup to the employee list)
  • ManagerOf (another lookup to the employee list)

A record might appear on the site as:

  • Bob Smith, IT Director, Joe Noonan, Mike Jones;Sarah Rose;Bill Dobbs

I'd like to have returned a flat recordset that contains the following:

  • Bob Smith, IT Director, Joe Noonan, Mike Jones
  • Bob Smith, IT Director, Joe Noonan, Sarah Rose
  • Bob Smith, IT Director, Joe Noonan, Bill Dobbs

Is this possible with LINQ to SharePoint?