Postgresql Integrations

[necipsunmaz]

I use "Npgsql.EntityFrameworkCore.PostgreSQL" with EF Core in the project. Does your library support PostgreSQL? If not, do you have a plan to do this later?

[borisdj]

At the moment it supports MsSQL only.
I did have in mind to add this feature, just didn't catch time to do it so far.
Currently I can't put any specific time frame for PostgreSQL options, but will look into it soon.

[necipsunmaz]

Thanks for information.

[collinbarrett]

Looks like a great library! I am also not using SQL Server, though. I'd recommend making the db provider support more prominent on the README, as it is not immediately obvious to potential users that it only supports SQL Server.

[borisdj]

It is stated in the first paragraph:

Current version is using EF Core 3.1 and at the moment supports Microsoft SQL Server(2008+) and SQLite.

[richard-s-popov]

Still no news about support PostgreSQL?

[borisdj]

Not yet.
Have managed to extend it for SQLite recently.
PostgreSql maybe sometimes during next year.

[MaceWindu]

As workaround you can use linq2db BulkCopy functionality through EF.Core adapter

https://github.com/linq2db/linq2db/wiki/Bulk-Copy#postgresql-provider-specific-bulk-copy

[IvanAntipov]

EFCore.BuildExtension is a great library, unfortunately it doesn't support Postgres. You can use 'FlexLabs.Upsert' nuget as alternative for Postgres

[etiennecl]

Is this still in the roadmap? Anything I could do to help? I'm not an expert but I sure could give you a hand.

[borisdj]

Yes but still no timeframe.
There is one PR a few days ago in this direction: #434

Here are some links (Docs) that I've found when did the research:

https://www.npgsql.org/doc/copy.html
https://www.postgresql.org/docs/9.2/static/sql-copy.html
npgsql/efcore.pg#113
__
https://www.bytefish.de/blog/postgresql_bulk_insert/
https://dba.stackexchange.com/questions/41059/optimizing-bulk-update-performance-in-postgresql
http://thebuild.com/blog/2016/01/14/doing-a-bulk-merge-in-postgresql-9-5/
https://www.alibabacloud.com/blog/how-does-postgresql-implement-batch-update-deletion-and-insertion_596030

https://stackoverflow.com/questions/30320418/insert-the-whole-value-of-datatable-bulk-into-postgresql-table
https://stackoverflow.com/questions/758945/whats-the-fastest-way-to-do-a-bulk-insert-into-postgres
https://stackoverflow.com/questions/5940225/fastest-way-of-inserting-in-entity-framework
https://stackoverflow.com/questions/43531602/bulk-update-in-entity-framework-core/43531693

[borisgr04]

Sí, pero aún sin plazo.
Hace unos días hay un RP en esta dirección: # 434

Aquí hay algunos enlaces (Documentos) que encontré cuando hice la investigación:

https://www.npgsql.org/doc/copy.html
https://www.postgresql.org/docs/9.2/static/sql-copy.html
npgsql / efcore.pg # 113
__
https: // www. bytefish.de/blog/postgresql_bulk_insert/
https://dba.stackexchange.com/questions/41059/optimizing-bulk-update-performance-in-postgresql
http://thebuild.com/blog/2016/01/14/doing -una-fusión-masiva-en-postgresql-9-5 /
https://www.alibabacloud.com/blog/how-does-postgresql-implement-batch-update-deletion-and-insertion_596030

https://stackoverflow.com/questions/30320418/insert-the-whole-value-of-datatable-bulk-into-postgresql-table
https://stackoverflow.com/questions/758945/whats-the-fastest-way -to-do-a-bulk-insert-into-postgres
https://stackoverflow.com/questions/5940225/fastest-way-of-inserting-in-entity-framework
https://stackoverflow.com/questions/43531602 / actualización-masiva-en-entidad-framework-core / 43531693

I want help. How?

[borisdj]

I started some work on this, made so far shell of methods and prof of concept for basic Insert.
Once I commit it, then next phase would be implementing each method.

[ahmeetarif]

WE ALL ARE WAITING FOR POSTGRESQL SUPPORT :)

[aktxyz]

+1

[douglasg14b]

This would be very nice to have, just switched to Postgres and was quite surprised when the queries stopped working :/

[trojanmartin]

I started some work on this, made so far shell of methods and prof of concept for basic Insert. Once I commit it, then next phase would be implementing each method.

Can u push that branch into repo? We will be happy to help with the implementation, if possible.

[borisdj]

PostgreSql adapter added with v6.0.4
Currently supported methods: Insert and Upsert.
Still initial faze so complex cases might give exceptions.

[borisdj]

PostgreSql now fully supported, Bulk and Batch ops, v6.0.5

[dimkadv2]

Hi!

sorry if I'm writing to the wrong thread

i faced the following problems while working PostgreSql:
when using json columns (in my case it's)

[Column(TypeName = "jsonb")]
public List<CatalogPathData> Catalogs { get; set; }

i have got error:

The CLR type Ocs.API.Infrastructure.ResponseData.CatalogPathData isn't natively supported by Npgsql or your PostgreSQL.
To use it with a PostgreSQL composite you need to specify DataTypeName or to map it, please refer to the documentation

and i have problems with enums:

    public enum ConditionType : byte
    {
        Regular,
        Sale,
        Unconditional
    }


    public ConditionType Condition { get; set; }

error:

A PostgreSQL type with the name condition_type was not found in the database

P.S. i'm using EFCore.NamingConventions package and EFCore 6

thank you in advance!

[bugrakosen]

Hi,

I'm facing the same issue as @dimkadv2 with enum types.

It seems @Hoffs solution did not change anything for my situation.

Do you have any suggestions for me?

[borisdj]

Enums should be fixed with v6.1.8

[Bouke]

How invasive is it to backport this to support EFCore 3.1? We are running on .NET Framework which is only supported by EFCore 3.1.

[borisdj]

Prior versions are not actively maintained.
In principle could be done, but has significant work.
Would be easier to 5 then to 3 since there were more code structure differences and also syntax and breaking changes from internal .Net methods.
There is separate branch for x3, if someone makes it and does a PR I could publish newer v3 nuget.