Devart Forums

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"