dotConnect for PostgreSQL V7.21.1985

Entity Developer

• Added new Validation Framework property to the Data Transfer Object template for generating DataAnnotation attributes.
• Added new "Save connection to" option to Microsoft Entity Framework Core Model Settings which adds the ability to store the connection string in "Model file", "Entity Developer storage" and "Environment variable".
• Added new "Enum Output" option to the Entity Framework Core template to specify the output for generated enums.
• Added new property "Generate UnitOfWork Repository Properties" to the Entity Framework Core Model Repository and Unit Of Work template for accessing entity collections.
• Changed the representation of one-to-one association with non-nullable properties on both ends from 1 -> 1 to 0..1 -> 1 on diagrams in the Entity Framework Core Model.

Entity Framework support

• Added support for Entity Framework Core 5.0.10.
• Added support for Entity Framework Core 3.1.19.
• Added support for SQL translation of the following class members, used in LINQ queries, in Entity Framework Core 3 and Entity Framework Core 5:
  • static method IsNullOrWhiteSpace() of the String class.
  • static property Today and instance properties DayOfWeek, Ticks of the DateTime class.
  • MathF class static methods:
    • Abs().
    • Round().
    • Truncate().
    • Floor().
    • Ceiling().
    • Max().
    • Min().
    • Pow().
    • Sqrt().
    • Log().
    • Log10().
    • Sin().
    • Cos().
    • Tan().
    • Asin().
    • Acos().
    • Atan().
• Added support for SQL translation of the following class members, used in LINQ queries, in Entity Framework Core 5:
  • static method Parse() of the System.Net.IPAddress class.
  • static method Parse() of the System.Net.NetworkInformation.PhysicalAddress class.
  • MathF class static methods:
    • Abs().
    • Round().
    • Truncate().
    • Floor().
    • Ceiling().
    • Max().
    • Min().
    • Pow().
    • Sqrt().
    • Log().
    • Log10().
    • Sin().
    • Cos().
    • Tan().
    • Asin().
    • Acos().
    • Atan().
• Added support for mapping System.Decimal to PostgreSQL DECIMAL with specified precision and scale in Entity Framework Core 5.
• Added support for mapping the PostgreSQL HSTORE data type to Dictionary, SortedDictionary, ImmutableDictionary and ImmutableSortedDictionary in Entity Framework Core 3 and Entity Framework Core 5.
• Added support for the IndexBuilder HasFilter extension in Entity Framework Core Migrations in Entity Framework Core 3 and Entity Framework Core 5.
• Added support for mapping internet/intranet data type System.Uri to PostgreSQL TEXT in Entity Framework Core 3 and Entity Framework Core 5.
• Added support for mapping network data types System.Net.IPAddress and System.Net.NetworkInformation.PhysicalAddress to PostgreSQL INET and MACADDR/MACADDR8 in Entity Framework Core 5.
• Removed the definition of System.ICloneable from Microsoft .NET Framework assembly \Entity\EFCore3\Devart.Data.SQLite.Entity.EFCore.dll.