You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hello,
I'm querying a JsonDocument mapped on a jsonb column and I need to check a DateTimeOffset:
this is the exception I get:
Microsoft.AspNetCore.Server.Kestrel[13]
Connection id "0HN33KJJH09DE", Request id "0HN33KJJH09DE:00000002": An unhandled exception was thrown by the application.
System.InvalidCastException: Can't write CLR type System.DateTimeOffset with handler type TextHandler
at Npgsql.Internal.TypeHandlers.TextHandler.ValidateObjectAndGetLength(Object value, NpgsqlLengthCache& lengthCache, NpgsqlParameter parameter)
at Npgsql.NpgsqlParameter.ValidateAndGetLength()
at Npgsql.NpgsqlParameterCollection.ValidateAndBind(ConnectorTypeMapper typeMapper)
at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.InitializeReader(Enumerator enumerator)
at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at ACMe.Jdes.EbsService.Service.Repositories.BigTreeRepository.GetEbsTree(IEnumerable`1 filters, IEnumerable`1 sorters, Int32 skip, Int32 take)
at ACMe.Jdes.EbsService.Controllers.EbsController.GetAllTreeTable(String query, String sort) in /app/microservices/ebs-service/ACMe.Jdes.EbsService/Controllers/EbsController.cs:line 139
at lambda_method76(Closure , Object , Object[] )
at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync()
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync()
--- End of stack trace from previous location ---
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync()
--- End of stack trace from previous location ---
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeFilterPipelineAsync>g__Awaited|20_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Logged|17_1(ResourceInvoker invoker)
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Logged|17_1(ResourceInvoker invoker)
at Microsoft.AspNetCore.Routing.EndpointMiddleware.<Invoke>g__AwaitRequestTask|6_0(Endpoint endpoint, Task requestTask, ILogger logger)
at Microsoft.AspNetCore.Authorization.Policy.AuthorizationMiddlewareResultHandler.HandleAsync(RequestDelegate next, HttpContext context, AuthorizationPolicy policy, PolicyAuthorizationResult authorizeResult)
at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context)
at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context)
at Microsoft.AspNetCore.Localization.RequestLocalizationMiddleware.Invoke(HttpContext context)
at Microsoft.AspNetCore.Diagnostics.StatusCodePagesMiddleware.Invoke(HttpContext context)
at Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpProtocol.ProcessRequests[TContext](IHttpApplication`1 application)
My code: context.Components.Where(x => x.CustomFieldsAsDocument.RootElement.GetProperty(property).GetDateTimeOffset() >= filter.Value);
where filter.Value is of type DateTimeOffset and property is of type string
The query generated:
SELECT ****** (censored)
FROM "Ebs"."BigTree" AS b
WHERE (b."CustomFields"->>@__property_1 >= @__filter_Value_2)
ORDER BY b."Path"
EDIT:
I'm using Npgsql.EntityFrameworkCore.PostgreSQL 6.0.22 and Microsoft.EntityFrameworkCore 6.0.29
The text was updated successfully, but these errors were encountered:
Hello,
I'm querying a JsonDocument mapped on a jsonb column and I need to check a DateTimeOffset:
this is the exception I get:
My code:
context.Components.Where(x => x.CustomFieldsAsDocument.RootElement.GetProperty(property).GetDateTimeOffset() >= filter.Value);
where filter.Value is of type DateTimeOffset and property is of type string
The query generated:
EDIT:
I'm using Npgsql.EntityFrameworkCore.PostgreSQL 6.0.22 and Microsoft.EntityFrameworkCore 6.0.29
The text was updated successfully, but these errors were encountered: