public async Task ODataRepositoryWithGrouping()
{
var odata = new DefaultWebQueryRepository(repository);
var query = new ODataQueryProvider();
query.OrderBy = "AString asc";
query.Apply = "groupby((AString, AMonth))";
query.Skip = "0";
query.Top = "100";
var res0 = await odata.ExecuteQuery <ReferenceType, ReferenceTypeExtended>(query);
Assert.NotNull(res0);
Assert.Equal(res0.TotalCount, 2);
Assert.Equal(res0.TotalPages, 1);
Assert.Equal(res0.Page, 1);
Assert.NotNull(res0.Data);
Assert.Equal(res0.Data.Count, 2);
var el = res0.Data.First();
Assert.Equal(el.AString, "dummy1");
Assert.True(el is ReferenceTypeExtended);
}
public async Task ODataRepository()
{
var odata = new DefaultWebQueryRepository(repository);
var query = new ODataQueryProvider();
query.Filter = "AString eq 'dummy1'";
query.OrderBy = "Id desc";
query.Skip = "0";
query.Top = "1";
var res0 = await odata.ExecuteQuery <ReferenceType, ReferenceTypeExtended>(query);
Assert.NotNull(res0);
Assert.Equal(res0.TotalCount, 2);
Assert.Equal(res0.TotalPages, 2);
Assert.Equal(res0.Page, 1);
Assert.NotNull(res0.Data);
Assert.Equal(res0.Data.Count, 1);
var el = res0.Data.First();
Assert.Equal(el.AString, "dummy1");
query = new ODataQueryProvider();
query.Filter = "AString eq 'dummy1'";
query.OrderBy = "Id desc";
query.Skip = "1";
query.Top = "1";
var res1 = await odata.ExecuteQuery <ReferenceType, ReferenceTypeExtended>(query);
Assert.NotNull(res1);
Assert.Equal(res1.TotalCount, 2);
Assert.Equal(res1.TotalPages, 2);
Assert.Equal(res1.Page, 2);
Assert.NotNull(res1.Data);
Assert.Equal(res1.Data.Count, 1);
var el1 = res1.Data.First();
Assert.Equal(el1.AString, "dummy1");
Assert.True(el.Id.Value > el1.Id.Value);
}
