C# (CSharp) RangeQueryNpgsqlFixture.CreateContext Examples

Example #1

File: RangeQueryNpgsqlTest.cs Project: wojciechgl/Npgsql.EntityFrameworkCore.PostgreSQL

        public void RangeContainsRange(NpgsqlRange <int> range)
        {
            using (RangeContext context = Fixture.CreateContext())
            {
                RangeTestEntity[] _ =
                    context.RangeTestEntities
                    .Where(x => x.Range.Contains(range))
                    .ToArray();

                AssertContainsSql("WHERE (x.\"Range\" @> @__range_0) = TRUE");
            }
        }

Example #2

File: RangeQueryNpgsqlTest.cs Project: igorsiq/Npgsql.EntityFrameworkCore.PostgreSQL

        public void RangeContainsRange(NpgsqlRange <int> range)
        {
            using (var context = Fixture.CreateContext())
            {
                var _ =
                    context.RangeTestEntities
                    .Where(x => x.Range.Contains(range))
                    .ToArray();

                AssertContainsSql(@"r.""Range"" @> @__range_0)");
            }
        }