Devart dotConnect for PostgreSQL v7.13.1402 Professional
Devart dotConnect for PostgreSQL v7.13.1402 Professional
dotConnect for PostgreSQL, formerly known as PostgreSQLDirect .NET, is an enhanced ORM enabled data provider for PostgreSQL that builds on ADO.NET technology to present a complete solution for developing PostgreSQL-based database applications. With support for Entity Framework, NHibernate, and LinqConnect ORMs, it introduces new approaches for designing application architecture, boosts productivity, and leverages database applications.
Fast and Advanced ADO.NET Provider
dotConnect for PostgreSQL offers both high performance connectivity to the PostgreSQL database and a number of innovative development tools and technologies. It support a wide range of PostgreSQL-specific features, such as secure SSL connections, PostgreSQL notifications, PostgreSQL bulk data loading, GEOMETRY, PostgreSQL ARRAY types, and others.
RAD Approach
dotConnect for PostgreSQL provides a vast number of GUI tools that increase your productivity. It integrates into Visual Studio Server Explorer and other tools , and provides advanced visual component editors to simplify component tweaking. DataSet tools, such as DataSet Wizard, DataSet Editor , DataSet Manager , provide you an easy way to create and edit typed and untyped DataSets.
ORM Solutions
dotConnect for PostgreSQL offers enhanced ORM support with a bundled visual designer for ORM models - Entity Developer. dotConnect for PostgreSQL supports ADO.NET Entity Framework, NHibernate, and LinqConnect (formerly known as LINQ to PostgreSQL) - our own ORM solution, closely compatible to Microsoft LINQ to SQL, while extending its functionality with its own features.
Features
Direct Mode
Allows your application to work with PostgreSQL directly via TCP/IP without involving PostgreSQL Client software.
ASP.NET
Implements Role, Session State, Membership, Profile, Site Map, and other ASP 2.0 providers.
Enterprise Library
Can be used in conjunction with Microsoft Enterprise Library Data Access Application Block .
BIS
Enables Integration Services to export and import data to/from PostgreSQL servers.
Monitoring
Monitoring
Allows per-component tracing of database events with a free dbMonitor application.
Compatibility
Supports PostgreSQL servers from 7.1 and higher on .NET and .NET Compact Framework 2.0 and higher, .NET Core and Mono.
7.13.1402 06-Jun-19
Deprecated design-time Synchronous API calls are no longer used with Visual Studio 2019 and Visual Studio 2017
The behaviour is changed: now PgSqlDataAdapter performs inserts in a batch with protocol 3 when the UpdateBatchSize property is used and UnpreparedExecute is true for InsertCommand
The bug with missing schema name in a function return type when the function is backed up via PgSqlDump.Backup is fixed
The bug with creating foreign key constraints before primary key constraints in a PgSqlDump.Backup result script is fixed
The bug with adding timestamp(6) instead of timestamp to a PgSqlDump.Backup result script is fixed
The bug with connecting to a PostgreSQL server on Google Cloud Platform is fixed
LinqConnect (formerly known as LINQ to PostgreSQL)
The bug with running stored procedure in PostgreSQL Server 11 or higher is fixed
The bug with executing incorrect SQL request (cached during one of the previous calls), when a variable initialized with an empty collection participates in LINQ query, is fixed
Entity Framework support
Entity Framework Core 2.2.4 is supported
The bug with closing database connection by context.Dispose() in the scope of a distributed transaction in EF Core 2 is fixed
The bug with using a value converter, when the .NET data type remains the same, within the WHERE clause in EF Core 2 is fixed
Deprecated design-time Synchronous API calls are no longer used with Visual Studio 2019 and Visual Studio 2017
The behaviour is changed: now PgSqlDataAdapter performs inserts in a batch with protocol 3 when the UpdateBatchSize property is used and UnpreparedExecute is true for InsertCommand
The bug with missing schema name in a function return type when the function is backed up via PgSqlDump.Backup is fixed
The bug with creating foreign key constraints before primary key constraints in a PgSqlDump.Backup result script is fixed
The bug with adding timestamp(6) instead of timestamp to a PgSqlDump.Backup result script is fixed
The bug with connecting to a PostgreSQL server on Google Cloud Platform is fixed
LinqConnect (formerly known as LINQ to PostgreSQL)
The bug with running stored procedure in PostgreSQL Server 11 or higher is fixed
The bug with executing incorrect SQL request (cached during one of the previous calls), when a variable initialized with an empty collection participates in LINQ query, is fixed
Entity Framework support
Entity Framework Core 2.2.4 is supported
The bug with closing database connection by context.Dispose() in the scope of a distributed transaction in EF Core 2 is fixed
The bug with using a value converter, when the .NET data type remains the same, within the WHERE clause in EF Core 2 is fixed
Only for V.I.P Warning! You are not allowed to view this text.