public void can_issue_queries_against_the_datetime_offset_as_duplicate_field()
{
StoreOptions(_ => _.Schema.For <DateOffsetClass>().Duplicate(x => x.DateTimeField));
using (var session = theStore.LightweightSession())
{
var now = GenerateTestDateTime();
_output.WriteLine("now: " + now.ToString("o"));
var testClass = new DateOffsetClass
{
Id = Guid.NewGuid(),
DateTimeField = now
};
session.Store(testClass);
session.Store(new DateOffsetClass
{
DateTimeField = now.Add(5.Minutes())
});
session.Store(new DateOffsetClass
{
DateTimeField = now.Add(-5.Minutes())
});
session.SaveChanges();
var cmd = session.Query <DateOffsetClass>().Where(x => now >= x.DateTimeField)
.ToCommand();
_output.WriteLine(cmd.CommandText);
session.Query <DateOffsetClass>().ToList().Each(x =>
{
_output.WriteLine(x.DateTimeField.ToString("o"));
});
session.Query <DateOffsetClass>()
.Count(x => now >= x.DateTimeField).ShouldBe(2);
}
}
public void can_issue_queries_against_the_datetime_offset()
{
using (var session = theStore.LightweightSession())
{
var now = DateTime.UtcNow;
_output.WriteLine("now: " + now.ToString("o"));
var testClass = new DateOffsetClass()
{
Id = Guid.NewGuid(),
DateTimeField = now
};
session.Store(testClass);
session.Store(new DateOffsetClass()
{
DateTimeField = now.Add(5.Minutes())
});
session.Store(new DateOffsetClass()
{
DateTimeField = now.Add(-5.Minutes())
});
session.SaveChanges();
var cmd = session.Query <DateOffsetClass>().Where(x => now >= x.DateTimeField)
.ToCommand();
_output.WriteLine(cmd.CommandText);
session.Query <DateOffsetClass>().ToList().Each(x =>
{
_output.WriteLine(x.DateTimeField.ToString("o"));
});
session.Query <DateOffsetClass>()
.Count(x => now >= x.DateTimeField).ShouldBe(2);
}
}
public void can_issue_queries_against_the_datetime_offset_as_duplicate_field()
{
StoreOptions(_ => _.Schema.For<DateOffsetClass>().Duplicate(x => x.DateTimeField));
using (var session = theStore.LightweightSession())
{
var now = DateTimeOffset.UtcNow;
_output.WriteLine("now: " + now.ToString("o"));
var testClass = new DateOffsetClass()
{
Id = Guid.NewGuid(),
DateTimeField = now
};
session.Store(testClass);
session.Store(new DateOffsetClass()
{
DateTimeField = now.Add(5.Minutes())
});
session.Store(new DateOffsetClass()
{
DateTimeField = now.Add(-5.Minutes())
});
session.SaveChanges();
var cmd = session.Query<DateOffsetClass>().Where(x => now >= x.DateTimeField)
.ToCommand();
_output.WriteLine(cmd.CommandText);
session.Query<DateOffsetClass>().ToList().Each(x =>
{
_output.WriteLine(x.DateTimeField.ToString("o"));
});
session.Query<DateOffsetClass>()
.Count(x => now >= x.DateTimeField).ShouldBe(2);
}
}
