PostgreSQLDirect .NET is an enhanced data provider for PostgreSQL that builds on ADO.NET technology to present a complete solution for developing PostgreSQL-based database applications. As part of the Core Lab database application development framework, PostgreSQLDirect .NET offers both high performance native connectivity to the PostgreSQL database and a number of innovative development tools and technologies. PostgreSQLDirect .NET introduces new approaches for designing application architecture, boosts productivity, and leverages database application implementation. Related Products Advantages of PostgreSQLDirect .NET Wide Coverage of PostgreSQL Features By providing access to the most advanced database functionality, PostgreSQLDirect .NET allows developers to harness the full capabilities of the PostgreSQL server and optimize their database applications. PostgreSQLDirect .NET stands out as the set of components with the widest support of PostgreSQL functionality.

Optimized Code
The goal of PostgreSQLDirect .NET is to enable developers to write efficient and flexible database applications. The PostgreSQLDirect .NET assemblies are implemented using optimized code and advanced data access algorithms. Components undergo comprehensive performance tests and are designed to help you write thin and efficient product data access layers.

Comprehensive Support for ADO.NET Technology Features
PostgreSQLDirect .NET supports new ADO.NET features and technologies as soon as they are released. This includes base-class-based provider model, provider factories, connection string builder, metadata schemas, asynchronous commands, pooling enhancements, batch update support, provider-specific types, server enumeration, database change notification support and so on. PostgreSQLDirect .NET will continue supporting the newest standards and innovations of the .NET Framework.

Database Application Development Extensions
PostgreSQLDirect .NET has rich set of design time tools that leverage the development process greatly. Particularly, there are convenient design time component editors, wizards and managers for typed PostgreSQL-specific components, toolset for live data binding and much more. PostgreSQLDirect .NET integrates tightly with Visual Studio 2005/2008, Delphi, and SQL Server 2005 Business Intelligence Solutions.

Provider-Specific Technologies
PostgreSQLDirect .NET has extra components designed to simplify some tasks and support PostgreSQL-specific technologies. Particularly, PgSqlScript serves to execute series of SQL statements, PgSqlLoader serves to load external data into PostgreSQL databases, and PgSqlDump serves to backup or restore a whole database or its parts.

ADO.NET Entity Framework Support
ADO.NET Entity Framework is a conceptual approach to database application development with focus on objects instead of relational data. The flexible architecture of Entity Framework is made up of well-thought layers and modules. Entity Framework optimizes the development process with object-relational mapping, SQL-based entity query language, and LINQ.

PostgreSQLDirect .NET fully supports the Entity Framework Beta 3 capabilities, which allows you to base your object-oriented applications on PostgreSQL. PostgreSQLDirect .NET includes a wizard that helps you setup model relations, and a set of demos to use as a starting point. All standard Entity Framework samples can be easily ported to PostgreSQLDirect .NET.

Both Connected and Disconnected Models
PostgreSQLDirect .NET combines connected and disconnected data access models in single PgSqlDataTable component, which allows you to design more flexible application architecture and use full power of data binding.

Key Features

The following list describes the main features of PostgreSQLDirect .NET.

• Direct access to PostgreSQL server
• 100% managed code
• High performance
• Easy to deploy
• Supports the latest versions of PostgreSQL server
• All PostgreSQL data types support
• .NET Compact Framework support
• Entity Framework support
• Operates in both connected and disconnected models
• Powerful PgSqlDataTable component as all-in-one table data access solution
• Auxiliary components for SQL scripts and bulk data transfer
• Extra data binding capabilities
• Cross-form components cooperation
• Ability of monitoring query execution
• Licensed royalty-free per developer, per team, or per site

Detailed list »

Editions

PostgreSQLDirect .NET has four editions: Professional, Standard, Mobile, and Trial. The Standard Edition represents a fully-featured ADO.NET data provider with design time support and advanced classes. The Professional Edition adds more classes, tools, technologies, and integration capabilities. Mobile edition is equivalent to Standard edition for .NET Compact Framework. Trial edition corresponds to Professional with trial restrictions of the functionality.

* Trial version of the provider is a fully working version during 30 days period.

Compatibility

PostgreSQLDirect .NET supports PostgreSQL server since 7.1 version to 8.3, Pervasive Postgres SQL server. The provider works with .NET Framework 1.0, 1.1, 2.0, 3.0, 3.5, and .NET Compact Framework 1.1 and 2.0, and can be used with the following development environments:

Microsoft Visual Studio .NET 2008 Microsoft Visual Studio .NET 2005 Microsoft Visual Studio .NET 2003 Microsoft Visual Studio .NET 2002 Delphi for .NET and RAD Studio 2007 Turbo Delphi for .NET Professional Turbo C# Professional Borland Developer Studio 2006 Borland Developer Studio 2005 Borland Delphi 8 Borland C#Builder

PostgreSQLDirect .NET can be used together with UniDirect .NET that provides universal access to different databases within a single code.

Related Products

You might be also interested in:

• ADO.NET providers for other databases:
  MySQL, Oracle, MS SQL Server, universal provider
  
  
• PostgreSQL data access in other technologies:
  BDP.NET provider