public void BinaryParam() { var odata = new ODataV4Parameterizer(); var query = odata.Parameterize("$filter=Value eq @Value", new { Value = new byte[] { 0x0a, 0x01, 0xff } }); Assert.Equal("$filter=Value eq binary'0A01FF'", query); }
public void DoubleParam() { var odata = new ODataV4Parameterizer(); var query = odata.Parameterize("$filter=Value eq @Value", new { Value = 1.23d }); Assert.Equal("$filter=Value eq 1.23d", query); }
public void DecimalParamItIT() { var odata = new ODataV4Parameterizer(); var query = odata.Parameterize("$filter=Value eq @Value", new { Value = 1.23m }); Assert.Equal("$filter=Value eq 1.23M", query); }
public void Email() { var odata = new ODataV4Parameterizer(); var query = odata.Parameterize("$filter=Value1 eq @Value1 and Value2 eq @Value2", new { Value1 = "*****@*****.**", Value2 = 123 }); Assert.Equal("$filter=Value1 eq '*****@*****.**' and Value2 eq 123", query); }
public void LongParam() { var odata = new ODataV4Parameterizer(); var query = odata.Parameterize("$filter=Value eq @Value", new { Value = 123L }); Assert.Equal("$filter=Value eq 123L", query); }
public void Complex() { var odata = new ODataV4Parameterizer(); var query = odata.Parameterize("$filter=Value1 eq @Value1 and Value2 eq @Value2 and Value3 eq @Value3", new { Value1 = 123L, Value2 = 1.23d, Value3 = 1.23m }); Assert.Equal("$filter=Value1 eq 123L and Value2 eq 1.23d and Value3 eq 1.23M", query); }
public void NullableParam() { var odata = new ODataV4Parameterizer(); var query = odata.Parameterize("$filter=Value1 eq @Value1 and Value2 eq @Value2", new { Value1 = (int?)123, Value2 = (int?)null }); Assert.Equal("$filter=Value1 eq 123 and Value2 eq null", query); }
public void All() { var odata = new ODataV4Parameterizer(); var query = odata.Parameterize("$filter=Value1 eq @Value and Value2 eq @Value and Value3 eq @Value", new { Value = 123 }); Assert.Equal("$filter=Value1 eq 123 and Value2 eq 123 and Value3 eq 123", query); }
public void DateTimeOffsetParam() { var odata = new ODataV4Parameterizer(); var query = odata.Parameterize("$filter=Value eq @Value", new { Value = DateTimeOffset.MaxValue }); Assert.Equal("$filter=Value eq 9999-12-31T23:59:59.9999999%2B00:00", query); }
public void GuidParam() { var odata = new ODataV4Parameterizer(); var query = odata.Parameterize("$filter=Value eq @Value", new { Value = Guid.Empty }); Assert.Equal("$filter=Value eq guid'00000000-0000-0000-0000-000000000000'", query); }
public void StringParam() { var odata = new ODataV4Parameterizer(); var query = odata.Parameterize("$filter=Value eq @Value", new { Value = "Hello, World!" }); Assert.Equal("$filter=Value eq 'Hello, World!'", query); }
public void TimeSpanParamItIT() { var odata = new ODataV4Parameterizer(); Assert.Equal("$filter=Value eq time'P30D'", odata.Parameterize("$filter=Value eq @Value", new { Value = TimeSpan.FromDays(30) })); Assert.Equal("$filter=Value eq time'PT1H'", odata.Parameterize("$filter=Value eq @Value", new { Value = TimeSpan.FromHours(1) })); Assert.Equal("$filter=Value eq time'PT15M'", odata.Parameterize("$filter=Value eq @Value", new { Value = TimeSpan.FromMinutes(15) })); Assert.Equal("$filter=Value eq time'PT1S'", odata.Parameterize("$filter=Value eq @Value", new { Value = TimeSpan.FromSeconds(1) })); Assert.Equal("$filter=Value eq time'PT0.5S'", odata.Parameterize("$filter=Value eq @Value", new { Value = TimeSpan.FromMilliseconds(500) })); Assert.Equal("$filter=Value eq time'PT1.5S'", odata.Parameterize("$filter=Value eq @Value", new { Value = TimeSpan.FromMilliseconds(1500) })); Assert.Equal("$filter=Value eq time'PT0S'", odata.Parameterize("$filter=Value eq @Value", new { Value = default(TimeSpan) })); }