Changeset 2004

Timestamp:

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

Author:

svonolfe

Message:

Added paging to DAL (#372)

Location:

trunk/sources

Files:

• HeuristicLab.DataAccess.ADOHelper/3.2/DataAdapterBase.cs (modified) (4 diffs)
• HeuristicLab.DataAccess/3.2/Interfaces/IDataAdapter.cs (modified) (1 diff)

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;

trunk/sources/HeuristicLab.DataAccess/3.2/Interfaces/IDataAdapter.cs

@@ -48 +48 @@
 
     /// <summary>
+    /// Get all objects (paged)
+    /// </summary>
+    /// <returns></returns>
+    ICollection<ObjT> GetAll(int from, int size);
+
+    /// <summary>
     /// Deletes the object
     /// </summary>