Devart is glad to announce the release of the new version of dotConnect for PostgreSQL, enhanced database connectivity solution, built over the ADO.NET architecture, that supports Entity Framework and LinqConnect ORM solutions. New dotConnect for PostgreSQL offers you native Source and Destination components for DataFlows in SQL Server Integration Services projects.
Source Components
Source components of dotConnect for PostgreSQL are data flow components that query data from the corresponding database and make it available for other DataFlow components. They provide powerful editor dialog boxes, allowing you to tweak the components visually.
These editors display an object tree with availabe tables to select data from and SQL Server Integration Services (SSIS) system variables allowing you to quickly use their names in the queries.
Destination Components
Devart Destination components use database-specific features to load data quickly, thus providing significantly higher perfomance for data loading that the standard ADO.NET Destination component. They also allow advanced per-row error processing. Destination components can return a set of columns, containing error code, error columns, and error description for the rows, that caused an error.
Here is the complete list of dotConnect for PostgreSQL 6.8.322 features:
- SSIS DataFlow Source and Destination components for PostgreSQL are implemented
- The overload for the PgSqlLargeObject.Open() method with the PgSqlLargeObjectOpenMode parameter is added
- The bug with NULL values in Data Viewer in SSIS is fixed
- The bug with dequeuing RAW message having length greater than 2000 characters is fixed
- The bug with NullReferenceException when deserializing PgSqlException after passing it between AppDomains is fixed
- The bug with an error occurring during opening a connection, and then this connection getting into the pool is fixed
- The bug with the Caption property of the DataGridView column with the Devart DataTable component is fixed
- The possibility to use the extension method AsQueryable() in LINQ queries is added
- The support for correct retrieving of the TimeSpan and DateTimeOffset values while materializing is added
- The support for the operators of equality(==) and inequality(!=) for the "inet" data type in LINQ queries is added
- The bug with eager loading is fixed
- The bug with the redundant opened sessions is fixed
- The bug with missing CreateCommand method in the DataProvider class is fixed
- The bug related to the ArgumentNullException on SubmitChanges method when trying to update a row with the same values is fixed
- The "Close the window when the generation completes successfully" option in the Generation Process window is implemented in the standalone Entity Developer
- The "Rewrite connection string during regeneration" option (default value is True) of model settings is added to provide the possibility to turn off modifying connection string in *.config after model is saved first time (Entity Framework models)
- The design time support for model-defined functions is added (Entity Framework models)
- The behaviour is changed: now connection string is configured with the name of the assembly, where the model is located, in case when the context class is located in another assembly (Entity Framework models)
- The bug with the Retrieve Data functionality of the model with the DbContext template, when its Fluent Mapping property is set to True, is fixed (Entity Framework models)
- The bug related to the detection of Table Per Type inheritances as Table Per Concrete Type inheritances when opening an existing model is fixed (Entity Framework models)
- The bug with parsing *.edmx is fixed (Entity Framework models)
- The bug with generating "An item with the same key has already been added" error when using DbContext Template is fixed (Entity Framework models)
- The bug with DbContext template, when its MappingGenerationStrategy is set to UseConfigurationClasses, generating fluent mapping for an association with turned off generation of one navigation property is fixed (Entity Framework models)
- The bug with availability of the New Blank Template option of the Templates context menu in Model Explorer in the Entity Developer version integrated into Visual Studio is fixed
- The bug with generating invalid code when using MVC View Advanced template is fixed
- Entity Framework 6 Release Candidate 1 is supported
- SharpMap 1.0 RTM is supported
- NetTopologySuite 1.13.1 is supported
- Devart.Data.PostgreSql.Entity.Spatials.dll assembly is added
- The behaviour is changed: the parameter, which participates in the IS NULL comparison, is cast to a particular type in the generated SQL query
- The bug with generating NRE when adding parameter to a command in IDbCommandInterceptor.ReaderExecuting in Entity Framework 6 is fixed
- The bug with applying datetime and time data types when generating SQL with UNION statements, which correspond to multiple Include constructions in LINQ to Entities, is fixed
http://www.devart.com/dotconnect/postgresql/