AspNetCoreOData

AspNetCoreOData copied to clipboard

Strange time zone propagation in the filter

3

**Current** Sample GET url http://localhost:51994/time-tracks?$filter=((dateFrom+eq+2024-04-17T09:45:00%2B02:00))&$orderby=dateFrom+desc&$skip=0&$top=25 contains time 2024-04-17T9:45:00.0000000+02:00 Produces SQL query that contains "2024-04-17T11:45:00.0000000+02:00". So it get's treated as if the date in the filter was UTC time. The fault...

cts-tradeit

Custom FilterBinder doesn't work on actions with querying via ODataQueryOptionParser

7

I'm implementing odata api using ASP.NET Core OData 8.2.3 and I'm trying to make custom functions for $filter clause as described here https://devblogs.microsoft.com/odata/customizing-filter-for-spatial-data-in-asp-net-core-odata-8/ I created CustomFilterBinder and injected it exactly...

a-ney

NullReference exception generated when using FilterClause.ApplyTo method with open properties in the filter query

2

**Assemblies affected** ASP.NET Core OData 8.2.5 **Describe the bug** FilterClause.ApplyTo method generates a NullReferenceException if a open/dynamic property is used in the filter query. The exception happens in QueryBinder.BindPropertyAccessExpression method....

vibatra

$apply is not showing meta data info when I use IActionResult

24

I have Get action in controller: ``` public IActionResult Get(ODataQueryOptions queryOptions, CancellationToken cancellationToken) { var query = MyDBContext.Set().ToList(); return Ok(query); } ``` When I send this query: Student?$apply=aggregate($count as OrderCount)...

komdil

Allow casting Edm.Untyped to a primitive type for `$filter`ing when the other operand is also a primitive

5

**Assemblies affected** ASP.NET Core OData 8.2.5 **Describe the bug** Hi, I encounter an issue with an entity in which a property can be of several primitive types : - `bool`...

orty

WebApiAssembliesResolver class missing causing slow model build

2

**Assemblies affected** ASP.NET Core OData 8.x **Describe the bug** ASP.NET Core OData 7.x had a special class `WebApiAssembliesResolver` that used to access only assemblies available to the application. Now ASP.NET...

sherlock1982

Cannot avoid using synchronous calls in OData with entity framework

6

**Assemblies affected** Microsoft.AspNetCore.OData 8.2.5 (but probably all of them **Describe the bug** When using an IQueryable generated via entity framework the default behaviour is to have synchronous calls to the...

Shiney

Instance Annotations for properties with $select query option

1

**Describe the bug** I would like to add **instance annotation** to a property (`OwnerId`) by including an additional property (`OwnerIdName`) as its value. This setup works as expected without using...

robertrutkowski

How do I use the month function of date type in a group query

4

**Assemblies affected** .NET 8.0 Microsoft.AspNetCore.OData 8.2.5 **Describe the bug** ?filter=month(deliveryDate) eq 3 is good working ?apply=groupby((month(deliveryDate)), aggregate($count as TotalCount)) Throw exception **Data Model** public DateTime DeliveryDate { get; set; }...

kingling-abb

It's still not clear how to filter by enum property

12

I know that in previous versions of OData we could filter a collection using the numeric representation of an enum, like in this example: ``` // assuming that the object...

TooMuchLagWillKillYou