C# (CSharp) LTree.Any Examples

Example #1

        public void LTree_contained_by_any_LTree()
        {
            using var ctx = CreateContext();
            var ltrees = new LTree[] { "Top.Science.Astronomy", "Top.Art" };
            var count  = ctx.LTreeEntities.Count(l => ltrees.Any(t => t.IsDescendantOf(l.Path)));

            Assert.Equal(3, count);
            AssertSql(
                @"@__ltrees_0='System.String[]' (DbType = Object)

SELECT COUNT(*)::INT
FROM ""LTreeEntities"" AS l
WHERE @__ltrees_0 <@ l.""Path""");
        }

Example #2

File: LTreeQueryTest.cs Project: npgsql/efcore.pg

    public void LTree_contains_any_LTree()
    {
        using var ctx = CreateContext();
        var ltrees = new LTree[] { "Top.Science", "Top.Art" };
        var count  = ctx.LTreeEntities.Count(l => ltrees.Any(t => t.IsAncestorOf(l.Path)));

        Assert.Equal(4, count);
        AssertSql(
            @"@__ltrees_0={ 'Top.Science', 'Top.Art' } (DbType = Object)

SELECT count(*)::int
FROM ""LTreeEntities"" AS l
WHERE @__ltrees_0 @> l.""Path""");
    }

Example #3

        public void Any_LTree_matches_LTxtQuery()
        {
            using var ctx = CreateContext();

            var ltrees = new LTree[] { "Top.Science.Astronomy.Astrophysics", "Top.Science.Astronomy.Cosmology" };

            _ = ctx.LTreeEntities.Count(_ => ltrees.Any(t => t.MatchesLTxtQuery("Astro*")));

            AssertSql(
                @"@__ltrees_0='System.String[]' (DbType = Object)

SELECT COUNT(*)::INT
FROM ""LTreeEntities"" AS l
WHERE @__ltrees_0 @ 'Astro*'");
        }

Example #4

File: LTreeQueryTest.cs Project: npgsql/efcore.pg

    public void Any_LTree_matches_LQuery()
    {
        using var ctx = CreateContext();

        var ltrees = new LTree[] { "Top.Science.Astronomy.Astrophysics", "Top.Science.Astronomy.Cosmology" };

        _ = ctx.LTreeEntities.Count(_ => ltrees.Any(t => t.MatchesLQuery("*.Astrophysics")));

        AssertSql(
            @"@__ltrees_0={ 'Top.Science.Astronomy.Astrophysics', 'Top.Science.Astronomy.Cosmology' } (DbType = Object)

SELECT count(*)::int
FROM ""LTreeEntities"" AS l
WHERE @__ltrees_0 ~ '*.Astrophysics'");
    }

Example #5

File: LTreeQueryTest.cs Project: akilin/efcore.pg

    public void Any_LTree_matches_any_LQuery()
    {
        using var ctx = CreateContext();

        var ltrees   = new LTree[] { "Top.Science.Astronomy.Astrophysics", "Top.Science.Astronomy.Cosmology" };
        var lqueries = new[] { "*.Astrophysics", "*.Geology" };

        _ = ctx.LTreeEntities.Count(_ => ltrees.Any(t => lqueries.Any(q => t.MatchesLQuery(q))));

        AssertSql(
            @"@__ltrees_0={ 'Top.Science.Astronomy.Astrophysics', 'Top.Science.Astronomy.Cosmology' } (DbType = Object)
@__lqueries_1={ '*.Astrophysics', '*.Geology' } (DbType = Object)

SELECT COUNT(*)::INT
FROM ""LTreeEntities"" AS l
WHERE @__ltrees_0 ? @__lqueries_1");
    }