Linq to Sql - 动态列选择

我正在研究Linq-to-Sql，试图获取传递动态obj参数的列名（每次都会更改）。我需要选择定义动态obj数组的列名。

PS：我需要一次选择SKU，供应商名称，供应商样式代码

"where"子句条件工作正常，但我需要选择在 data.col 索引中定义的特定列

我尝试了下面的代码，但没有帮助我：

public HttpResponseMessage PostGenerateFile([FromBody] dynamic data) {
string[] vendorname = data.vendorname != null ?data.vendorname.ToObject<string[]>() : null;
string[] brandname = data.brandname != null ? data.brandname.ToObject<string[]>() : null;
using (var context = new Vendor_InvDataContext())
        { var query = context.AllInventories.AsQueryable();

            for (int i = 0; i < data.col.Count; i++)
            {
                if(data.col[i]=="SKU")
                   query.Select(s => s.SKU);
                if (data.col[i] == "VENDORNAME")
                    query.Select(s => s.VENDORNAME);
                if (data.col[i] == "VENDORSTYLECODE")
                    query.Select(s => s.VENDORSTYLECODE);
                if (data.col[i] == "STYLECODE")
                    query.Select(s => s.STYLECODE);
                if (data.col[i] == "STYLENAME")
                    query.Select(s => s.STYLENAME);
            }
 if (vendorname != null && vendorname.Length > 0)
            {
                query = query.Where(s => vendorname.Contains(s.VENDORNAME));
            }
            if (brandname != null && brandname.Length > 0)
            {
                query = query.Where(s => brandname.Contains(s.BRANDNAME));
            }
var items = query.ToList();