Anyone know how to do this very basic subquery in LINQ?
(just trying to get the number of active contracts per vendor)
SELECT a.VendorID,a.Name, (SELECT count(Agency_Code) from Contracts b where b.Vendor_Code = a.VendorID) FROM Vendors a
yields:
10001 Becker Inc 4
10002 Carlisle Inc 0
etc