Documentation of free .NET O/R Mapper - Code Generator Invist



The CompareFilter represents the "compare condition" in sql for example:

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

.NET Code looks like as follows:

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

var loader = new EntityLoader<Product>();

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

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

ScrewTurn Wiki version 2.0.35. Some of the icons created by FamFamFam. Invist is powered by Mirko Meier