C# Linq Join Into statement editor error

Question

var joinedTables =  from tableRow in filteredTable.AsEnumerable()
                    join contactsRow in contacts.AsEnumerable()
                    on tableRow.Field<double>("Opportunity: Store Number") equals contactsRow.Field<double>("National Store .")
                    into lj
                    from r in lj.DefaultIfEmpty()
                    select resultTable.LoadDataRow(new object[]
                    {
                        tableRow.Field<double>("Opportunity: Store Number"),
                        tableRow.Field<DateTime>("Target Circuit Completion (FOC)"),
                        tableRow.Field<string>("Vendor Name"),
                        contactsRow.Field<string>("Contacts - ACM - Email")
                    }, false);

I am trying to do a left-outer-join on two tables using LinQ using this answer. However when I try to add fields from contactsRow into the object array argument of the .LoadDataRow() function, the editor says 'contactsRow' does not exist in the current context. How is my code different from the answer in my link? I have been really trying to learn LineQ to avoid crazy-nested loops but this has me stumped. More code here.

EDIT:

var joinedTables =  from tableRow in filteredTable.AsEnumerable()
                            join contactsRow in contacts.AsEnumerable()
                            on tableRow.Field<double>("Opportunity: Store Number") equals contactsRow.Field<double>("National Store .")
                            into lj
                            from r in lj.DefaultIfEmpty()
                            select resultTable.LoadDataRow(new object[]
                            {
                                tableRow.Field<double>("Opportunity: Store Number"),
                                tableRow.Field<DateTime>("Target Circuit Completion (FOC)"),
                                tableRow.Field<string>("Vendor Name"),
                                r.Field<string>("Contacts - ACM - Email"),
                                r.Field<string>("OO - Ops Mgr Name"),
                                r.Field<string>("Contacts - Area Sup / BC - Email"),
                                r.Field<string>("Contacts - OTP - Email"),
                                r.Field<string>("OTM Email Address")
                            }, false);
        return resultTable;

I changed the code from resultTable to r in my select statement as suggested. The code compiles now but resultTable is empty.

The code in that answer wouldn't work either, I believe. Basically you want r.Field instead of contactsRow.Field, as far as I can tell. — Jon Skeet
– Jon Skeet, Commented Jul 21, 2015 at 20:38

EJC · Accepted Answer · 2015-07-21 20:41:38Z

1

You need to select from r not from contactsRow.

answered Jul 21, 2015 at 20:41

EJC

2,1715 gold badges22 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

C# Linq Join Into statement editor error

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related