Hi Guys,
I have searched through the forum and found 4 threads, but not really related to what we want to do.
I would really like to keep to the Entity collections using the DQE, so using Stored Proc is not really the answer, especially temp tables.
Want I would like to do is get n amount of records starting from x index in the filtered collection, I can't seem to find the syntax to do this. I hope don't mind but I am going to use Paul Wilsons mapper as an example (please do ban me from the forum ).
ObjectSpace ob =
new ObjectSpace("mapping.config","connectionstring",Provider.MsSql,30,30);
ObjectQuery qry =
new ObjectQuery(typeof(User),"WhereClause","SortClause",pageSize,pageIndex);
ob.GetObjectSet(qry);
This is kind of what I would like to do, is this available? If not can I submit it as a feature request. Also if not is there another way of doing it?
Paul's mapper was the reason for my LLBLGen Pro purchase and your excellent documentation, oh yes of course the product is sweet as well!
Cheers
Gareth