C# (CSharp) NpgsqlRange.DoesNotExtendRightOf示例

示例#1

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

        Assert.Equal(2, result.Id);

        AssertSql(
            @"@__range_0='[1,13]' (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");
    }