Hellow pals,i have a table with columns StudentUserId,StudentId,userId and StationId whereby i need a method to return for me the object StationId for based on the StudentId and UserId whereby when th user logs in,he is identified by his Id and can only see records concerning him.Have created a method here but i acnt figure where an getting wrong as it does not return any values
public void GetStationByUserId(int StudentId,Guid StationId)
{
var query = from Students in db.StudentsUsers
where students.studentId == StudentId
where students,StationiD==stationId
select students;
return;
}
Mark as answer if satisfied