Open

how to do a simple subquery in LINQ?

Anyone know how I can do a very simple/basic subquery in LINQ like so:

SELECT a.VendorID,a.Name,
  (SELECT count(Agency_Code) from Contracts b where b.Vendor_Code = a.VendorID)

FROM Vendors a

just trying to get a count of the number of contracts each vendor has