Retrieving Data from Multiple Tables with LINQ

Question

I'am beginner in linq and have three tables (sql ce 3.5) like this : course : (PK)CourseCode,CourseName Class : (PK)ClassCode,FieldCode,ClassName ClsCrs : (PK)ClassCode,(PK)CourseCode

I want to convert or rewrite this query to linq and assign results to a combobox data source :

`SELECT CourseName FROM class, clscrs, course WHERE
ClassTitel = @ClassTitel and class.classcode = clscrs.classcode and
clscrs.coursecode = course.coursecode`

how can i do this ?

thanks

Which LINQ provider are you using? LINQ to SQL? Entity Framework? NHibernate? Something else? — svick
– svick, Commented Jan 20, 2013 at 19:41

Jacco · Accepted Answer · 2013-01-20 20:33:10Z

1

you can try this

var query = (from c in db.class 
             from v in db.clscrs 
             from n in db.course 
             where c.ClassTitel=="yourinput" 
                 && c.classcode = v.classcode 
                 && v.coursecode = n.coursecode 
             select n.CourseName).ToList();

edited Jan 20, 2013 at 20:33

Jacco

3,2701 gold badge22 silver badges30 bronze badges

answered Jan 20, 2013 at 19:52

COLD TOLD

13.6k3 gold badges37 silver badges53 bronze badges

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

Comments

Sergey Berezovskiy · Accepted Answer · 2013-01-20 19:41:29Z

0

Its not clear which table ClassTitel field belongs (assume class table). Also replace set names with those generated by EF or Linq to SQL

var query = from cl in db.class
            join cc in db.clscrs on cl.classcode equals cc.classcode
            join cs in db.course on cc.coursecode equals cs.coursecode
            where cl.ClassTitel == "value"
            select cl.CourseName;

comboBox1.DataSource = query.ToList();

answered Jan 20, 2013 at 19:41

Sergey Berezovskiy

237k44 gold badges441 silver badges468 bronze badges

Collectives™ on Stack Overflow

Retrieving Data from Multiple Tables with LINQ

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related