public async Task EnumConditionTest() { var expression = "$filter=MessagingAccountType ne 1"; var runner = new MongoDBQueryRunner <MessagingAccount>(); var docQuery = new ODataQueryParser <MessagingAccount>(); var query = docQuery.TryParse(expression); runner.Create(query); var collection = GetCollection <MessagingAccount>("messagingaccount"); var list = await runner.QueryAsync(collection); Assert.True(list.Count > 0); }
public async Task ComplexFilterTest() { var expression = "$filter=(CompanyGroup eq 'Synechron' and IsDeleted eq false) or NumberOfEmployees ge 1"; //var expression = "startswith(Name,'Syne') eq true"; var runner = new MongoDBQueryRunner <Company>(); var docQuery = new ODataQueryParser <Company>(); var query = docQuery.TryParse(expression); runner.Create(query); var collection = GetCollection <Company>("company"); var list = await runner.QueryAsync(collection); Assert.True(list.Count > 0); }
public async Task ContainsFilterTest() { var expression = "$filter=contains(Name,'Test')&$orderby=name desc"; //var expression = "$filter=substringof('Test', Name)"; //var expression = "startswith(Name,'Syne') eq true"; var runner = new MongoDBQueryRunner <MessagingAccount>(); var docQuery = new ODataQueryParser <MessagingAccount>(); var query = docQuery.TryParse(expression); runner.Create(query); var collection = GetCollection <MessagingAccount>("messagingaccount"); var list = await runner.QueryAsync(collection); Assert.True(list.Count > 0); }