C# (CSharp) NpgsqlRange.IsAdjacentTo Examples

Example #1

    public void IsAdjacentTo()
    {
        using var context = CreateContext();
        var range  = new NpgsqlRange <int>(2, 4);
        var result = context.RangeTestEntities.Single(x => range.IsAdjacentTo(x.IntRange));

        Assert.Equal(2, result.Id);

        AssertSql(
            @"@__range_0='[2,4]' (DbType = Object)

SELECT r.""Id"", r.""DateOnlyDateRange"", r.""DateTimeDateRange"", r.""DecimalRange"", r.""IntRange"", r.""LongRange"", r.""UserDefinedRange"", r.""UserDefinedRangeWithSchema""
FROM ""RangeTestEntities"" AS r
WHERE @__range_0 -|- r.""IntRange""
LIMIT 2");
    }