w3resource

C# Sharp LINQ : Exercises, Practice, Solution

C# Sharp LINQ [30 exercises with solution]

[An editor is available at the bottom of the page to write and execute the scripts.  Go to the editor]

1. Write a program in C# Sharp to show how the three parts of a query operation execute.
Expected Output:
The numbers which produce the remainder 0 after divided by 2 are :
0 2 4 6 8
Click me to see the solution

2. Write a program in C# Sharp to find the +ve numbers from a list of numbers using two where conditions in LINQ Query.
Expected Output:
The numbers within the range of 1 to 11 are :
1 3 6 9 10
Click me to see the solution

3. Write a program in C# Sharp to find the number of an array and the square of each number.
Expected Output :
{ Number = 9, SqrNo = 81 }
{ Number = 8, SqrNo = 64 }
{ Number = 6, SqrNo = 36 }
{ Number = 5, SqrNo = 25 }
Click me to see the solution

4. Write a program in C# Sharp to display the number and frequency of a given number from an array.
Expected Output :
The number and the Frequency are :
Number 5 appears 3 times
Number 9 appears 2 times
Number 1 appears 1 times
. . . .
Click me to see the solution

5. Write a program in C# Sharp to display the characters and frequency of each character in a given string.
Test Data:
Input the string: apple
Expected Output:
The frequency of the characters are :
Character a: 1 times
Character p: 2 times
Character l: 1 times
Character e: 1 times
Click me to see the solution

6. Write a program in C# Sharp to display the name of the days of the week.
Expected Output:
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Click me to see the solution

7. Write a program in C# Sharp to display numbers, multiplication of numbers with frequency and the frequency of a number in an array.
Test Data :
The numbers in the array are :
5, 1, 9, 2, 3, 7, 4, 5, 6, 8, 7, 6, 3, 4, 5, 2
Expected Output :
Number Number*Frequency Frequency
------------------------------------------------
5 15 3
1 1 1
9 9 1
2 4 2
. . . . . . . .
Click me to see the solution

8. Write a program in C# Sharp to find a string that starts and ends with a specific character.
Test Data :
The cities are : 'ROME','LONDON','NAIROBI','CALIFORNIA','ZURICH','NEW DELHI','AMSTERDAM','ABU DHABI','PARIS'
Input starting character for the string : A
Input ending character for the string : M
Expected Output :
The city starting with A and ending with M is : AMSTERDAM
Click me to see the solution

9. Write a program in C# Sharp to create a list of numbers and display numbers greater than 80.
Test Data :
The members of the list are :
55 200 740 76 230 482 95
Expected Output :
The numbers greater than 80 are :
200
740
230
482
95
Click me to see the solution

10. Write a program in C# Sharp to accept list members through the keyboard and display them more than a specific value.
Test Data :
Input the number of members on the List : 5
Member 0 : 10
Member 1 : 48
Member 2 : 52
Member 3 : 94
Member 4 : 63
Input the value above you want to display the members of the List : 59
Expected Output :
The numbers greater than 59 are :
94
63
Click me to see the solution

11. Write a program in C# Sharp to display the top n-th records.
Test Data :
The members of the list are :
5
7
13
24
6
9
8
7
How many records you want to display ? : 3
Expected Output :
The top 3 records from the list are :
24
13
9
Click me to see the solution

12. Write a program in C# Sharp to find uppercase words in a string.
Test Data :
Input the string : this IS a STRING
Expected Output :
The UPPER CASE words are :
IS
STRING
Click me to see the solution

13. Write a program in C# Sharp to convert a string array to a string.
Test Data :
Input number of strings to store in the array :3
Input 3 strings for the array :
Element[0] : cat
Element[1] : dog
Element[2] : rat
Expected Output:
Here is the string below created with elements of the above array :
cat, dog, rat
Click me to see the solution

14. Write a program in C# Sharp to find the n-th maximum grade point achieved by the students from the list of students.
Test Data :
Which maximum grade point(1st, 2nd, 3rd, ...) you want to find : 3
Expected Output:
Id : 7, Name : David, achieved Grade Point : 750
Id : 10, Name : Jenny, achieved Grade Point : 750
Click me to see the solution

15. Write a program in C# Sharp to count file extensions and group it using LINQ.
Test Data :
The files are : aaa.frx, bbb.TXT, xyz.dbf,abc.pdf
aaaa.PDF,xyz.frt, abc.xml, ccc.txt, zzz.txt
Expected Output :
Here is the group of extension of the files :
1 File(s) with .frx Extension
3 File(s) with .txt Extension
1 File(s) with .dbf Extension
2 File(s) with .pdf Extension
1 File(s) with .frt Extension
1 File(s) with .xml Extension
Click me to see the solution

16. Write a program in C# Sharp to calculate size of file using LINQ.
Expected Output :
The Average file size is 3.4 MB
Click me to see the solution

17. Write a program in C# Sharp to remove items from list using remove function by passing the object.
Test Data :
Here is the list of items :
Char: m
Char: n
Char: o
Char: p
Char: q
Expected Output:
Here is the list after removing the item 'o' from the list :
Char: m
Char: n
Char: p
Char: q
Click me to see the solution

18. Write a program in C# Sharp to remove items from list by creating an object internally by filtering.
Test Data :
Here is the list of items :
Char: m
Char: n
Char: o
Char: p
Char: q
Expected Output :
Here is the list after removing the item 'p' from the list :
Char: m
Char: n
Char: o
Char: q
Click me to see the solution

19. Write a program in C# Sharp to remove items from list by passing filters.
Test Data :
Here is the list of items :
Char: m
Char: n
Char: o
Char: p
Char: q
Expected Output :
Here is the list after removing item 'q' from the list :
Char: m
Char: n
Char: o
Char: p
Click me to see the solution

20. Write a program in C# Sharp to remove items from list by passing the item index.
Test Data :
Here is the list of items :
Char: m
Char: n
Char: o
Char: p
Char: q
Expected Output:
Here is the list after removing item index 3 from the list :
Char: m
Char: n
Char: o
Char: q
Click me to see the solution

21. Write a program in C# Sharp to remove a range of items from a list by passing the start index and number of elements to remove.
Test Data :
Here is the list of items :
Char: m
Char: n
Char: o
Char: p
Char: q
Expected Output:
Here is the list after removing the three items starting from the item index 1 from the list :
Char: m
Char: q
Click me to see the solution

22. Write a program in C# Sharp to find the strings for a specific minimum length.
Test Data :
Input number of strings to store in the array :4
Input 4 strings for the array:
Element[0] : this
Element[1] : is
Element[2] : a
Element[3] : string
Input the minimum length of the item you want to find : 5
Expected Output:
The items of minimum 5 characters are :
Item: string
Click me to see the solution

23. Write a program in C# Sharp to generate a cartesian product of two sets.
Expected Output :
The cartesian product are :
{ letterList = X, numberList = 1 }
{ letterList = X, numberList = 2 }
{ letterList = X, numberList = 3 }
{ letterList = X, numberList = 4 }
. . .
Click me to see the solution

24. Write a program in C# Sharp to generate a cartesian product of three sets.
Expected Output :
The cartesian product are :
{ letter = X, number = 1, colour = Green }
{ letter = X, number = 1, colour = Orange }
{ letter = X, number = 2, colour = Green }
{ letter = X, number = 2, colour = Orange }
{ letter = X, number = 3, colour = Green }
{ letter = X, number = 3, colour = Orange }
{ letter = Y, number = 1, colour = Green }
{ letter = Y, number = 1, colour = Orange }
. . .
Click me to see the solution

25. Write a program in C# Sharp to generate an Inner Join between two data sets.
Expected Output :

Item ID         Item Name       Purchase Quantity                                                             
-------------------------------------------------------                                                       
1               Biscuit                 458                                                                   
2               Chocolate               650                                                                   
3               Butter                  800                                                                   
3               Butter                  900                                                                   
3               Butter                  900                                                                   
4               Brade                   700                                                                   
4               Brade                   650

Click me to see the solution

26. Write a program in C# Sharp to generate a Left Join between two data sets.
Expected Output :

Here is the list after joining  :                                                                             
                                                                                                              
Item ID         Item Name       Purchase Quantity                                                             
-------------------------------------------------------                                                       
1               Biscuit                 458                                                                   
2               Chocolate               650                                                                   
3               Butter                  800                                                                   
3               Butter                  900                                                                   
3               Butter                  900                                                                   
4               Brade                   700                                                                   
4               Brade                   650                                                                   
5               Honey                   0   

Click me to see the solution

27. Write a program in C# Sharp to generate a Right Outer Join between two data sets.
Expected Output :

Here is the list after joining  :                                                                             
                                                                                                              
Item ID         Item Name       Purchase Quantity                                                             
-------------------------------------------------------                                                       
3               Butter                  800                                                                   
5               Honey                   650                                                                   
3               Butter                  900                                                                   
4               Brade                   700                                                                   
3               Butter                  900                                                                   
4               Brade                   650                                                                   
1               Biscuit                 458   

Click me to see the solution

28. Write a program in C# Sharp to display the list of items in the array according to the length of the string then by name in ascending order.
Expected Output :
Here is the arranged list :
ROME
PARIS
LONDON
ZURICH
NAIROBI
ABU DHABI
AMSTERDAM
NEW DELHI
CALIFORNIA
Click me to see the solution

29. Write a program in C# Sharp to split a collection of strings into some groups.
Expected Output :
Here is the group of cities :

ROME; LONDON; NAIROBI
-- here is a group of cities --

CALIFORNIA; ZURICH; NEW DELHI
-- here is a group of cities --

AMSTERDAM; ABU DHABI; PARIS
-- here is a group of cities --

NEW YORK
-- here is a group of cities --
Click me to see the solution

30. Write a program in C# Sharp to arrange the distinct elements in the list in ascending order.
Expected Output :
Biscuit
Brade
Butter
Honey
Click me to see the solution

C# Sharp Code Editor:

More to Come !

Do not submit any solution of the above exercises at here, if you want to contribute go to the appropriate exercise page.



Follow us on Facebook and Twitter for latest update.




We are closing our Disqus commenting system for some maintenanace issues. You may write to us at reach[at]yahoo[dot]com or visit us at Facebook