比较两个列表并返回公共条目

Question

我有一份供应商名单。我还有一个供应商ids列表。

    public List<SAP_Vendor> Vendors { get; set; }
    public List<string> SubcontractVendorIDs { get; set; }

我想返回其in在SubcontractVendorIDs列表中的供应商的List<SAP_Vendor>。

List<SAP_Vendor> SubcontractVendors = Vendors.Select(??).ToList();

或

List<SAP_Vendor> SubcontractVendors = Vendors.Where(??).ToList();

Answer 1

在Where()谓词中使用Contains()方法：

List<SAP_Vendor> SubcontractVendors = Vendors.Where(v=> SubcontractVendorIDs.Contains(v.VendorID)).ToList();

Answer 2

您可以执行inner join

var query = from vendor in Vendors
            join id in SubcontractVendorIDs on vendor.ID equals id
            select vendor;

List<SAP_Vendor> subcontractVendors = query.ToList();

Answer 3

List<SAP_Vendor> SubcontractVendors = Vendors.Where(v => SubcontractVendorIDs.Contains(v.Id)).ToList();