i am getting the following errors
e is not a member of schoolentities
request is not declared. it may be inacessible due to protection level.
my target is to get the gender selected from the table called employees.
Imports System.Data.Entity
Imports System.Data.SqlClient
Imports System.Net
Imports System.Net.Http
Imports System.Web.Http
Imports System.Web.Mvc
Imports System.Web.UI.WebControls
Imports EMPLOYEESERVICEAPI
Public Function Get(ByVal gender As String = "All") As HttpResponseMessage
' Imports SCHOOLEntities entities = New EmployeeDBEntities()
Dim dbContext As SCHOOLEntities = New EmployeeDBContext
Select Case gender.ToLower()
Case "all"
Return HttpRequest.CreateResponse(HttpStatusCode.OK,
dbContext.Employees.ToList())
Case "male"
Return Request.CreateResponse(HttpStatusCode.OK,
dbContext.Employees.Where(dbContext.e >= e.Gender.ToLower() = "male").ToList())
Case "female"
Return Request.CreateResponse(HttpStatusCode.OK,
dbContext.Employees.Where(e >= e.Gender.ToLower() = "female").ToList())
Case Else
Return Request.CreateErrorResponse(HttpStatusCode.BadRequest,
"Value for gender must be Male, Female or All. " + gender + " is invalid.")
End Select
End Function