我知道我可以像这样更改查询
Dim myList As List(Of Tickets) = (From a In db.myTable
Where a.ID = id AndAlso a.IsOnline = True).ToList
到λ
Dim myList as List(of Tickets) = db.Where(Function(x) x.ID = id ANDAlso a.IsOnline = true).ToList
如何编写 lambda 版本并告诉它创建一个包含结果的新对象?? 像这样:
Dim myList As List(Of Tickets) = (From a In db.myTable
Where a.ID = id AndAlso a.IsOnline = True
Select New TicketType With {
.Id = a.rsID.ToString,
.Title = a.rsTitle}).ToList
您正在寻找Select()
方法:
.Select(Function(x) New TicketType With { ... })