Devart/Devart.Data.PostgreSql.EFCorev9.1.33.10

The NuGet package initiates the retrieval of an activation key from the Devart website. This key is required to activate the product for a free trial.

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.

Related Packages

• Devart.Data.PostgreSql
• Devart.Data.PostgreSql.EF6

Support Area

• Support
• Documentation
• Request form
• Feedback page
• Product history

More Resources

• Blog about dotConnect
• Devart Website