Linq to SQL equivalent of this query

Question

This is the query that I'm trying to reproduce:

select
    act.AccountID,
    ast.AssetID,
    b.Amount
from
    Account act left outer join
    Balance b on act.AccountID = b.AccountID left outer join
    Asset ast on b.AssetID = ast.AssetID

I'm trying to get the results as the following:

Dictionary(of Account, Dictionary(of Asset, Double))

Left outer join in LINQ-to-SQL (c#): http://stackoverflow.com/q/584820/284240 — Tim Schmelter, Mar 05 '12 at 20:37

score 0 · Answer 1 · answered Mar 05 '12 at 21:39

0

From memory, the left joins are done with simple from statements in the LINQ 2 SQL syntax

Dim dc as new myDataContext
Dim result = from act in dc.Accounts
         from b in dc.Balance
         from ast in dc.Asset
         select act.AccountID, ast.AssetID, b.Amount

answered Mar 05 '12 at 21:39

LongArm

208
1
6

how does that include the join column AccountID? – Jeremy Cantrell Mar 05 '12 at 21:48

Linq to SQL equivalent of this query

1 Answers1