dotConnect for PostgreSQL 5.50.228

dotConnect for PostgreSQL 5.50.228  offers users with an easy to use yet effective tool which enables you to present a complete solution for developing PostgreSQL-based database applications. As part of the Devart database application development framework, dotConnect for PostgreSQL offers both high performance native connectivity to the PostgreSQL database and a number of innovative development tools and technologies. 

1. General usability
   • Direct access to server data
   • Real RAD for database applications
   • Fully compliant with ADO.NET
   • 100% managed code
   • Highly usable design time support
   • Easy to deploy
2. Network and connectivity
   • Doesn't require PostgreSQL client library and uses PostgreSQL protocol directly
   • Both connected and disconnected data access models
   • Unicode connections
   • SSL connection to PostgreSQL server
3. Compatibility
   • Full support of the latest versions of PostgreSQL
   • Full support for x64 architecture
   • .NET Compact Framework support
   • Mono Framework support
   • Microsoft Visual Studio 2005, 2008, and 2010 support
   • CodeGear Delphi 2007 support
   • Embarcadero Delphi Prism support
   • SQL Server 2005 and 2008 Business Intelligence Solutions support
4. PostgreSQL technology support
   • All PostgreSQL data types support, including Composite types
   • Stored procedures support
   • Returning result sets from stored procedures
   • PgSqlDump component to store a database or its parts as a script and then restore it
   • PgSqlLoader component for fast loading data
   • PgSqlAlerter component to manage PostgreSQL notifications with LISTEN and NOTIFY commands
   • Fill DataSet with multiple query
   • Large objects support
   • PostgreSQL ARRAY data type support with the PgSqlArray class
5. Performance
   • High overall performance
   • Intelligent fetch block size control
   • Advanced connection pooling
   • High performance batch processing
6. ADO.NET technology support
   • Full support for ADO.NET Entity Framework v1 and v4
   • Server enumeration
   • Batch update support
   • Extended metadata information retrieval
   • Advanced CommandBuilder component with automatic refresh SQL
   • Enhanced pooling control through connection string
   • Connection string builder
   • Provider factory for generating key data access classes
   • Asynchronous command execution
   • Provider-specific types support
   • Password change API
   • Database Change Notification Support
   • Possibility to retrieve OID values
7. ADO.NET Entity Framework
   • Conceptual approach to enterprise development
   • High performance
   • Wide support for LINQ to Entities
   • Wide support for EntitySQL
   • Full CRUD (Create, Retrieve, Update, Delete) support
   • Wide support for server data types
   • Change tracking support
   • Object data caching
   • Inheritance mapping support (TPH, TPT, and TPCT models)
   • Capability to use stored procedures when manipulating data
   • Stored procedure import support
   • Ability to build database-independent applications
   • Visual Studio EDM Wizard support
   • Reverse engineering of database objects to entity model
   • Visual model creation and code generation with Entity Developer
   • • Update Model From Database functionality for Entity Developer
     • Update To Database with Mapping Synchronization functionality for Entity Developer
   • Illustrated tutorial to get started with Entity Framework in 5 minutes
8. LinqConnect (formerly known as LINQ to PostgreSQL)
   • Easy to use
   • High performance
   • Interchangeable with Microsoft LINQ to SQL
   • Plain CLR classes used (no need to use a common base class)
   • Full CRUD (Create, Retrieve, Update, Delete) support
   • Ability to execute DML statements in batches on SubmitChanges 
   • Complex type support
   • PLINQ support (connection manager redesigned for thread safety) 
   • Support for different configurable algorithms for primary key generation
   • Inheritance mapping support (Table Per Hierarchy and Table Per Type) 
   • Support of Visual Studio Debugger Visualizer for the DataQuery objects 
   • ASP.NET Dynamic Data support with ASP.NET Dynamic Data project templates 
   • Automatic configurable compiled query caching
   • Change tracking support
   • Object data caching
   • Data binding support
   • Wide support for LINQ capabilities
   • Wide support for server data types
   • Load on demand (lazy load)
   • Database transactions support
   • Server-independent interface
   • Visual model creation and code generation with Entity Developer
   • • Update Model From Database functionality for Entity Developer
     • Update To Database with Mapping Synchronization functionality for Entity Developer
   • Illustrated tutorial to get started with LinqConnect in 5 minutes
9. Extended data access technologies and functionality
   • Powerful PgSqlDataTable component for manipulating individual tables or query result
   • NonBlocking mode allows fetching data asynchronously in the background
   • On-demand data fetch for data-bound controls
   • Paginal access to query result
   • Server side master-detail relation based on queries
   • Ability to refresh individual records in PgSqlDataTable component
   • Support for Enterprise Library Data Access Application Block (DAAB)
   • Object-oriented building of SELECT statements
   • Extended warning and error information retrieval
   • Extended interface for processing execution exceptions
   • PgSqlDataAdapter.Fill method with sequential fetch support
   • Ability to defer fetching of some columns in a resultset
   • Named parameters support
10. WinForms-specific features
    • Flexible data binding with DataLink component
    • InterForm technology for cross-form components cooperation
    • Global position synchronization within a data source
11. ASP.NET-specific features
    • ASP.NET data providers: Membership, Role, Session State, Profile, Personalization, Site Map, Web Event
    • PgSqlDataSource web component
    • PgSqlCacheDependency component to control Cache item dependencies in ASP.NET applications
12. Script execution
    • Advanced script execution features with PgSqlScript component
    • Support for executing individual statements in scripts
    • Support for executing huge scripts stored in files with dynamic loading
13. SQL execution monitoring
    • Extended SQL tracing capabilities with PgSqlMonitor component
    • Support for dbMonitor utility for advanced tracing analysis and control
    • Per-component SQL tracing
    • Optional log output to IDE toolwindows
14. Design-time enhancements
    • Automatic component registration in toolbox
    • Advanced integration with Visual Studio 2005, 2008, and 2010, including Server Explorer, Data Source wizard, TableAdapter configuration, Query Builder and configuring web component PgSqlDataSource
    • DataSet Wizard to create and edit typed PostgreSQL-oriented datasets
    • DataSet Manager to list and bind datasets in the project
    • DataSet Editor to edit dataset contents
    • Advanced design-time component and property editors
    • IntelliSense descriptions for dotConnect for PostgreSQL classes
    • Easy migration from ODBC and OLE DB .NET Data Providers with Migration Wizard
    • Syntax highlighting in design-time editors
    • TableMappings editor
    • Convenient instant data preview and management in design time
15. Product clarity
    • Complete documentation sets integrated into Visual Studio and CodeGear Delphi
    • Integration with Visual Studio and MSDN help collections
    • Documentation available as a standalone chm file
    • A large amount of helpful demos in C#, VB, C++, and Delphi

• • The bug with licensing WinForms projects in Delphi Prism is fixed
  • The bug with workability of command timeout for prepared commands is fixed
  • The bug with assigning the UnpreparedExecute option from connection string to the command is fixed
• LinqConnect (formerly known as LINQ to PostgreSQL)
• • The bug with ordering queries with eager loading options is fixed
  • The bug with caching queries performed via the ExecuteQuery method is fixed
  • The bug with .Equals(null) conditions in LINQ queries is fixed
• Entity Developer
• • Disabling facets that are not applicable to the current field type is implemented (LinqConnect models)
  • Default behaviour changed: now the Update To Database Wizard does not drop foreign keys of a table if the 'master' one is not represented in the LinqConnect model
  • The bug with saving a new solution provided that the Visual Studio option for 'Projects and Solutions -> Save new projects when created' is unchecked is fixed
  • The bug with pluralization algorithm is fixed when Naming rules are defined
  • The 'The given key was not present in the dictionary' error in the Entity Developer version integrated into Visual Studio 2010 is fixed
  • The bug with default mapping for PostgreSQL UUID columns in LinqConnect models is fixed
  • The bug with incorrect determining of association multiplicity (redundant 'many-to-many') in LinqConnect models is fixed
  • The bug with setting Extended Properties for RelationProperty is fixed
• Entity Framework support
• • The bug with executing Function Imports with enabled BatchUpdates is fixed
  • The bug with Entity Data Model Wizard when creating a model is fixed
  • The bug when PgSqlEntityProviderWorkaroundConfig.IgnoreSchemaName does not affect stored procedures is fixed

• PostgreSQL Compatibility
• • dotConnect for PostgreSQL supports PostgreSQL server since 7.1 version to 9.0, EnterpriseDB, Pervasive Postgres SQL servers.
• Framework Compatibility
• • Microsoft .NET Framework 2.0, 3.0, 3.5, 4.0
  • Microsoft .NET Compact Framework 2.0 and above
  • Mono version 2.0 and above
• IDE compatibility
• • Microsoft Visual Studio 2010
  • Microsoft Visual Studio 2008
  • Microsoft Visual Studio 2005
  • Embarcadero Delphi Prism
  • CodeGear RAD Studio 2007
• Devart data providers compatibility
• • Since Devart data providers use a common assembly (Devart.Data.dll), it is necessary to make sure that all installed data providers are compatible.