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) }));
}
