System.Generic.IEnumerable 集合的 ASP.Net LINQ to SQL 语法分组

Question

.Net 应用程序调用存储过程并返回存储为“结果”的集合。我希望能够按“CreatorLineOfBusinessID”对结果进行分组。它返回该字段以及其他几个字段。我想对“结果”数据集使用 LINQ 查询。提前致谢。

Dim result As IEnumerable(Of eRefer_Reports.uspReport_ReferralsSentBetweenLinesOfBusinessResult)

             strFromLOBID = " "
            Session("FromLineOfBusiness") = strFromLOBID
            strToLOBID = " "
            Session("ToLineOfBusiness") = strToLOBID

            result = repository.GetQueryResults(CDate(Me.txtStartDate.Text), CDate(Me.txtEndDate.Text), strFromLOBID, strToLOBID)
            BindGridView(result)          

Answer 1

您对 Linq 分组进行过研究吗？请尝试此处的 101 个示例：http://msdn.microsoft.com/en-us/vstudio /bb688088

Dim orderGroups = From p In results Group p By Key = p.CreatorLineOfBusinessID Into Group _
Select CreatorBusinessId = Key, Referrals = Group

然后只需使用 Key 和属性 Referrals 迭代 orderGroups 即可IEnumerable

For Each lobBusiness in orderGroups

 ' Get the lobBusinessId : .CreatorBusinessId
 ' Get the IEnumerable results: .Referrals

Next

Answer 2

Dim query = result.GroupBy(Function(x) x.ID).ToList()

应该按照您想要的方式对结果进行分组。