Documentation

• Introduction
• Loading Data
  • Filtering
    • BetweenFilter
    • CompareFilter
    • ConstantValueFilter
    • InFilter
    • CompoundFilter
  • Sorting
  • Async Loading
• Persisting Data
• Stored Procedures

• Create a new Page
• Administration
• File Management
• Login/Logout

Compound Filter

CompoundFilter

SELECT * FROM Products WHERE  ( (Products.SupplierId = Suppliers.SupplierId) AND (Products.SupplierId = 1) );

// using Invist.Persistence.Database.Entities
// using Invist.Persistence.Database.Filters

IEntityLoader<Product> loader = new EntityLoader<Product>();

var leftItem = new CompareItem( typeof( Product ), Product.SupplierIDProperty );
var rightItem = new CompareItem( typeof( Supplier ), Supplier.SupplierIDProperty );
var compareFilter = new CompareFilter( leftItem, CompareOperator.Equal, rightItem );

var constantValueFilter = new ConstantValueFilter(
    typeof( Product ),
    Product.SupplierIDProperty,
    CompareOperator.Equal, 1 );

var compoundFilter = new CompoundFilter( CompoundOperator.And );
compoundFilter.AddFilter( compareFilter );
compoundFilter.AddFilter( constantValueFilter );

IEnumerable<Product> list = loader.LoadEntities( filter );