New build of dotConnect for SQLite 5.15.1666 is available!

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for SQLite
Locked
Devart
Site Admin
Posts: 3570
Joined: Tue 26 Oct 2004 13:51

New build of dotConnect for SQLite 5.15.1666 is available!

Post by Devart » Thu 18 Jun 2020 09:43

Dear users,

New build of dotConnect for SQLite 5.15.1666 is available for download now.

In this version:
  • Visual Studio 2019 version 16.7 Preview is supported
  • The sqlite3.dll library that is included into the installation package is updated to version 3.32.2
LinqConnect (formerly known as LINQ to SQLite)
  • The bug with materializing elements, the types of which are explicitly converted from non-nullable to nullable on the client side, is fixed
  • The bug with incorrect detection of altered column comment in a many-to-many association join table by Update From Database Wizard is fixed
Entity Developer
  • .NET 5 is added to the list of available Target Framework versions in Create Model Wizard and Model Settings in EF6, EF Core, LinqConnect models
  • The new option "Execute procedures for result set detection" is added to Model Settings of EF Core Model to control obtaining metadata of a procedure or function result set
  • The new option "Use NULL parameter values" is added to Model Settings of EF Core Model to specify whether NULL parameter values are used for stored procedure execution
  • The new option "Add complex types to diagram" is added to Model Settings of EF Core Model to control behavior of Create Model Wizard and Update Model From Database Wizard
  • The new option "Add new complex types to the current diagram" is added to Update Model From Database Wizard of EF Core Model
  • The new Primitive Default Value Generation property is added to EF, EF Core templates to determine whether to generate initialization for a primitive property based on database DEFAULT column value
  • The new property Collection Property Type is added to EF template "DbContext" and EF Core template "EF Core" to determine .NET type used as a property type for the Many end of associations
  • The new property Collection Initialization Type is added to EF template "DbContext" and EF Core template "EF Core" to determine .NET type used for initialization of the Many end of association; if it is set to None, then no initialization is generated
  • The new property "Nullable Reference Types" is added to C# templates of EF, EF Core models to specify whether C# 8 nullable reference types and non-nullable reference types must be generated
  • The new partial method is added to the OnModelCreating(DbModelBuilder modelBuilder) method generated by DbContext template of EF model
  • The EF Core model deserialization is improved: Entity Developer shows the full list of detected errors and tries to load the model with invalid elements or ignores such elements if their deserialization is not possible
  • Console Entity Developer improvements:
    • Import of stored procedures and functions via Create-Model command is supported
    • The new options --Procedures and --Functions are added to Create-Model command for filtering stored procedures and functions; by default all procedures/functions are imported
    • The new option --Execute is added to Create-Model command for executing procedures/functions to get metadata from result set
    • The asterisk symbol (*) is supported in --Tables and --Views parameters of Create-Model to include all objects
    • The bug with opening connection via some supported providers is fixed
    • The bug with enumerating values separated with comma and without whitespace in --Templates, --Schemas, --Tables parameters is fixed
  • The DbProviderFactories registration is implemented in Create Model Wizard for EF6 models and .NET Framework provider assemblies
  • The new property Target Framework is added to Create Model Wizard and Model Settings of EF6 models
  • The compatibility issue with JetBrains ReSharper is fixed
  • The behavior is changed: the definition of auto-implemented property is put now on the single line with
    • C# DbContext template of Devart Entity Model when ImplementINotifyPropertyChanging=False and ImplementINotifyPropertyChanged=False and PropertyChangePartialMethods=False
    • C# EF Core template of Devart EF Core Model when PropertyChangeNotifiers=False and PropertyChangePartialMethods=False
  • The behavior for the new EF, EF Core models is changed: Primitive Default Value Generation is set to Literal now instead of LiteralOrExpression
  • The behavior is changed: the names of system types are generated without "System." prefix now in EF Core models; for example, it is DateTime instead of System.DateTime
  • The behavior is changed: only one confirmation for executing stored procedure is requested by Entity Developer when drag&drop-ing procedure from Database Explorer to Model Explorer or diagram surface
  • The behavior is changed: now the EF Core template generates an additional partial class for the context class when "File Per Class" and "Generate Partial Class" are set to True
  • The bug with detecting strings, being expressions, as string literals when generating initialization of string properties basing on database columns' default values in EF, EF Core models is fixed
  • The bug with detecting numbers, being quoted string literals, as strings when generating initialization of numeric properties basing on database columns' default values in EF, EF Core models is fixed
  • The bug with missing default value in the generated code basing on DEFAULT value in a database, when any of ImplementINotifyPropertyChanging, ImplementINotifyPropertyChanged, PropertyChangePartialMethods options of DbContext template in EF is turned on, is fixed
  • The bug with code generation for zero-or-one to zero-or-one association in the EF6 model with the DbContext template (Fluent Mapping=True) is fixed
  • The bug with generating .HasMany end of one-to-many association in EF Core Model is fixed
  • The bug with generating TPH mapping in EF Core 3 model is fixed
  • The bug with false appearing the "Table or view '...' has no primary key columns, and the entity key for the corresponding storage entity was calculated automatically from other fields." warning in the Error List window is fixed
  • The bug with generating new Guid() with Primitive Default Value Generation=Literal in EF, EF Core models is fixed
Entity Framework support
  • Entity Framework 6.4.4 is supported
  • The translation of the DateTime.AddMinutes() method in LINQ query into SQL statement in EF Core is supported
  • The bug with adding / subtracting DateTime and TimeSpan, DateTimeOffset and TimeSpan values in LINQ query in EF Core 3 is fixed
  • The bug with SQL generation in EF Core 3, when enum values are used in CASE and COALESCE statements, is fixed
  • The EF6 provider registration used with .NET Standard compliant assemblies is improved: the [DbConfigurationType(typeof(SQLiteEntityProviderServicesConfiguration))] attribute set for DbContext descendant allows now calling the DbContext constructor, that accepts a connection string, with no need to register a custom IDbConnectionFactory implementation
Devart development team
http://www.devart.com/dotconnect/sqlite/

Locked