Edit BetweenFilter
The BetweenFilter represents the "between condition" in sql for example:
SELECT * FROM Employee WHERE (Employee.EmployeeID BETWEEN 1 AND 35);
.NET Code looks like as follows:
// using Invist.Persistence.Database.Entities
// using Invist.Persistence.Database.Filters
var loader = new EntityLoader<Employee>();
var filter = new BetweenFilter( typeof(Employee), Employee.EmployeeIDProperty, 1, 35);
IEnumerable<Employee> list = loader.LoadEntities( filter );