code_junkie

What would you choose for your data layer today, Linq or Subsonic?

Nov 12th, 2011
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.24 KB | None | 0 0
  1. FROM a in db.Orders
  2. where a.Total > 100
  3. SELECT new {a.Item.Desc, a.Customer.Name};
  4.  
  5. select i.DESC, c.NAME
  6. from ORDERS o
  7. inner join ITEMS on o.ItemID = i.ItemID
  8. inner join CUSTOMERS c on o.CustomerID = c.CUSTOMERID
  9. where o.TOTAL > 100
Add Comment
Please, Sign In to add comment