Creating a table with custom field columns

Question

Hi All.I have a question about how to best pull data for a report.  I have a main table work_orders that has a related table called custom_fields.  it is a 0 to many relationship.  I am having a real problem trying to figure out the best way to display data in a report efficiently.  What I want to do is display the work_order data and also all the custom_fields as a single row.  I have attempted to use linq and I cant seem to figure out the best way to efficiently do this.  I am relatively new to SQL Server and was wondering if anyone had an idea to efficiently do this.

Thanks in advance.

Jim