Hello

I have a class

public class InvoiceClass { public guid id public string services }

My linq statement has a left join

My db tables are

Table Invoice Id Name

Table InvoiceLine Id Name Service

Now say there are 5 invoicelines for one invoice I need to populate the services string with the InvoiceLine service column value. This must be done in the sql query

For example the class values will be

Id = INV1002 Services = Prod1 , Prod2 , Prod3

Hope this make sense. Thanks in advance

This must be done in the sql query

For example the class values will be

Id = INV1002 Services = Prod1 , Prod2 , Prod3

I don't know how this can be done in plain SQL, could you please post the SQL code you want to produce?

You can only do this with a custom aggregate function in SQL or you can do it in-memory. I'd do it in memory as a linq to objects query over the linq query executed on the db.