public async Task AnonSelectEntity()
{
var em1 = await TestFns.NewEm(_serviceName);
var q = new EntityQuery <Order>().Take(5);
var r0 = await q.Execute(em1);
Assert.IsTrue(r0.Count() == 5);
var q1 = new EntityQuery <Order>().Select(o => new { o.Customer }).Take(5);
var r1 = await q1.Execute(em1);
Assert.IsTrue(r1.Count() == 5);
var ok = r1.All(r => r.Customer.GetType() == typeof(Customer));
Assert.IsTrue(ok);
// This only works because we insure that the order exists in cache before the query
var r1Local = q1.ExecuteLocally(em1);
Assert.IsTrue(r1Local.Count() == r1.Count());
ok = r1Local.All(r => r.Customer.Orders.Count >= 1);
Assert.IsTrue(ok, "Order's per customer should be >= one for now because that's what we cached");
ok = r1Local.All(r => r.Customer.GetType() == typeof(Customer));
Assert.IsTrue(ok);
}
public async Task WithOnlyExpand() {
var em1 = await TestFns.NewEm(_serviceName);
var q = new EntityQuery<Customer>().Take(3);
var r0 = await em1.ExecuteQuery(q);
var q1 = new EntityQuery<Customer>().Expand("Orders");
var r1 = q1.ExecuteLocally(em1);
Assert.IsTrue(r0.Count() == r1.Count());
}
public async Task WithOnlyExpand() {
await _emTask;
var q = new EntityQuery<Customer>().Take(3);
var r0 = await _em1.ExecuteQuery(q);
var q1 = new EntityQuery<Customer>().Expand("Orders");
var r1 = q1.ExecuteLocally(_em1);
Assert.IsTrue(r0.Count() == r1.Count());
}
public async Task SimpleQuery() {
await _emTask;
var q = new EntityQuery<Customer>();
var r0 = await _em1.ExecuteQuery(q);
Assert.IsTrue(r0.Cast<Object>().Count() > 0);
var r1 = q.ExecuteLocally(_em1);
Assert.IsTrue(r0.Count() == r1.Count());
}
public async Task SimpleQuery() {
var em1 = await TestFns.NewEm(_serviceName);
var q = new EntityQuery<Customer>();
var r0 = await em1.ExecuteQuery(q);
Assert.IsTrue(r0.Cast<Object>().Count() > 0);
var r1 = q.ExecuteLocally(em1);
Assert.IsTrue(r0.Count() == r1.Count());
}
public async Task WithOnlyExpand()
{
await _emTask;
var q = new EntityQuery <Customer>().Take(3);
var r0 = await _em1.ExecuteQuery(q);
var q1 = new EntityQuery <Customer>().Expand("Orders");
var r1 = q1.ExecuteLocally(_em1);
Assert.IsTrue(r0.Count() == r1.Count());
}
public async Task WithOnlyExpand()
{
var em1 = await TestFns.NewEm(_serviceName);
var q = new EntityQuery <Customer>().Take(3);
var r0 = await em1.ExecuteQuery(q);
var q1 = new EntityQuery <Customer>().Expand("Orders");
var r1 = q1.ExecuteLocally(em1);
Assert.IsTrue(r0.Count() == r1.Count());
}
public async Task SimpleQuery()
{
await _emTask;
var q = new EntityQuery <Customer>();
var r0 = await _em1.ExecuteQuery(q);
Assert.IsTrue(r0.Cast <Object>().Count() > 0);
var r1 = q.ExecuteLocally(_em1);
Assert.IsTrue(r0.Count() == r1.Count());
}
public async Task GuidQuery()
{
await _emTask;
var q = new EntityQuery <Customer>().Take(3);
var r = await _em1.ExecuteQuery(q);
Assert.IsTrue(r.Count() == 3, "should be no results");
var q1 = new EntityQuery <Customer>().Where(c => c.CustomerID.Equals(Guid.NewGuid()));
var r1 = q1.ExecuteLocally(_em1);
Assert.IsTrue(r1.Count() == 0);
}
public async Task QueryWithYearFn()
{
var em1 = await TestFns.NewEm(_serviceName);
var q0 = new EntityQuery <Employee>().Where(e => e.HireDate.Value.Year > 1993);
var r0 = await q0.Execute(em1);
Assert.IsTrue(r0.Count() > 0);
Assert.IsTrue(r0.All(r => r.HireDate.Value.Year > 1993));
var r1 = q0.ExecuteLocally(em1);
Assert.IsTrue(r1.Count() == r0.Count());
}
public async Task WhereFnMonth()
{
var em1 = await TestFns.NewEm(_serviceName);
var q0 = new EntityQuery <Employee>().Where(e => e.HireDate.Value.Month > 6 && e.HireDate.Value.Month < 11);
var r0 = await q0.Execute(em1);
Assert.IsTrue(r0.Count() > 0);
Assert.IsTrue(r0.All(e => e.HireDate.Value.Month > 6 && e.HireDate.Value.Month < 11));
var r1 = q0.ExecuteLocally(em1);
Assert.IsTrue(r1.Count() == r0.Count());
}
public async Task WhereFnAdd()
{
var em1 = await TestFns.NewEm(_serviceName);
var q0 = new EntityQuery <Employee>().Where(e => e.EmployeeID + e.ReportsToEmployeeID.Value > 3);
var r0 = await q0.Execute(em1);
Assert.IsTrue(r0.Count() > 0);
Assert.IsTrue(r0.All(e => e.EmployeeID + e.ReportsToEmployeeID > 3));
var r1 = q0.ExecuteLocally(em1);
Assert.IsTrue(r1.Count() == r0.Count());
}
public async Task SimpleQuery()
{
var em1 = await TestFns.NewEm(_serviceName);
var q = new EntityQuery <Customer>();
var r0 = await em1.ExecuteQuery(q);
Assert.IsTrue(r0.Cast <Object>().Count() > 0);
var r1 = q.ExecuteLocally(em1);
Assert.IsTrue(r0.Count() == r1.Count());
}
public async Task QueryWithAddFn()
{
await _emTask;
var q0 = new EntityQuery <Employee>().Where(e => e.EmployeeID + e.ReportsToEmployeeID.Value > 3);
var r0 = await q0.Execute(_em1);
Assert.IsTrue(r0.Count() > 0);
Assert.IsTrue(r0.All(e => e.EmployeeID + e.ReportsToEmployeeID > 3));
var r1 = q0.ExecuteLocally(_em1);
Assert.IsTrue(r1.Count() == r0.Count());
}
public async Task QueryWithMonthFn()
{
await _emTask;
var q0 = new EntityQuery <Employee>().Where(e => e.HireDate.Value.Month > 6 && e.HireDate.Value.Month < 11);
var r0 = await q0.Execute(_em1);
Assert.IsTrue(r0.Count() > 0);
Assert.IsTrue(r0.All(e => e.HireDate.Value.Month > 6 && e.HireDate.Value.Month < 11));
var r1 = q0.ExecuteLocally(_em1);
Assert.IsTrue(r1.Count() == r0.Count());
}
public async Task QueryWithYearFn()
{
await _emTask;
var q0 = new EntityQuery <Employee>().Where(e => e.HireDate.Value.Year > 1993);
var r0 = await q0.Execute(_em1);
Assert.IsTrue(r0.Count() > 0);
Assert.IsTrue(r0.All(r => r.HireDate.Value.Year > 1993));
var r1 = q0.ExecuteLocally(_em1);
Assert.IsTrue(r1.Count() == r0.Count());
}
public async Task GuidQuery2()
{
var em1 = await TestFns.NewEm(_serviceName);
var q = new EntityQuery <Customer>().Take(3);
var r = await em1.ExecuteQuery(q);
Assert.IsTrue(r.Count() == 3, "should be no results");
var q1 = new EntityQuery <Order>().Where(o => o.CustomerID == Guid.NewGuid()); // && true);
var r1 = q1.ExecuteLocally(em1);
Assert.IsTrue(r1.Count() == 0);
}
public async Task AnonSelectEntity() {
var em1 = await TestFns.NewEm(_serviceName);
var q = new EntityQuery<Order>().Take(5);
var r0 = await q.Execute(em1);
Assert.IsTrue(r0.Count() == 5);
var q1 = new EntityQuery<Order>().Select(o => new { o.Customer }).Take(5);
var r1 = await q1.Execute(em1);
Assert.IsTrue(r1.Count() == 5);
var ok = r1.All(r => r.Customer.GetType() == typeof(Customer));
Assert.IsTrue(ok);
// This only works because we insure that the order exists in cache before the query
var r1Local = q1.ExecuteLocally(em1);
Assert.IsTrue(r1Local.Count() == r1.Count());
ok = r1Local.All(r => r.Customer.Orders.Count == 1);
Assert.IsTrue(ok, "Order's per customer should be only one for now because that's all we cached");
ok = r1Local.All(r => r.Customer.GetType() == typeof(Customer));
Assert.IsTrue(ok );
}
public async Task GuidQuery() {
await _emTask;
var q = new EntityQuery<Customer>().Take(3);
var r = await _em1.ExecuteQuery(q);
Assert.IsTrue(r.Count() == 3, "should be no results");
var q1 = new EntityQuery<Customer>().Where(c => c.CustomerID.Equals(Guid.NewGuid()));
var r1 = q1.ExecuteLocally(_em1);
Assert.IsTrue(r1.Count() == 0);
}
public async Task QueryWithAddFn() {
await _emTask;
var q0 = new EntityQuery<Employee>().Where(e => e.EmployeeID + e.ReportsToEmployeeID.Value > 3);
var r0 = await q0.Execute(_em1);
Assert.IsTrue(r0.Count() > 0);
Assert.IsTrue(r0.All(e => e.EmployeeID + e.ReportsToEmployeeID > 3));
var r1 = q0.ExecuteLocally(_em1);
Assert.IsTrue(r1.Count() == r0.Count());
}
public async Task WhereFnAdd() {
var em1 = await TestFns.NewEm(_serviceName);
var q0 = new EntityQuery<Employee>().Where(e => e.EmployeeID + e.ReportsToEmployeeID.Value > 3);
var r0 = await q0.Execute(em1);
Assert.IsTrue(r0.Count() > 0);
Assert.IsTrue(r0.All(e => e.EmployeeID + e.ReportsToEmployeeID > 3));
var r1 = q0.ExecuteLocally(em1);
Assert.IsTrue(r1.Count() == r0.Count());
}
public async Task WhereFnMonth() {
var em1 = await TestFns.NewEm(_serviceName);
var q0 = new EntityQuery<Employee>().Where(e => e.HireDate.Value.Month > 6 && e.HireDate.Value.Month < 11);
var r0 = await q0.Execute(em1);
Assert.IsTrue(r0.Count() > 0);
Assert.IsTrue(r0.All(e => e.HireDate.Value.Month > 6 && e.HireDate.Value.Month < 11));
var r1 = q0.ExecuteLocally(em1);
Assert.IsTrue(r1.Count() == r0.Count());
}
public async Task QueryWithMonthFn() {
await _emTask;
var q0 = new EntityQuery<Employee>().Where(e => e.HireDate.Value.Month > 6 && e.HireDate.Value.Month < 11);
var r0 = await q0.Execute(_em1);
Assert.IsTrue(r0.Count() > 0);
Assert.IsTrue(r0.All(e => e.HireDate.Value.Month > 6 && e.HireDate.Value.Month < 11));
var r1 = q0.ExecuteLocally(_em1);
Assert.IsTrue(r1.Count() == r0.Count());
}
public async Task SimpleSelect() {
await _emTask;
var q = new EntityQuery<Order>().Take(5);
var r = await q.Execute(_em1);
Assert.IsTrue(r.Count() == 5);
var q1 = new EntityQuery<Order>().Select(o => o.Customer).Take(5);
var r1 = await q1.Execute(_em1);
Assert.IsTrue(r1.Count() == 5);
var ok = r1.All(c => c.GetType() == typeof(Customer));
Assert.IsTrue(ok);
var r1Local = q1.ExecuteLocally(_em1);
Assert.IsTrue(r1Local.Count() == r1.Count());
ok = r1Local.All(c => c.GetType() == typeof(Customer));
Assert.IsTrue(ok );
}
public async Task GuidQuery2() {
var em1 = await TestFns.NewEm(_serviceName);
var q = new EntityQuery<Customer>().Take(3);
var r = await em1.ExecuteQuery(q);
Assert.IsTrue(r.Count() == 3, "should be no results");
var q1 = new EntityQuery<Order>().Where(o => o.CustomerID == Guid.NewGuid()); // && true);
var r1 = q1.ExecuteLocally(em1);
Assert.IsTrue(r1.Count() == 0);
}
public async Task QueryWithYearFn() {
await _emTask;
var q0 = new EntityQuery<Employee>().Where(e => e.HireDate.Value.Year > 1993);
var r0 = await q0.Execute(_em1);
Assert.IsTrue(r0.Count() > 0);
Assert.IsTrue(r0.All(r => r.HireDate.Value.Year > 1993));
var r1 = q0.ExecuteLocally(_em1);
Assert.IsTrue(r1.Count() == r0.Count());
}
