Linq to SQL - 填充 IEnumerable 属性

发布于 2024-12-09 06:18:13 字数 494 浏览 1 评论 0原文

我试图从表（BidNames）中提取一些记录并将它们传递到视图模型中的视图。我的视图模型仅包含 BidName 记录的集合。

我的视图模型：

public class BidNamesVM
{
    public IEnumerable<BidName> BidNames { get; set; }
}

我在填充 BidNames 集合时遇到问题。从 bn 到 BidNames 的转换不起作用。

from bn in BidNames
where bn.CustomerID == 1160 && bn.Customer.Bids.Any(b=>b.Item.AuctionID == 2)
select new BidNamesVM
{
    BidNames = bn 
}

我需要做什么才能在查询中填充 BidNames？

非常感谢，

原文

I am trying to pull some records from a table (BidNames) and pass them to a view in a view model. My view model consists of nothing more than a collection of BidName records.

My view model:

public class BidNamesVM
{
    public IEnumerable<BidName> BidNames { get; set; }
}

I'm having problems populating the BidNames collection. The conversion from bn to BidNames isn't working.

from bn in BidNames
where bn.CustomerID == 1160 && bn.Customer.Bids.Any(b=>b.Item.AuctionID == 2)
select new BidNamesVM
{
    BidNames = bn 
}

What do I have to do to populate BidNames in my query?

Many thanks,

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

小鸟爱天空丶 2024-12-16 06:18:13

您的 LINQ 查询已返回 IEnumerable，其中 bn 表示 BidName 的单个实例。试试这个：

BidNamesVM bnVM = new BidNamesVM();
bnVM.BidNames = from bn in BidNames
                where bn.CustomerID == 1160 && bn.Customer.Bids.Any(b=>b.Item.AuctionID == 2)
                select bn;

在您的示例中，您尝试将 BidName 的实例设置为 IEnumerable 类型的属性，但由于明显的原因，该方法不起作用。

Your LINQ query already returns an IEnumerable<BidName>, with bn representing an individual instance of BidName. Try this:

BidNamesVM bnVM = new BidNamesVM();
bnVM.BidNames = from bn in BidNames
                where bn.CustomerID == 1160 && bn.Customer.Bids.Any(b=>b.Item.AuctionID == 2)
                select bn;

In your example, you were trying to set an instance of BidName to a property of type IEnumerable<BidName>, which won't work for obvious reasons.

回复收藏 0 原文

~没有更多了~