Why we cannot create new instance of the class and send it as a result in entity framework ?

See more:

MVC

entity-framework

Hi All ,

What i am trying is that , i have my model folder inside class library.

in that i have created a Employee class and calling the method retrurn inside this frommy controller ..

My question is that .

public Employee GetEmployeeDetailsById(int Id)
        {
            EmployeeContext _db = new EmployeeContext();
           
            //var emp = (from em in _db.Employees.Where(e => e.EmployeeId == Id)
            //           select new Employee { 
            //               EmployeeId=em.EmployeeId,
            //               FirstName=em.FirstName,
            //               LastName=em.LastName,
            //               Title=em.Title
            //           }).SingleOrDefault();
            return emp;
        }

when i try to return like this i get an error ..

however if i do like below

public Employee GetEmployeeDetailsById(int Id)
        {
            EmployeeContext _db = new EmployeeContext();
            var emp = (from em in _db.Employees.Where(e => e.EmployeeId == Id) select em).SingleOrDefault();
            
            return emp;
        } 

i dodnt get any error ..

why i am not be able to send a class from here .

what is the use of writing the classes and assigning the values to their properties for more security then ? i am not able to do this then