public CustomersController(FilterDbContext context)
{
context.Database.EnsureCreated();
if (!context.Customers.Any())
{
Customer customer = new Customer
{
Name = "First",
CustomMetadata = "{\"CustomPropA\": \"CustomValA\" }"
};
context.Customers.Add(customer);
customer = new Customer
{
Name = "Second",
CustomMetadata = "{\"CustomPropB\": \"CustomValB\" }"
};
context.Customers.Add(customer);
customer = new Customer
{
Name = "Third",
CustomMetadata = "{\"CustomPropA\": \"CustomValA\", \"CustomPropC\": \"CustomValC\" }"
};
context.Customers.Add(customer);
context.SaveChanges();
}
_context = context;
}
public void Should_be_able_to_handle_nullable_source()
{
using (var context = new FilterDbContext(fixture.ConnectionString))
using (var transaction = context.Database.BeginTransaction())
{
context.People.AddRange(People);
context.SaveChanges();
var @return = context.People.Filter(new
{
Rating = (Range <decimal>) "[4.5,5.0]"
});
Assert.Equal(1, @return.Count());
transaction.Rollback();
}
}
public void Can_filter_datetimeoffset_via_entity_framework()
{
using (var context = new FilterDbContext(fixture.ConnectionString))
using (var transaction = context.Database.BeginTransaction())
{
context.People.AddRange(People);
context.SaveChanges();
var @return = context.People.Filter(new
{
FavoriteDateTimeOffset = (Range <DateTimeOffset>) "[2010-01-01,2010-01-02)"
});
Assert.Equal(1, @return.Count());
transaction.Rollback();
}
}
public void Can_filter_nullable_models_via_entity_framework()
{
Database.SetInitializer(new DropCreateDatabaseAlways <FilterDbContext>());
using (var context = new FilterDbContext(fixture.ConnectionString))
using (var transaction = context.Database.BeginTransaction())
{
context.People.AddRange(People);
context.SaveChanges();
var @return = context.People.Filter(new
{
Rating = new decimal?(4.5m)
});
Assert.Equal(1, @return.Count());
transaction.Rollback();
}
}