how to inner join DataTables using labda expression linq in C#?

Question

I had joined data tables using "Query Syntax", and it is working fine.Could any one help in converting it to lamba statement ?

 var oVarLoanDetails = (from data in ActiveReferralDetails.AsEnumerable()
    join reftypedata in ActionType.AsEnumerable()
    on data.Field<int>("atid") equals reftypedata.Field<int>("atid")
    join refsubtypedata in ActionSubType.AsEnumerable()
    on data.Field<int>("ASTID") equals refsubtypedata.Field<int>("ASTID")
    where reftypedata.Field<int>("atid") == refsubtypedata.Field<int>("atid")
     select new LoanDataInfo
             {
            LoanNumber = data.Field<string>("Loanno").ToLower(),
            ATID = reftypedata.Field<int>("atid"),
            RefType = reftypedata.Field<string>("ATSHORTDESC"),
            RefSubType = refsubtypedata.Field<string>("SUBTYPESHORTDESC")
             });
        //Class LoanDataInfo

        public class LoanDataInfo
            {
                public string LoanNumber { get; set; }
                public int ATID { get; set; }
                public string RefType { get; set; }
                public string RefSubType { get; set; }
            }

Why you want to do that? Using method syntax with joins is so ugly, i never remember what i have to pass, no wonder that you need to ask. You can always mix both syntaxes to avoid it. — Tim Schmelter, May 04 '17 at 07:43
yeah, even i agree that lamda joins are ugly. I just want to try writing lamda joins in data tables.... — Dinesh Ramaian, May 04 '17 at 08:36
http://stackoverflow.com/questions/5038288/lambda-expression-for-join check out this title maybe is be helpful for you — Mehmet Can Taş, May 04 '17 at 09:00

jegtugado · Answer 1 · 2017-05-04T08:53:32.277

EDIT:

Refer to Queryable.Join Method (IQueryable, IEnumerable, Expression>, Expression>, Expression>).

The lambda version of your query could be something like this.

Please note that for some properties I just assumed that it comes from ActiveReferralDetails.

var oVarLoanDetails = ActiveReferralDetails.AsEnumerable()
    .Join(ActionType.AsEnumerable(), 
    ard => arc.Field<int>("atid"), 
    at => at.Field<int>("atid"), 
    (ard, at) => new { ARD = ard, AT = at })
    .Join(ActionSubType.AsEnumerable(), 
    r => new { astid = r.ARD.Field<int>("ASTID"), 
    atid = r.ARD.Field<int>("atid") }, 
    ast => new { astid = ast.Field<int>("ASTID"), 
    atid = ast.Field<int>("atid") },
    (r, ast) => new { ARD = r.ARD, AT = r.AT, AST = ast})
    .Select(r => new LoanDataInfo() {
        LoanNumber = r.ARD.Field<string>("Loanno").ToLower(),
        ATID = r.ARD.Field<int>("atid"),
        RefType = r.ARD.Field<string>("ATSHORTDESC"),
        RefSubType = r.ARD.Field<string>("SUBTYPESHORTDESC")
    });

Lambda joins are ugly. I would not recommend using it.

I hope you had considered "ActiveReferralDetails" as a class, but its a datatable. — Dinesh Ramaian, May 04 '17 at 08:38

how to inner join DataTables using labda expression linq in C#?

1 Answers1