Issue with BulkMerge and IsReadOnly in PostgreSQL

[hackwithbalaji]

Description

Hi Team,

We are encountering an issue while using BulkMerge with IncludeGraphOperationBuilder in PostgreSQL. The configuration bulk.IsReadOnly = true is supposed to prevent updates for an entity, and this functionality works as expected in MSSQL. However, in PostgreSQL, it does not behave correctly and upserts are still being attempted.

Further technical details

• EF Core version: 9.0.0
• EF Extensions version: 9.103.6.3

Kindly investigate this issue and provide a fix or suggestion. Let me know if further details or testing are needed.

@JonathanMagnan

Thanks
--Balaji

[JonathanMagnan]

Hello @hackwithbalaji ,

Unfortunately, that option is only supported for SQL Server at this moment.

We will add a text for this option and probably an error message to give more indication about it.

Best Regards,

Jon

[hackwithbalaji]

Thanks @JonathanMagnan for the clarification!!

As we are migrating from MSSQL to PostgreSQL, it would be helpful if you could provide a comprehensive list of features and options that are supported in MSSQL but not in PostgreSQL. I couldn't find anything in the documentation.

Currently, I am manually checking for compatibility in each module, which is both time-consuming and challenging. A documented list would help us plan effectively.

[JonathanMagnan]

Hello @hackwithbalaji ,

I'm dedicating the whole of December month to improving the documentation (one of the reasons we refuse at this moment a lot of new features/requests as otherwise I'm only able to do the code review of my developers).

We will surely try our best to add more details about all our options.

Best Regards,

Jon