My own problem

C# Corner

My own problem

Asp.Net Hein

11y1k.NET

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 :-)

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Asp.Net Hein11y ago
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.

Bhushan Bhasme11y ago

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

Asp.Net Hein11y ago
In Course Table
-Idno.
-Coursecode
and other information

In training table
-Idno.
-name
-Nationality
and other information

Other infomation is not important to retrieve........
Sakthikumar Thanavel11y ago
select idno,count(idno) from trainningtable where nationality='american' group by idno
Upendra Pratap Shahi11y ago
Kindly give a snapshot of table structure..
Bhushan Bhasme11y ago
Can You please give your table structure in details?