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 SQLWHERE 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 SQLWHERE UPPER(CompanyName) = 'MICROSOFT'
.