VB Linq转到C#Linq

发布时间：2020-12-17 07:13:20 所属栏目：百科来源：网络整理

导读：请帮我转换为C#等价物 Dim dtData As DataTable = Session("Data")Dim aFilters = From oRow In dtData _Where oRow(i_oColumn.BaseColumnName) IsNot DBNull.Value _Select sFilter = _oRow.Field(Of String)(i_oColumn.BaseColumnName).Replace("""",""""

请帮我转换为C#等价物

Dim dtData As DataTable = Session("Data")

Dim aFilters = From oRow In dtData _
Where oRow(i_oColumn.BaseColumnName) IsNot DBNull.Value _
Select sFilter = _
oRow.Field(Of String)(i_oColumn.BaseColumnName).Replace("""","""") _
Distinct Order By sFilter

解决方法

未经测试,但直接翻译(有些整理)：

DataTable data = (DataTable)Session["Data"];

var filters= (from row in data.AsEnumerable()
              where !(row[i_oColumn.BaseColumnName] is DBNull)
              let result = (row.Field<string>(i_oColumn.BaseColumnName))
                                               .Replace(@"""",@"""")
              orderby result
              select result).Distinct();

但是,我怀疑：

where !row.IsNull(i_oColumn.BaseColumnName)

woulc更清楚

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!