My own problem

Question

My own problem 

 

- I have the table (course) and the another(training).

In course table- id no, coursecode, .....

In training table - idno,  name , nationality, ......

 

I want to retrieve the number(count) of coursecode which is in same id no and the nationality will be "American".

The number of coursecode should be less than 2. 

I want to implement this by LINQ statement.

 

If you want to help me, kindly help me. Thanks a lot :-)

 

Answer 1

The number of coursecode should be less than 2. This is the main part that I have problem. Not the retrieving part. I cannot check (less than). (<) is cannot use in joining tables.

Answer 2

var dealercontacts = from course in Course
                     join Tr in Training on course.IdNo equals Tr.IDNo
                     where tr.Nationality='American'
                     select count(*);
Hope This Might Help You

         

 

            

Answer 3

In Course Table

-Idno.

-Coursecode

and other information

 

In training table

-Idno.

-name

-Nationality

and other information 

 

Other infomation is not important to retrieve........ 

Answer 4

Kindly give a snapshot of table structure..

Answer 5

Can You please give your table structure in details?

Answer 6

select idno,count(idno) from trainningtable where nationality='american' group by idno