<p>We are ready to start a brand new project at work, no legacy code. We did use Subsonic in the past and we pretty happy with it. But that was before Linq.</p>

<p>Has anyone had to face this same issue (Linq x Subsonic)? </p>

<p>What was your decision? What were the reasons?</p>

<p>Any insight appreciated.</p>

The one thing I love about LINQ, which I don't think SubSonic handles as gracefully, is automatically dealing with joins.
```
```
FROM a in db.Orders
where a.Total > 100
SELECT new {a.Item.Desc, a.Customer.Name};
```
```
will automatically generate SQL like thisL
```
```
select i.DESC, c.NAME 
from  ORDERS o  
inner join ITEMS on o.ItemID = i.ItemID 
inner join CUSTOMERS c on o.CustomerID = c.CUSTOMERID 
where o.TOTAL > 100
```
```