public void Post([FromBody] Employee newEmployee)
{
using (myDBEntities = new MyDBEntities())
{
myDBEntities.Employees.Add(newEmployee);
}
}
public IEnumerable <Object> Get()
{
using (myDBEntities = new MyDBEntities()) {
var query = from dbEmployees in myDBEntities.Employees
select new { dbEmployees.EmpName, dbEmployees.Email };
var listOfEmployees = query.ToList();
return(listOfEmployees);
}
}
public Object Get(int id)
{
using (myDBEntities = new MyDBEntities())
{
var employeeObj = myDBEntities
.Employees.Where(employee => employee.EmpID == id)
.FirstOrDefault();
return(new
{
EmpName = employeeObj.EmpName,
Email = employeeObj.Email,
EmpId = employeeObj.EmpID
});
}
}