Replies: 1 comment 2 replies
-
I think that error means exactly what it says it does and has nothing to do with CTEs. At the moment, Marten is assuming that the top level document has some kind of identity, and it can't figure out what that would be for |
Beta Was this translation helpful? Give feedback.
2 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Howdy and thanks for all the hard work on Marten.
I am resurrecting (somewhat dormant) Marten project and just upgraded to latest. All custom sql queries in the project that uses a CTE are broken with an exception like below...
Could not determine an 'id/Id' field or property for requested document type Api.Orders.Application.Handlers.GetOrganizationStatsQueryHandler+GetOrganizationStatsQueryResultSummaryPoco
The problem might be this line which assumes every custom sql query starts with a
SELECT
. Queries using CTEs naturally start withWITH
which fail the check and lead down the known / mapped T route.Is using CTEs in custom queries no longer allowed?
Thanks
Beta Was this translation helpful? Give feedback.
All reactions