Devart.Data.PostgreSql.EFCore 8.4.190

Prefix Reserved
.NET 6.0 This package targets .NET 6.0. The package is compatible with this framework or higher. .NET Standard 1.3 This package targets .NET Standard 1.3. The package is compatible with this framework or higher.
There is a newer version of this package available.
See the version list below for details. 
dotnet add package Devart.Data.PostgreSql.EFCore --version 8.4.190                

                    
                

            
NuGet\Install-Package Devart.Data.PostgreSql.EFCore -Version 8.4.190
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package. 
<PackageReference Include="Devart.Data.PostgreSql.EFCore" Version="8.4.190" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add Devart.Data.PostgreSql.EFCore --version 8.4.190                

                    
                

            
#r "nuget: Devart.Data.PostgreSql.EFCore, 8.4.190"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package. 
// Install Devart.Data.PostgreSql.EFCore as a Cake Addin
#addin nuget:?package=Devart.Data.PostgreSql.EFCore&version=8.4.190

// Install Devart.Data.PostgreSql.EFCore as a Cake Tool
#tool nuget:?package=Devart.Data.PostgreSql.EFCore&version=8.4.190

dotConnect for PostgreSQL

dotConnect for PostgreSQL is a high-performance ORM enabled data provider for PostgreSQL that builds on ADO.NET technology.

The provider works with .NET Frameworks 2.0+, .NET Core 1.0+, .NET 5+. The product is compatible with ADO.NET Entity Framework (EF) Core.

It supports a wide range of PostgreSQL-specific features, such as secure SSL and SSH connections, PostgreSQL notifications, PostgreSQL bulk data loading, GEOMETRY, PostgreSQL ARRAY types, and others.

More information at dotConnect for PostgreSQL.

Compatibility

The following table show which version of this package to use with which version of frameworks.

Frameworks Version support
Entity Framework Core 6, 5, 3, 1
.NET 9, 8, 7, 6, 5
.NET Core 3, 2, 1
.NET Framework 4.8, 4.7, 4.6

More information here

Installation

For projects, using Entity Framework Core 1, 3, 5, 6 with PostgreSQL, install this package. Execute the following command in the Package Manager Console:

Install-Package Devart.Data.PostgreSql.EFCore

For projects, using Entity Framework Core 1.1, for which you use database-first approach and generate an Entity Framework Core mapping via the Scaffold-DbContext command of Package Manager Console, you need to install the Devart.Data.PostgreSql.EFCore.Design package.

For projects that require integration with Entity Framework 6.4 (EF6), use the Devart.Data.PostgreSql.EF6 package.

There also are Visual Studio extensions for earlier Visual Studio versions. If you use some other tool than Visual Studio, you can get NuGet packages with the nuget.exe console tool.

License

dotConnect for PostgreSQL is available in several editions. See pricing options for ordering.

To activate your license, please download dotConnect for PostgreSQL from our website. This installer generates the trial key files required for using this package on a trial basis.

Usage

This snippet directly configures a PostgreSQL database connection for an Entity Framework Core DbContext using a connection string.

public class MyDbContext : DbContext {
 
  protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) {

     optionsBuilder.UsePostgreSql(@"UserId=postgres;Password=postgres;Host=127.0.0.1;Port=5432;Database=test;Schema=pg_catalog;");
  } 
}

Configuration Using PostgreSqlConnection Instance

using Devart.Data.PostgreSql;
...

public class MyDbContext : DbContext {
 
  protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) {

     var connection = new PostgreSqlConnection();
     connection.Host = "127.0.0.1";
     connection.Port = 5432;
     connection.UserId = "postgres";
     connection.Password = "postgres";
     connection.Database = "test";
     connection.Schema = "pg_catalog";
     optionsBuilder.UsePostgreSql(connection);
  } 
}
ASP.NET Core and Blazor

Configuration File (appsettings.json):

{
  "ConnectionStrings": {
    "DefaultConnection": "UserId=postgres;Password=postgres;Host=127.0.0.1;Port=5432;Database=test;Schema=pg_catalog;"
   }
}

DbContext Configuration:

public class MyDbContext : DbContext {
 
  protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) {

    IConfigurationBuilder builder = new ConfigurationBuilder().AddJsonFile("appsettings.json");
    IConfiguration configuration = builder.Build();
    optionsBuilder.UsePostgreSql(configuration.GetConnectionString("DefaultConnection"));
  } 
}

For more information about secure connections using SSL or SSH connections read at out documentation.

Key Features

  • Easy Connection: Allows your .NET application to work with PostgreSQL data.
  • ASP.NET Core: Supports ASP.NET Core Identity.
  • Performance: Uses many PostgreSQL-specific performance features & optimizations to ensure the highest performance.
  • Monitoring: Allows per-component tracing of database events with a free dbMonitor application.
  • Security: Supports various encryption ciphers, SSL and SSH connections, etc.
  • Support and Updates: Enjoy dedicated support team for prompt issue resolution and regular updates to keep your software running smoothly and securely.

Support Area

More Resources

Product Compatible and additional computed target framework versions.
.NET net5.0 was computed.  net5.0-windows was computed.  net6.0 is compatible.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 was computed.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed. 
.NET Core netcoreapp1.0 was computed.  netcoreapp1.1 was computed.  netcoreapp2.0 was computed.  netcoreapp2.1 was computed.  netcoreapp2.2 was computed.  netcoreapp3.0 was computed.  netcoreapp3.1 was computed. 
.NET Standard netstandard1.3 is compatible.  netstandard1.4 was computed.  netstandard1.5 was computed.  netstandard1.6 was computed.  netstandard2.0 is compatible.  netstandard2.1 is compatible. 
.NET Framework net46 was computed.  net461 was computed.  net462 was computed.  net463 was computed.  net47 was computed.  net471 was computed.  net472 was computed.  net48 was computed.  net481 was computed. 
MonoAndroid monoandroid was computed. 
MonoMac monomac was computed. 
MonoTouch monotouch was computed. 
Tizen tizen30 was computed.  tizen40 was computed.  tizen60 was computed. 
Universal Windows Platform uap was computed.  uap10.0 was computed. 
Xamarin.iOS xamarinios was computed. 
Xamarin.Mac xamarinmac was computed. 
Xamarin.TVOS xamarintvos was computed. 
Xamarin.WatchOS xamarinwatchos was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (2)

Showing the top 2 NuGet packages that depend on Devart.Data.PostgreSql.EFCore:

Package Downloads
Devart.Data.PostgreSql.EFCore.Design

dotConnect for PostgreSQL is a high-performance ORM enabled data provider for PostgreSQL that builds on ADO.NET technology. The provider works with .NET Frameworks 2.0+, .NET Core 1.0+, .NET 5+. It supports a wide range of PostgreSQL-specific features, such as secure SSL and SSH connections, PostgreSQL notifications, PostgreSQL bulk data loading, GEOMETRY, PostgreSQL ARRAY types, and others.a More information at https://www.devart.com/dotconnect/postgresql/ License dotConnect for PostgreSQL is available in several editions https://www.devart.com/dotconnect/postgresql/ordering.html To activate your license, please download dotConnect for PostgreSQL from our website https://www.devart.com/dotconnect/postgresql/download.html This installer generates the trial key files required for using this package on a trial basis. Key Features * Easy Connection: Allows your application to work with PostgreSQL. * ASP.NET Core: Supports ASP.NET Core Identity. * Performance: Uses many PostgreSQL-specific performance features & optimizations to ensure the highest performance. * Monitoring: Allows per-component tracing of database events with a free dbMonitor application. * Security: Supports various encryption ciphers, SSL and SSH connections, etc. * Support and updates: Enjoy dedicated support team for prompt issue resolution and regular updates to keep your software running smoothly and securely.
Devart.Data.PostgreSql.EFCore.NetTopologySuite

dotConnect for PostgreSQL is a high-performance ORM enabled data provider for PostgreSQL that builds on ADO.NET technology. The provider works with .NET Frameworks 2.0+, .NET Core 1.0+, .NET 5+. It supports a wide range of PostgreSQL-specific features, such as secure SSL and SSH connections, PostgreSQL notifications, PostgreSQL bulk data loading, GEOMETRY, PostgreSQL ARRAY types, and others.a More information at https://www.devart.com/dotconnect/postgresql/ License dotConnect for PostgreSQL is available in several editions https://www.devart.com/dotconnect/postgresql/ordering.html To activate your license, please download dotConnect for PostgreSQL from our website https://www.devart.com/dotconnect/postgresql/download.html This installer generates the trial key files required for using this package on a trial basis. Key Features * Easy Connection: Allows your application to work with PostgreSQL. * ASP.NET Core: Supports ASP.NET Core Identity. * Performance: Uses many PostgreSQL-specific performance features & optimizations to ensure the highest performance. * Monitoring: Allows per-component tracing of database events with a free dbMonitor application. * Security: Supports various encryption ciphers, SSL and SSH connections, etc. * Support and updates: Enjoy dedicated support team for prompt issue resolution and regular updates to keep your software running smoothly and securely.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
8.4.190.9 45 12/27/2024
8.4.190.8 36 12/27/2024
8.4.190.7 37 12/27/2024
8.4.190 37 12/27/2024
8.3.105.8 486 11/13/2024
8.3.105.7 96 11/13/2024
8.3.105 412 11/13/2024
8.3.104.8 101 11/8/2024
8.3.104.7 99 11/8/2024
8.3.104 148 11/8/2024
8.3.21.8 10,331 6/6/2024
8.3.21.7 145 6/6/2024
8.3.21 432 6/6/2024
8.3.20.8 2,522 5/30/2024
8.3.20.7 125 5/30/2024
8.3.20 190 5/30/2024
8.3.10.8 7,463 1/18/2024
8.3.10.7 162 1/18/2024
8.3.10 479 1/18/2024
8.2.0.7 1,551 11/17/2023
8.2.0 846 11/17/2023
8.1.151.7 5,569 6/7/2023
8.1.151 5,646 6/7/2023
8.1.134.7 1,099 3/4/2023
8.1.134 1,947 3/4/2023
8.0.0 29,931 7/1/2022
7.24.2066 19,236 1/26/2022
7.23.2042 2,707 12/21/2021
7.22.2014 25,268 11/9/2021
7.21.2001 2,222 10/21/2021
7.21.1985 2,110 9/28/2021
7.20.1944 3,491 7/30/2021
7.20.1930 1,605 7/8/2021
7.20.1905 1,817 6/3/2021
7.20.1866 4,699 4/9/2021
7.20.1860 1,513 4/1/2021
7.20.1836 2,133 2/18/2021
7.20.1812 13,096 1/14/2021
7.20.1792 2,080 12/17/2020
7.20.1782 1,788 12/3/2020
7.19.1759 42,085 10/29/2020
7.18.1739 4,332 10/1/2020
7.18.1730 3,403 9/17/2020
7.17.1696 5,560 7/30/2020
7.17.1686 2,873 7/16/2020
7.17.1666 2,991 6/17/2020
7.17.1612 18,345 4/2/2020
7.17.1583 8,427 2/20/2020
7.16.1541 11,697 12/23/2019
7.15.1519 5,210 11/21/2019
7.15.1504 2,135 10/31/2019
7.15.1499 2,349 10/24/2019
7.14.1470 5,859 9/13/2019
7.13.1437 2,744 7/25/2019
7.13.1422 1,960 7/4/2019
7.13.1402 3,121 6/6/2019
7.13.1366 2,328 4/12/2019
7.12.1357 1,957 3/28/2019
7.12.1328 1,945 2/14/2019
7.12.1307 7,457 1/10/2019
7.11.1278 2,043 11/29/2018
7.11.1253 2,184 10/25/2018
7.11.1229 3,074 9/20/2018
7.11.1216 2,003 8/31/2018
7.11.1202 3,419 8/10/2018
7.11.1190 2,008 7/19/2018
7.11.1172 2,204 6/22/2018
7.10.1152 2,343 5/25/2018
7.10.1134 7,851 4/27/2018
7.10.1115 2,305 3/30/2018
7.10.1086 2,259 2/15/2018
7.10.1061 2,189 1/11/2018
7.10.1031 2,036 11/23/2017
7.10.1013 12,798 10/30/2017
7.9.980 3,093 9/7/2017
7.9.946 1,956 7/14/2017
7.9.931 1,926 6/23/2017
7.9.912 2,157 5/25/2017

https://www.devart.com/dotconnect/postgresql/revision_history.html