First of all, we need to add a .dbml file as explained in previous post.
Query #1: Get all members and their details.
Query #2: Get First Name, Gender and Email Address of all members.
Query #3a: SORTING : Get Member's Details on basis of First Name in Ascending Order.
Query #3b: SORTING : Get Member's Details on basis of First Name in Descending Order.
Query #4: TOP : Get TOP 5 records of Members.
Query #5: SKIP : Skip TOP 1300 records and get remaining records.
Query #6: DISTINCT : Get Distinct Member Names.
Query #7a: FILTERING : Get Members whose Name starts with 'A'.
Query #7b: FILTERING : Get Members whose Name ends with 'Y'.
Query #7c: FILTERING : Get Members whose Name contains 'an'.
Query #8: Get members who are 'Accountant'.
Query #9: Get members whose First Name is 'Aaron'.
Query #10: Get members whose DOB is on or after 31st December 2010.