General

• All methods accept and use ISessionHandler
• Eager loading used responsibly
• IQueryable declared as internal
• POCO created for SP
• Search parameter array used
• No DateTime values are passed to the database (different servers = different time = different results).
• Domain Convention were followed.
• Create a POCO Object when you want to call a stored procedure or view from Entity Framework. See example here
• First, FirstOrDefault, Single, SingleOrDefault used for the correct purpose:
• First - when one or more entities may be returned but only the first one is used (Remember to use OrderBy to return the correct entity)
• FirstOrDefault - when none, one or more entities are returned, but only the first one is used (Remember to use OrderBy to return the correct entity)
• Single - when only one entity will ALWAYS be returned
• SingleOrDefault - when one or no entities are expected