static void GetData()
{
using (var db = new RandomTestDb())
{
var now = DateTime.UtcNow;
var lower = now.AddSeconds(-30).ToSqlGuid2();
var upper = now.ToSqlGuid2();
var products = db.Products
.Where(p => p.Id.CompareTo(lower) > 0)
.Where(p => p.Id.CompareTo(upper) < 0)
.ToArray();
Assert.AreEqual(20, products.Length);
foreach (var product in products)
{
Console.WriteLine(product.Created.ToIso8601String());
}
}
}
public void Products()
{
var expected = Enumerable.Range(0, 10)
.Select(i =>
{
var idSql = RandomData.GenerateOrderedSqlGuid2();
var name = RandomData.GenerateAlphanumerics(20);
System.Threading.Thread.Sleep(1);
return(new Product
{
Id = idSql.Guid,
Created = idSql.DateTime,
Name = name,
});
})
.ToArray();
using (var db = new RandomTestDb())
{
db.Products.AddRange(expected);
db.SaveChanges();
}
Product[] actual;
using (var db = new RandomTestDb())
{
var lower = DateTime.UtcNow.AddSeconds(-30);
actual = db.Products
.Where(p => p.Created.CompareTo(lower) > 0)
.OrderBy(p => p.Id)
.ToArray();
}
CollectionAssert.AreEqual(expected.Select(x => x.Name).ToArray(), actual.Select(x => x.Name).ToArray());
}