Monthly Archives: October 2013

WebApi Extension 3.0.3 Released

MicroLite.Extensions.WebApi 3.0.3 has been released on NuGet.

There are a couple of changes in this release:

  • Updated to Net.Http.WebApi.OData 1.0.2
  • Added support for the tolower() function in a $filter query. e.g. $filter=tolower(CompanyName) eq 'microsoft' this would get translated to the SQL WHERE LOWER(CompanyName) = 'microsoft'.
  • Added support for the toupper() function in a $filter query. e.g. $filter=toupper(CompanyName) eq 'MICROSOFT' this would get translated to the SQL WHERE UPPER(CompanyName) = 'MICROSOFT'.
Advertisements

Net.Http.WebApi.OData 1.0.2 Released

The OData parsing library which we spun off in MicroLite.Extensions.WebApi version 3.0.1 has been updated with a number of enhancements.

  • We now throw an exception for any unknown query options which are prefixed $.
  • We now throw an exception for any unsupported query options (a valid query option which has not been set via the ODataValidationSettings.AllowedQueryOptions property) when validating ODataQueryOptions.
  • We have added validation support for function calls in the $filter query option, this can be managed via the ODataValidationSettings.AllowedFunctions property.
  • Added support for the tolower() function in a $filter query. e.g. $filter=tolower(CompanyName) eq 'microsoft'
  • Added support for the toupper() function in a $filter query. e.g. $filter=toupper(CompanyName) eq 'MICROSOFT'