Help needed in SQL query conversion into LINQ

Question

Convert this SQL query  into LINQ query

 

where U.IsAdmin, U.IsApprover, U.IsActive, R.IsActive  are of bit data type

 

 

SELECT U.ID, U.FirstName, U.LastName, U.RoleID, U.UserID, U.IsAdmin, U.IsApprover, r.RoleName RoleName FROM USERS U 

INNER JOIN [ROLE] R ON U.ROLEID = R.ID AND R.IsActive = 1 

WHERE UPPER(U.UserID)= @UserID AND U.Password = @Password AND U.IsActive = 1