Loading

Join two tables

Pramod M

Sid

above i Have two tables llike above based on SID get all records and compare with EAID and get Location in LINQ

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

7y ago

var data = (from inv in _context.table1

join req in _context.table2 on inv.sid equals req.sid

                    select new viewModel
                    {location = req.location }
                ).ToList();

0

My Question is to get Location name Based on table 1 SID and Table 2 SID Get EAID and EAID related Location Name need

No foreign keys on both the tables pls Help LINQ Query

0

Please update your question and provide desired output and explain that output also.

0