CODEWITHSUNDEEP
entity-framework
vijayst
vijayst

Reputation: 21846

Map stored procedure results to a custom complex type in Entity Framework

Consider a stored procedure GetEmployees which has a SELECT statement like

SELECT EMP_ID, EMP_NAME, EMP_EMAIL 
FROM EMPLOYEE

This stored procedure will have its results mapped to a complex type GetEmployees_Result

class GetEmployees_Result {
   public int EMP_ID;
   public string EMP_NAME;
   public string EMP_EMAIL;
}

Is it possible to map the result of the function import to a different complex type like the one below:

class GetEmployeesResult {
  public int Id;
  public string Name;
  public string Email;
}

Upvotes: 0

Views: 1891

Answers (1)

vijayst
vijayst

Reputation: 21846

It is a standard feature. You have go to the mapping of the function import and change the result type to the custom type.

Upvotes: 1

Related Questions