Returning multiple rows

Question

Hi, i have a linq statement where i return a new object like 

new CustomObject {
id = table.id
name = table6.name
files = table2.files
}

where I have defined CustomObject as a .cs class.

Now this works well for when the query returns only one id and one name. 

But what if for that one object I wanted files to be an array or list of files? So that the linq query would populate files with all files returned from the query (it performs a join) and not just one!

Answer 1

Please show the LINQ statement also.

---

"Premature optimization is the root of all evil." - Knuth

If I provoked thought, please click the green arrow

If I provoked Aha! please click Propose as Answer

We are here to learn, to share knowledge, and to earn points; all in about equal measure.

Answer 2

Hi aspbegineer;

Please post your query so that we will be able to give a solution that fits your needs or how to modify your query to give the results you need.

  

---

Fernando (MCSD)

If a post answers your question, please click "Mark As Answer" on that post and "Mark as Helpful".