.LoadProperty()require duplicate hits to the database, regardless if the data persistence layer already made this query and determined there was no matching entries.
feature/nuado) has been in development for several months. This new persistence layer:
Count(), etc. translates directly to SQL statements in the database rather than deep loading
QueryPersistenceContextto control the manner in which properties are loaded based on the caller's use case.
IQueryResultSet<T>interface. These interfaces support methods for skipping and taking records from the underlining data store in a method which reduces the data loaded from the SQL database.