c# - FluentCassandra range selection problem -


I have a problem getting some data from Cassandra using c # and FluentCassandra in my Cassandra keyspace I have the following super The column family definition is:

  & lt; Type columnfamily name = "MySFName" column = "super" Compare = "compare with tyyuuid type" presently = "esi type" / & gt;   

What I want to do is run a query on this supercool, similar to the following: sql:

  Choose "something" from MyTable where "timestamp" 2011-01-01 00: 00: 00.000 "and" 2011-03-01 00: 00: 00.000 "After a tutorial" I found that I can get some data Cassandra with the following command:  
  family.Get ("238028210009775"). Receive (date time.parse ("2011-01-01 00: 00: 00.000")). FirstOriginal ();   

But this sql "timestamp" & gt; "2011-01-01 00: 00: 00.000"

And by now I can not understand how to recover data from a series of values.

Any sign or help would be appreciated :) Thanks in advance, Nicola

You should be able to do it with: {var dateDateTime.Now using

  (var db = new CassandraContext (keyboard: "keypace_name", host: "localhost")) .Subtract (new timespan (0, 30, 0)); Var toDate = DateTime.Now; Var family = db.GetColumnFamily & lt; TymuUID Type, Escetype & gt; ("Family_name"); Var results = family. Go ("row_key") .Fetch (fromDate) .tackout (toDate). FirstOrDefault (); }    

Comments