How to use ADO.Net Entity Data Model with two tables?

Question

I have two tables: Student (StuID, Name, Sex, MajorID, ...) and Major (MajorID, MajorName, ...). I would like to get result: StuID, Name, MajorName. How to retrieve this record using ADO.Net Entity Data Model?

For this, I've tried: (from s in Entity.Student join m in Entity.Major on s.MajorID=m.MajorID select s, m.MajorName).ToList(); — Leap Bun
– Leap Bun, Commented Feb 14, 2012 at 7:00

Pongsathon.keng · Accepted Answer · 2012-02-14 06:57:37Z

1

I think that you are asking for C# LINQ query, if you are not, please ignore my anwser.

var result = from s in Student 
             join m in Major on s.MajorID equal m.MajorID
             select new {s.StuID, s.Name, m.MajorName}

answered Feb 14, 2012 at 6:57

Pongsathon.keng

1,44511 silver badges15 bronze badges

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

Collectives™ on Stack Overflow

How to use ADO.Net Entity Data Model with two tables?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related