将 SQL 语句转换为 DataTable 上的 LINQ 查询

发布于 2024-10-16 04:26:45 字数 458 浏览 5 评论 0原文

我正在研究 Linq to DataTable、Lambda。因为很难想把sql改成linq，Lambda，没有做。

SQL代码下面是去除电话号码重复的会员列表。如果有帮助我会很感激。

SELECT A.no, B.name, B.userId, B.homeTel2    
FROM

    (  SELECT homeTel2, min(no) NO
       FROM  OF_Member
       GROUP BY homeTel2 
    ) A
    INNER JOIN OF_Member B
        ON A.NO = B.NO

工作进展 ============

var objectName =from t in mMemberTable.AsEnumerable()
按 t.Field("homeTel2") 对 t 进行分组

原文

I am studying that Linq to DataTable,Lambda.
Because is difficult want to change sql to linq,Lambda, is not doing.

Below the SQL code is member list that remove telephone number repetition.
I will thank if help.

SELECT A.no, B.name, B.userId, B.homeTel2    
FROM

    (  SELECT homeTel2, min(no) NO
       FROM  OF_Member
       GROUP BY homeTel2 
    ) A
    INNER JOIN OF_Member B
        ON A.NO = B.NO

Progressing work ============

var objectName =from t in mMemberTable.AsEnumerable()
group t by t.Field("homeTel2")

分享到QQ

分享到微博

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

发布评论

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

你与清晨阳光 2024-10-23 04:26:45

尝试此链接：

Linq to Entities 简单组查询

将 ms sql“group by”查询转换为 linq to sql

                var objectName =from t in mMemberTable.AsEnumerable()
                group t by t.Field<string>("homeTel2") into groups
                select groups;

希望如此帮助，

问候

Try this link:

Linq to Entities simple group query

converting ms sql “group by” query to linq to sql

                var objectName =from t in mMemberTable.AsEnumerable()
                group t by t.Field<string>("homeTel2") into groups
                select groups;

Hope this helps,

Regards

回复收藏 0 原文