when inner join in linq how can i select same column without using model class

Question

Actually ,I want to extract generic data from EF table without using models but unfortunately two columns with same name from different database crashed...

Here is the query

var query = (from jbct in entities.Table1.AsEnumerable()
                             join p in entities.Table2.AsEnumerable() on jbct.perid equals p.id
                             select new
                             {
                              jbct.id,
                              p.id        
                             }).ToList();

Frankly, I have no idea what you're asking. – Gert Arnold Sep 14 '18 at 07:13 — Gert Arnold, Sep 14 '18 at 07:13

score 1 · Answer 1 · answered Sep 14 '18 at 06:11

1

try use a dynamic name

        var query = (from jbct in entities.Table1.AsEnumerable()
                 join p in entities.Table2.AsEnumerable() on jbct.perid equals p.id
                 select new
                 {
                     Id1 = jbct.id,
                     Id2 = p.id

                 }).ToList();

answered Sep 14 '18 at 06:11

tdayi

142
5

okay thanks. I'll also try this. I am able to return dynamic json results in my API without creating specific Models.I used genric collection class . IEnumerable>. – Zuly Sep 14 '18 at 07:35
@Zuly you can create a dynamic object like this – tdayi Sep 14 '18 at 08:03

score 0 · Answer 2 · answered Sep 14 '18 at 04:33

0

Now I've found now my solution to usie dictionary class

Dictionary with object as value

var query = (from jbct in entities.Table1.AsEnumerable() join p in entities.Table2.AsEnumerable() on jbct.perid equals p.id select new Dictionary<String, Object>
                         {
                             {"jbct_id", jbct.id},
                             {"p_id", p.id}}
).ToList();

Thanks

answered Sep 14 '18 at 04:33

Zuly

37
7

1

Still no idea what you're up to. I do know that because of the `AsEnumerable()` calls this is horribly inefficient code. – Gert Arnold Sep 14 '18 at 07:15
Should I use " IQueryable>" .. instead of AsEnumerable().. – Zuly Sep 14 '18 at 07:36

when inner join in linq how can i select same column without using model class

Here is the query

2 Answers2

Dictionary with object as value