Programming language is C#.

Exercise 1: Create and manipulate SQL Server based data 1. Create a table in SQL Server to capture student information including: a. Student Roll Number (Auto Increment) b. Student Name (First, Last Name) c. Class Name d. Address e. Gender

2. After creating table insert 10 rows manually to populate the table. 3. Write SQL statements in Visual Studio to: a. Select all records in table b. Select all students where name start with A c. Select top 5 students (sorted by name in ascending order)