What are differences between Data Adapter and Data Reader in ADO.NET? Suppose you are hired by a reputed software company which is going to design an…

What are differences between Data Adapter and Data Reader in ADO.NET? Suppose you are hired by a reputed software company which is going to design an application for “Employee Management System”. Your responsibility is to design a schema named EMS and create a table named Employee (EmpNo, Name, Email, phone number, Company, Department, Joining Date, and Salary). Write a program to design a ASP.NET form to take input for this table and insert the data into table after clicking the Save button