Changeset 2004 for trunk/sources/HeuristicLab.DataAccess.ADOHelper/3.2/DataAdapterBase.cs

Timestamp:

06/04/09 17:04:38 (15 years ago)

Author:

svonolfe

Message:

Added paging to DAL (#372)

File:

• trunk/sources/HeuristicLab.DataAccess.ADOHelper/3.2/DataAdapterBase.cs (modified) (4 diffs)

trunk/sources/HeuristicLab.DataAccess.ADOHelper/3.2/DataAdapterBase.cs

@@ -138 +138 @@
     }
 
-    protected ICollection<ObjT> FindMultiple(Selector selector) {
+    private ICollection<ObjT> FindMultiple(Selector selector, 
+      int from, int size) {
       ITransaction trans =
        session.GetCurrentTransaction();
@@ -150 +151 @@
           selector();
 
+        if (from > 0 && size > 0)
+          found = found.Skip<RowT>(from).Take<RowT>(size);
+
         IList<ObjT> result =
           new List<ObjT>();
@@ -167 +171 @@
         }
       }     
+    }
+
+    protected ICollection<ObjT> FindMultiple(Selector selector) {
+      return FindMultiple(
+        selector, 0, -1);
     }
 
@@ -244 +253 @@
     }
 
+    public virtual ICollection<ObjT> GetAll(int from, int size) {
+      //note - this base implementation is inefficient,
+      //consider overriding the implementation 
+      //in derived adapters (based on a query (SQL LIMIT))
+      return new List<ObjT>(
+        FindMultiple(
+          new Selector(dataAdapter.FindAll), 
+          from, size));
+    }
+
     protected virtual bool doDelete(ObjT obj) {
       bool success = false;