Please help how can i improve the code to filter records based on this storedprocedure using the API i have created
Public Class EmployeesidController
Inherits ApiController
Public Function Getid(ByVal id As Integer) As Employee
Dim dbContext As SCHOOLEntities = New EmployeeDBContext
Return dbContext.Employees.Find(id)
End Function
End Class
I want to use this stored procedure with entity framework to filter record
PROCEDURE [dbo].[Sulaextract]
@C nvarchar(50),
@Cs nvarchar(50)
AS
select admno,name,class,stream from Archivedreports
where class=@c and stream=@c