code:
Code: Select all
dbContext.Users.Where(u => u.IsActive).ToList()
Code: Select all
public class User
{
public string UserName { get; set; }
public string Password { get; set; }
public bool IsActive { get; set; }
}
Code: Select all
SELECT "u"."UserName", "u"."IsActive", "u"."Password"
FROM "Users" "u"
WHERE "u"."IsActive"