How to write where clause using LINQ

Question

Good Morning,

Please do let me know how to write the following sql query using LINQ in ASP.Net Core 6:

  select u.Email,u.Password,p.UserRole 
  from [AMS].[dbo].[User] u join UserProgram p
  on u.id=p.UserId
  where p.UserRole=1