Simple Linqpad Linq join statement, select all fields

Question

I'm trying to do a simple join query in Linqpad, to mimic the following ...

SELECT *     
FROM Companies C    
JOIN Addresses A    
ON A.CompanyID = C.CompanyID    
WHERE C.CompanyID = 123

I'm using C# Expression (so no need to Dump, AFAIK), and tried the following unsuccessfully ...

from C in Companies    
join A in Addresses on C.CompanyID equals A.CompanyID    
where C.CompanyID = 123    
select C,A

So the result is "name does not exist in current context"

I suspect it might be because of common field in both tables, or the C,A syntax is basically wrong.

I want to be able to do the splat "*" across both tables. Is this possible?

Answer 1

I believe your select should look like

select new { C, A }

or

select new { Company = C, Address = A }

as you are returning more than one complex object, so it should be wrapped with an anonymous type. Or you can define your type and then set the properties like so

select new MyType { Company = C, Address = A }