efcore.pg Expose PostgreSQL XML functions

From @roji on September 8, 2015 8:4

PostgreSQL supports xpath matching, which we can expose to the user when corresponding methods are used in the LINQ query. This would prevent the entire resultset from being pulled in to the client.

It may be a good idea to provide an opt-out for this in case there's trouble or client-side evaluation is preferred. At the query and model levels.

Copied from original issue: npgsql/npgsql#773

Apr 14 '16 12:04 roji

This has been around for a while. I'm going to take a run at for 2.2.0.

Jun 24 '18 02:06 austindrenski

It's been around for a while, but it hasn't ever been requested by an actual user :) I suspect that with xml going out of fashion hardly anyone needs this...

I'd suggest concentrating our efforts elsewhere until this gets some votes etc...

Jun 24 '18 06:06 roji

Possibly relevant:

https://github.com/aspnet/EntityFrameworkCore/issues/12795#issuecomment-414330525

Aug 20 '18 14:08 austindrenski

@roji Is there a way to access postgres XML functionality before this is implemented ?

Oct 14 '24 17:10 ahmednfwela

Yes, use SQL queryinghttps://learn.microsoft.com/en-us/ef/core/querying/sql-queries?tabs=sqlserver.

Oct 14 '24 21:10 roji