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
0 Replies