Question

We have a table, that contains more then 1000000 records. How to remove this records without materialization? This code is too greedy for resources:

var res = session.Query.All<DataModel.GPSData>()
          .Where(d => d.StartDateTime < DateTime.Now);
foreach (var item in res)
  item.Remove();

Also looking on Compiled Query, but i can't find the way to use it, because documented example is'nt work any more in version 4.4.

Answer 1

3

http://depositfiles.com/files/bw0uinyoo

var countDeleted = session.Query.All<DataModel.GPSData>()
      .Where(d => d.StartDateTime < DateTime.Now).Delete();
var countUpdated = session.Query.All<DataModel.GPSData>()
      .Where(d => d.StartDateTime < DateTime.Now).Update(d=>new DataModel.GPSData{Data=d.Data*2, Data1=5, Data2=d.Data3+"test"});

i will publish it in nuget soon. Limitations: reference fields in Update method are not supported, supports only mssql driver, compiled queries are not supported

answered Oct 19 '11 at 03:14

proff
75●3●3●6

edited Oct 19 '11 at 03:28

1

Hi,

The NuGet package is ready for use. It can be installed via Visual Studio NuGet package manager, more info is here.

The package is called DataObjectsExtensions, it provides server-side batch DML operations. Current limitations: MS SQL Server only. Not supported yet: reference fields in Update method, compiled queries.

(Oct 20 '11 at 16:30) proff

Subscription:

Related questions