C# - Entity Framework - Join method

Question

I have a table called "PublicUserOfferingSignUp" which contains the following columns.

Id
PublicUserId - foreign key to PublicUser.Id
OfferingId
Created

My application is using Entity Framework, but I am getting stuck with how to join from the PublicUserOfferingSignUp table to the PublicUser table.

I want to obtain a list of PublicUserOfferingSignUp records but ordered by the Name column of the PublicUser table.

Currently I have this ....

return DataBase.PublicUserOfferingSignUps.Join(PublicUser,

But I can't seem to work it out, any ideas ....

Steven

Can anybody help.

possible duplicate of entity framework join

user57508
– user57508

2012-05-09 11:42:52 +00:00
Commented May 9, 2012 at 11:42 — user57508
– user57508, Commented May 9, 2012 at 11:42

Raphaël Althaus · Accepted Answer · 2012-05-09 11:59:37Z

4

Something like that

DataBase.PublicUserOfferingSignUps.Join(Database.PublicUsers, 
    puosu => puosu.PublicUserId,//PublicUserOfferingSignUps key
    pu => pu.Id,//PublicUser key
    (puosu, pu) => new {
        publicUsersOfferingSignUp = puosu,//we take all data from PubliUserOfferingSignUps
        puName = pu.Name//and Name from PublicUser
        })
.OrderBy(x => x.puName)//we order by PublicUser Name
.Select(x => x.publicUsersOfferingSignUp );//we take only the PublicOfferingSignUps

Edit : as @M.Schenkel noticed, it would be easier to have a

public virtual PublicUser PublicUser {get;set;}

in your PublicUserOfferingSignUp model

then the query would be

DataBase.PublicUserOfferingSignUps
.OrderBy(puosu => puosu.PublicUser.Name);

easier, no ?

edited May 9, 2012 at 11:59

answered May 9, 2012 at 11:46

Raphaël Althaus

60.6k6 gold badges106 silver badges127 bronze badges

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

2 Comments

swade1987 Over a year ago

so what does this return? I want to return a list of PublicUserOfferingSignUp records

Raphaël Althaus Over a year ago

Yes, your question was rather clear... try it and if I missed something, I'll be glad to correct ;)

M.Schenkel · Accepted Answer · 2012-05-09 11:46:12Z

0

When you use the Entity Framework, the public user should be a property of your PublicUserOfferingSignUp-entity. If not, you can write a LINQ query to join them. For example:

var result = from pu in context.PublicUserOfferingSignUp
join u in context.PublicUser on u.id equals pu.PublicUserId 
select pu;

(this code is untested, but should give you the idea).

answered May 9, 2012 at 11:46

M.Schenkel

4771 gold badge3 silver badges9 bronze badges

Collectives™ on Stack Overflow

C# - Entity Framework - Join method

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related