efcore

This servicing release was part of the .NET Core 2.1.5 release. It is versioned on NuGet and tagged here are 2.1.4 because EF Core did not make any changes for one of the .NET Core 2.1.x releases. (Going forward we will instead bump up all the versions so that they align.)

The issues fixed in this release can be found in the 2.1.5 milestone

Announcement blog post: https://blogs.msdn.microsoft.com/dotnet/2018/10/17/announcing-entity-framework-core-2-2-preview-3/

Issues fixed and features added:

• In 2.2 Preview 3
• In 2.2 Preview 2
• In 2.2 Preview 1

The 2.1.2 release to NuGet contains issues that were fixed in the 2.1.3 release of the ASP.NET Core metapackage, and hence are tracked on this GitHub repo in the 2.1.3 milestone.

This is a servicing release containing bug fixes made since the 2.1.0 release.

More than 500 bug fixes and enhancements have been made since EF Core 2.0 was released. Because EF Core is developed as an open-source project on GitHub, a complete list of these changes can be found in the GitHub issue tracker:

Changes from 2.1-rc1 to 2.1.0
Changes from 2.1-preview2 to 2.1-rc1
Changes from 2.1-preview1 to 2.1-preview2
Changes from 2.0 to 2.1-preview1

You can read more about this release on the .NET Blog announcement post.

In EF Core 2.1 the dotnet ef command-line tools have been integrated into the .NET Core SDK, but the new versions of the tools cannot be used with EF Core versions older than 2.0. For information on how to install and use dotnet ef tools with different versions of EF Core, see https://go.microsoft.com/fwlink/?linkid=871254.

Features

• Data Seeding: Enable for InMemory (#11474)
• Allow precision on type mappings with scale (#11439)
• Perf: make TypeMappingInfo a struct (#11424)
• Query: rewrite predicate with constanList.Any(e =>e == someProperty) to Contains (#11389)
• Consider making RelationalTypeMappingInfo concrete (#11363)
• Feature parity: Add IQueryTypeConfiguration (#11257)
• Consider renaming the Attributes package to Abstractions and moving other types there (#11170)
• Possible issue in RelationalTypeMappingExtensions.CloneWithFacetedName (#11167)
• Consider moving attributes to new Attributes package (#11144)
• Property expression exception for fluent api should be more explicit (#11135)
• EF migration MigrationBuilder.InsertData enables IDENTITY_INSERT when it is not needed. (#11115)
• ValueComparers, mappings and genericity (#11072)
• Reveng: custom naming of properties, dbset and entity? (#11056)
• Query: Make EF.Functions.DateDiff SqlServer specific (#11038)
• Using IQueryable.Contains() in an expression causes a memory leak (#11015)
• Update SQL Server and SQLite type mappings to not use fallbacks (#10987)
• Query: convert ExpressionEqualityComparer to a singleton (#10983)
• Benchmarks: Run EF Core dev benchmarks with netcoreapp2.1 runtime (#10972)
• Review log-levels for 2.1 logging (#10966)
• Exception when removing migration (#10921)
• Add events for entity state changes (#10895)
• For API review: Consider renaming fluent method SeedData() to HasData() or HasSeedData() (#10875)
• Update API test for fluent method chaining (#10863)
• Decide on which constructor to call by convention (#10852)
• Tools: Consolidate -Force and -Revert on Remove-Migration (#10781)
• Query: remove redundant ToList calls on top of correlated collections that get optimized (#10762)
• Query: we inject redundant MaterializeCollectionNavigation calls into some queries that take advantage of correlated collection optimizations (#10733)
• CompareString in VB Project will be evaluated locally (#10707)
• Add MaterializationContext parameter object (#10641)
• EF Core Drop Database Command runs the "ConfigureServices" method twice (#10636)
• Change parameter log formatting to not show DbType = String when it isn't (#10634)
• Question:Design Core(Rev Eng):Context Class: How to add namespace while generating Context class (#10629)
• CLI Tools: Convert to a Dotnet (global) Tool (#10554)
• Make IEntityEntryGraphIterator public (#10540)
• Sqlite: Translate DateTime.Millisecond (#10523)
• Implement lazy-loading of navigation properties (#10509)
• Allow a second type argument AddDbContext to support inheritance (#10451)
• Add logging event for client-side cascade delete (#10435)
• Update "More than twenty 'IServiceProvider'..." message to be more helpful (#10235)
• Mix of owned and normal entity types in hierarchy should cause validation error (#10200)
• Better SaveChanges exception messages for "conceptual nulls" (#10170)
• HasIndex does not work as expected (#10135)
• Better LINQ support for Microsoft.SqlServer.Types (#10109)
• DbSet.Find for null values (#10096)
• Query: Translate GroupBy constant value followed by aggregate as table aggregate (#9969)
• EF generates very unclear error message in case too generic key types in M:M relationship (#9817)
• Data type 'nvarchar' is not supported in this form should also say which property (#9761)
• Support change tracking of non-primitive types (#9753)
• Update DeleteBehavior.Restrict to not apply when navigations are changed (#9703)
• Improve exception for incorrect FK value (#9696)
• Re-consider how default values are reverse engineered (#9627)
• Throw better exception for .Set() (#9626)
• Consider simplifying roadmap page (#9615)
• Metadata: Implement IsFixedLength API (#9579)
• Query: Apply CompositePredicateExpressionVisitor to join predicates (#9395)
• Remotion Linq: Upgrade package to RTM version (#9311)
• efcore2 warns about default values for bool (#9291)
• Add generic overloads for relationship API with navigations passed as strings (#9191)
• Make warning as error exception more helpful (#9178)
• Expose ChangeTrackingStrategy on IEntityType and IMutableEntityType (#9087)
• Allow fields to be used for navigation 'properties' (#9059)
• Query: Filter out entities that are using table splitting with a derived type (#8973)
• Improve the conceptual null exception (#8365)
• Improve SaveChanges circular dependency exception (#8363)
• TrackGraph stop tracking if current State is not set, but setting state throw InvalidOperationException (#8226)
• Warn when runtime version newer than tools (#7065)
• Minor: if possible improve error message (add UK to message also) (#5944)
• Query: Allow EF.Property to be used for navigations. (#4834)
• Support specifying a default value for a column corresponding to an enum model property (#4081)
• Support for database enums (#3620)
• Reverse Engineer: Allow reading connection strings from configuration (#2464)
• Logging: add to Change Tracker (#221)

Bugs Fixed

• InvalidOperationException when use enum as discriminator (#11454)
• Query Types don't work with compiled queries (#11413)
• Query: compilation error for queries streaming correlated collection with FirstOrDefault (#11403)
• Benchmarks scenarios broken (#11399)
• Oracle: Order_by_entity_qsre_composite_key broken (#11377)
• Analyzers: Remove DbCommand.CommandText analyzer (#11371)
• Owned entity type use one type multiple times - add-migration will always find differences and therefore add the same migration again (#11369)
• ValueComparer for keys isn't applied consistently (#11362)
• .Ignore() throws NullReferenceException (#11354)
• 2.1 preview: System.InvalidOperationException: 'The service property [...] of type [...] cannot be added to the entity type [...] because service property [...] of the same type already exists on entity type [...].' (#11351)
• Perf: Logging infra allocates even when no logging enabled. (#11331)
• Query: invalid SQL for queries projecting a single column from a subquery using Take and FirstOrDefault (#11326)
• DbContextPooling does not throw exception when trying to get model from disposed context (#11309)
• Failures on Benchmarks (#11304)
• Query: Join/GroupJoin where key selectors are qsres or navigations fails during compilation (#11288)
• Predicate (date == DateTime.MaxValue) always returns false (EF 2.1-preview1-final) (#11262)
• Query: compilation error for queries with join where the inner key is navigation (#11245)
• select new {} in a selectmany fails (#11219)
• 'AS' in group by statement when an 'AS' is present in the select statement (#11218)
• One-to-One relationships generates differently based on entity names (#11213)
• EF 2.1 Value Conversion fails with custom type (#11199)
• Investigate perf regressions from 2.0 related to model building (#11196)
• Investigate perf regressions from 2.0 related to update pipeline (#11195)
• Query: groupby doesn't get translated if the result is projected into DTO (#11176)
• Double pipe or clauses not working for subqueries (#11168)
• Entity Framework paging, that is to say Skip/Take, doesn't work for large tables (#11166)
• "No coercion operator is defined" with dynamically generated selection expression (#11165)
• Correlated subquery (N+1 fix) missing ORDER BY clause inside nested query (#11163)
• Query: Incorrect warning about group by client eval (#11157)
• Owned type - property could not be mapped - string is not a supported primitive type (#11152)
• Validate FK on PK in derived type during model validation, not building (#11141)
• BoolToStringConverter does not use non-default values when seeding (#11131)
• Enum property stored as string, filter queries do not work (#11127)
• Value converters on key properties are propagated to FK properties (#11117)
• Tracking query on base type when derived type has shadow properties throws (#11104)
• Migrations generates invalid code for data seeding (#11097)
• 2.1 preview 1 - Unable to set up cascade delete when using TPH (#11094)
• EF Core 2.1 Preview 1 SeedData method throws The seed entity for entity type 'XXX' cannot be added because the was no value provided for the required property 'Discriminator'. (#11083)
• Occured ArgumentException about language paramter when scaffolding database (#11075)
• No suitable constructor found for entity type 'string' (#11074)
• EF Core OnModelCreating Console.WriteLine causes PMC to hang (#11066)
• Provide more details for "An item with the same key has already been added" exception (#11062)
• Query: include over SelectMany with reference navigation projection doesn't work (#11053)
• Query: DbSet may not be EntityQueryable (#11043)
• Query comparisons for big decimals fail on Sqlite (#11036)
• Query: GroupJoin with a complex join key fails during compilation (#11022)
• ForeignKeyConvention doesnt run when dependent entity type PK is changed (#11019)
• Configuring a custom type mapper for a generated column breaks value generation (#11010)
• ArgumentNullException with Concat (#11007)
• Query: accessing property on a required navigation defined on a derived type produces INNER JOIN (#10988)
• Query: Include Collection group by reference throws exception (#10974)
• Test: Can_use_with_fanned_relationships has incorrect assertion (#10971)
• Migrations with multiple startup projects (#10967)
• Update pipeline doesn't enforce all the identifying relationships in table splitting (#10962)
• Enum property stored as string，unable to specify length (#10944)
• Problematic interaction between MigrationsSqlGenerator and new type mapper (#10942)
• EntityFrameworkCore build fails with error "KRB5005: Symbols were set to be included but the project was built using DebugType = full" (#10938)
• Problem with foreign key configuration, (#10918)
• Annotations on the first owned entity type reference are lost (#10911)
• Query: GroupBy with Where produces invalid SQL (#10870)
• Operator Contains is translated in EF Core 1.x, but throws exception in 2.0. (#10868)
• Update transient error message (#10856)
• Query: correlated collection optimization is broken for queries containing top level First/FirstOrDefault/Single/SingleOrDefault (#10813)
• Query: Translate string.Equals(a, b) (#10807)
• DI issue when provider doesn't define an IRelationalTypeMapper (#10803)
• Off-by-one applying RelationalMaxIdentifierLengthConvention? (#10796)
• Query: OrderBy().Take().Last() gives incorrect results (#10794)
• Model Query Filter generates incorrect SQL (#10785)
• Keep the underlying Builder in ReferenceOwnershipBuilder up-to-date (#10780)
• Migration Snapshot enum/valueconverter issue (#10748)
• Get the values of Group by using MyGroup.ToList() Throw exception, Must select First (#10716)
• Inheritance validation should allow setting base to null (#10715)
• Support ArrayIndex expressions in where clause (#10711)
• Metadata: Unique Index on derived type does not exclude nulls (#10659)
• Incorrect translation of date substraction. (#10656)
• Make ILazyLoader disposable (#10640)
• Update BuiltInDataType tests to ensure batching case is covered (#10633)
• Query: compilation error for queries accessing null-protected property inside subquery produced by All/Any result operator (#10627)
• dropping many (all?) foreign keys after update from 1.x to 2.x (#10617)
• Rebuilding relationships causes annotations on navigations to be lost (#10612)
• NRE thrown during add-migration if primary key is null. (#10571)
• Failing to sort owned types, when updating different combinations of fields of both parent and owned type at the same time (#10568)
• Specified cast not valid when using min or max after decimal to float cast (#10537)
• “Parameter count mismatch” error during adding Entity Framework migration under .NET Core 2.0 (#10504)
• Inconsistent SQL queries in inheritance + FromSql scenarios (#10501)
• Warn for LastOrDefault without OrderBy (#10493)
• Query: Include on derived throws in async (#10440)
• SQL Server Migrations: CreateIndex for Memory-Optimized Table ignores schema (#10402)
• ToDictionary won't work, if using with navigation property (#10312)
• Query: QueryFilter with EntityTypeConfiguration are failing to inject current context values (#10301)
• Query: FirstOrDefault on empty collection returning a value type tries to return null instead of default (#10294)
• Invalid cast when using inline "if" returning an enum (#10293)
• EF Core does not cast from Nullable to underlying type (#10284)
• HasQueryFilter generates incorrect sql, causing "multi-part identifier could not be bound" (#10283)
• Query: ToList in projection for async query hangs if rooted at context (#10188)
• When utilizing shadow properties for multiple level relationships length metadata can be lost (#10185)
• Temporary Key issue when inserting Many To Many Relationship and Self Reference (#10142)
• Filtered child entities in projection are not tracked (#10124)
• No value provided for required parameter '_outer_Id'. v2.0.0 (#10122)
• Query: Using DbSet property in QueryFilter throws exception (#10117)
• Bug in MigrationBuilder (#10115)
• Query: Select.Include.OrderBy ignores the include (#10101)
• Throw on table splitting with multiple roots (#10077)
• Script output ends up in unexpected directory (#10036)
• Script-Migration -Idempotent when default schema contains dot (#9993)
• FileLoadException when migrating with incorrect startup project and and project (#9984)
• Adding multiple entities to a join table with a composite key throws (#9962)
• Query: compilation exception for query projecting negated conditional expression inside anonymous type (#9944)
• nullreference when during add-migration when migration implementations lack migration attribute (#9920)
• Incrorrect EntityState in ChangeTracker when assigning RowVersion directly (#9856)
• Owned types throw when setting the primary key constraint name (#9771)
• Max causes QueryClientEvaluationWarning (#9726)
• Properties with private setters in base class are not saved (#9705)
• Missing thread safety in ModelSource._models (#9695)
• Setting a navigation property to null and then back to a value doesn't update the FK when using ChangingAndChangedNotificationsWithOriginalValues (#9693)
• Configuring Property with a string cannot discover private fields from base class (#9603)
• Insert entity in non existing table throws NullException (#9599)
• Relational: UDF calls are generated unquoted (#9558)
• Conventions shouldn't try to set the base type for owned types (#9536)
• EF Core joining on the wrong field when using GroupBy (#9481)
• Metadata: Exception is not thrown for unmapped navigation property (#9396)
• FirstWithoutOrderByAndFilterWarning logged when querying byte[] property (#9372)
• Include and ThenInclude not working after groupBy with OrderBy (#9336)
• Mapping: conventions try to use primary key as the FK of a required relationship in some scenarios, which can't work since the PK is not nullable (#9310)
• Projecting bool property through optional nav access with other conditions throws ArgumentException (#9275)
• The convention invocations have reached the recursion limit. (#9265)
• Metadata: InverseProperty fails to resolve ambiguity while use KeyAttribute on PK (#9180)
• Subquery.Any(predicateParameter) throws exception (#8019)
• Query: Compiler error when calling Contains on a collection nav (#7687)
• Query: Allow use of AsQueryable method (#6132)
• Migrations Design: Compile error with enum discriminator (#5529)

This release includes the following new enhancements and bug fixes: https://github.com/aspnet/EntityFrameworkCore/milestone/39?closed=1

Features

• Update reverse engineering of non-nullable bool columns with default values for SQL Server (#9826)
• Should quirk switch names contain bug number? (#9608)
• UWP compat: .NET Native tracking perf improvements (port to patch) (#9492)

Bugs Fixed

• Regression in 2.0.3 preview: NullReferenceException in RelationalDataReader.Dispose() on Migrate() (#10147)
• System.ArgumentOutOfRangeException after upgrade to EF Core 2.0 (#10045)
• Scaffolding fix for nvarchar(4000) (port to patch) (#9963)
• Enum.ToString() results in SQL translation and returns underlying integer value (#9894)
• GroupJoin to parent with no child throws invalid operation exception (#9892)
• Access to context bound variable can incorrectly be optimized out (#9825)
• Update of owned entity fails (#9803)
• Metadata: Discovering derived type with self ref relationship before base causes exception (#9704)
• Exception in Client vs. Server Evaluation with async/await in EF Core 2.0.0 (#9570)
• Expression of type 'System.Object' cannot be used for parameter of type 'Microsoft.EntityFrameworkCore.Metadata.IEntityType' (#9551)
• ModelBuilder: stackoverflow for may be invalid relationship via fluent api (#9478)
• Diagnostics logging is incompatible with windows EventLog (#9437)
• UWP compat: Don't use reflection on emitted types (port to patch) (#9355)
• Migrations after field rename with Datetime type doesn't work (#9344)
• Query: Output parameter in FromSql is always null (#9309)
• Remove-Migration null-refs when generating report (#9280)
• Projection with nested projection hangs/does not complete in 2.0 Preview 2 (#9128)
• Including collection navigation after optional navigation throws NRE with async in 2.0.0 (#9038)

Bugs Fixed

• [Port to patch] Query: Make ParameterExtraction recursive on closure members (#9105)
• [1.1.2 regression] The multi-part identifier "ts.Id" could not be bound (#8862)
• [Port to patch] Migrations: Parameterless DbContext constructor is used in preference to overload taking DbContextOptions (#8825)

Features

• Configure logging internally to not filter out Debug messages (#9083)
• React to feedback on warning as error for ignored calls to Include() (#9064)
• Add DbContext Validate to CLI/PS commands (#9052)
• Query: Make ExecuteSqlCommand to accept SqlParameters in different patterns (#8939)
• Post-process model snapshot to massage metadata (#8925)
• Databinding: Guide users to not bind against queries directly (#8899)
• Log a message with EF version information (#8893)
• SQL Server RevEng: Scaffold IsRowVersion for timestamp columns (#8892)
• Throw better exception when app might be using old ASP.NET pattern (#8888)
• Validate keys are not configured as AddOrUpdate/Computed (#8863)
• Improve exception message for underconfigured 1-to-1 relationships (#8857)
• Remove RelationalAnnotations.GetAnnotation(annotationName) (#8848)
• AddDbContext with ServiceLifetime.Scoped should pass scoped IServiceProvider to optionsAction (#8797)
• RevEng: Don't indent #warning (#8778)
• RevEng: Remove DbDataReaderExtension (#8712)
• Query/Test: introduce client-side ordering to QueryTests without explicit orderby, rather than using contains in the result verification (#8617)
• Query: Add Support for DateTimeOffset.Add* functions (#8590)
• CLI Tools: Add --runtime (#8479)
• Reverse engineer bool column with default constraint to nullable bool property (#8400)
• Cannot insert entity into DB using attach and EntityState.Added (#8264)
• Add parameterless overload of HasDefaultValueSql (#7872)
• Provide good feedback when providers don't implement services (#7469)
• Relax derived FK overlapping PK restriction (#7181)
• Query: Better warning and XML doc comments about ignored Includes (#7162)
• Design: Public API to instantiate DbContext classes (#7050)
• Reverse Engineer: Cmd parameter to disable naming logic (#6018)
• Make set discovery a separate service (#977)

Bugs Fixed

• Query: Included navigations are not fixed up in loaded related data (#9271)
• CLI throws: Unable to retrieve project metadata. (#9127)
• Fix .HasIndex generic type argument for owned types (#9106)
• Tools: Ignore errors in design time DbContext discovery (#9073)
• EF Core 2.0.0-preview3-26027 NullReferenceException on RelationalCommand (#9041)
• Query: compilation error for queries with Concat on two entities and Count (#9004)
• Detached entities appear in ChangeTracker.Entries() (#8921)
• QueryCache misses for dynamically created queries with ConstantExpresssions or nested MemberExpressions from closure (#8909)
• SqlServer: Literals with real type is always considered float type (#8905)
• RevEng: Default index names scaffolded (#8891)
• Metadata: Convention does not create relationship after Fluent API resolves ambiguity (#8886)
• GetDatabaseValues should always call IgnoreQueryFilters() (#8883)
• Design: Debug log messages not reported on the console (#8879)
• Changing RowNumberPaging should cause new internal service provider to be built (#8877)
• "Given key was not present in the dictionary" after migration to 2.0 (#8817)
• CLI Tools: Error when MSBuildProjectExtensionsPath doesn't exist (#8816)
• Query: manually created GroupJoin with order by key descending generates invalid SQL (#8754)
• Query: FromSql with DbParameters throws Must declare the scalar variable/No mapping to a relational type ... SqlParameter (#8721)
• Snapshots can lose annotations on non-primary keys (#8716)
• RevEng: Pass in correct argument values to ScaffoldingTypeMapper (#8697)
• MySQL:.GroupBY() thrown exceptions (#8693)
• SQL Server RevEng: No ForSqlServerIsClustered(false) on NONCLUSTERED PKs (#8687)
• HasMaxLength(4000) set to NVARCHAR(MAX) (#8685)
• InvalidCastException when casting from one value type to another in a simple select statement (#8652)
• Calling new DateTime() in projection causes NullReferenceException. (#8608)
• Entity Class with Enum : long property does not translate into BigInt when using Enum.HasFlag (#8538)
• Query: compilation error for queries with navigations inside set result operators and Count (#8525)
• Query: incorrect sql generated for query with owned entities, left join and predicate using inner qsre (#8492)
• InvalidOperationException updating an entity with CurrentValues.SetValues throws InvalidOperationException when the SetValues parameter does not contain a required field data. (#8465)
• Unable to cast object of type 'PropertyExpression' to type 'NullConditionalExpression' for some queries with include, and multiple orderbys (#8369)
• SQL for string-updates sometimes uses nvarchar(450) if a string field is used in an index (not key) (#8322)
• When I remove entities in the dbContext, they are still in navigation properties of the entities (#8319)
• Revisit concurrency detector (#8305)
• Query: Some double & float literals are wrong (#8270)
• Attaching entity and setting different IsModified values to different property prevent update (#8265)
• Query: ulong literal throws RuntimeBinderException (#8259)
• Concatenated string sequence as primary key - Insertion fail via EF code (#8239)
• DbSet.Find() doesn't work for nullable properties (#8189)
• Navs: nav expansion on GJ QSRE in projection doesn't introduce parameter (#8186)
• Memory leak in LocalView (#8144)
• One-to-one relationship with bad data behaviors differently for bi-directional verses uni-directional relationships (#8137)
• InvalidOperationException: "Collection was modified" inside NavigationFixer (#8101)
• Exception when setting the default value for a nullable int field (#8015)
• RelationalDiagnostics: Naming inconsistencies (#8001)
• Identifying shadow FK values are not propagated when tracked as unchanged or modified (#7985)
• PropertyEntry.CurrentValue should throw an exception (#7920)
• Somehow a mismatch in the ShapedCommandContext entries resulting in KeyNotFoundException (#7863)
• SQL Server: Error better when no database name (#7816)
• Where/Select/OrderBy/etc clauses referencing DB types can't execute if helper function used (#7808)
• Incorrect tracking state of loaded Entities when using ChangeTrackingStrategy.ChangedNotifications (#7803)
• Setting the IsModified flag to false on a property leaves original value untouched so the change is detected again (#7798)
• Calling IQueryable-producing methods inside expression tree throws exception when outer is enumerated: "A second operation started on this context before a previous operation completed. Any instance members are not guaranteed to be thread safe." (#7783)
• Insert not reflecting correct datatypes (#7704)
• EF Core default value for not nullable column not set (#7679)
• Re-building relationships can cause annotations to be lost (#7674)
• Entity Framework instance of entity type cannot be tracked (#7599)
• Incomplete support of NullConditionalExpression in ExpressionEqualityComparer (#7559)
• Two model classes in the same hierarchy with identical field names causes exception (#7536)
• Design: Look at generic parameters when generating namespace using directives (#7352)
• Migrations: SQL not logged on SqlServerCompact (#7317)
• Relational model builder: Consistently map shadow FK properties (#7240)
• Foreign key with backing field producing invalid sql (#7147)
• Projections With Full Types Not Fixing Up Navigations on Sqlite and SQL Server (#7131)
• Document exceptions (#7012)
• Migrations: Experience when altering memory-optimized is ugly then fails (#6887)
• Cannot set Foreign Key column name by Fluent API (#6880)
• Select following GroupBy throws exception for SqLite (#6059)
• EF Core 1.0 RTM not filtering properly on fields of type char (#5975)

Features

• Pragma out obsolete warnings in generated code (#8703)
• Consider Removing HasNonDefaultUnicode and HasNonDefaultSize (#8668)
• Simplification of cascade delete fluent API (#8654)
• Exists check logs error "An error occurred using the connection..." (#8651)
• Request: A DeleteBehavior that does absolutely nothing on delete and on SaveChanges (#8633)
• Consider moving DeleteBehavior enum to core namespace (#8632)
• MigrationsScaffolder is a public type registered in D.I. with no contract or dependency objects (#8623)
• Replace RelationalTypeMapping.GenerateLiteral(DbType) (#8609)
• Query: reuse include pipeline for queries projecting uncomposed collection navigations (#8584)
• Update ExecuteSqlCommand methods to use string interpolation (#8557)
• API Review: Make DbContextFactoryOptions obsolete (#8553)
• RevEng: Prefer [StringLength] over [MaxLength] on string properties (#8468)
• Make query parameter format for logging consistent (#8456)
• Tools: Block .NET Standard startup projects (#8452)
• Update: Relational: Potential optimization in MERGE SQL batching path? (#8415)
• Throw error on ignored includes (#8398)
• Consider throwing when a DIET instance is shared (#8387)
• Query: perform null protection pattern (a != null ? a.Name : null) to NullConditionalExpression (a?.Name) translation on QueryModel level (#8385)
• EnableRetryOnFailure defaults don't cover SQL Azure recommended retry period (#8275)
• Consider removing UseSqlServerIdentityColumn and ForSqlServerUseSequenceHiLo (#8271)
• Design: Discover DbContext types using Program.BuildWebHost() (#8164)
• Add very simple "type mappings" for non-relational providers (#8010)
• Feature request: add instanceId (Guid) to RelationalDataReader for DiagnosticSource (#8007)
• Investigate using IConfiguration in OnConfiguring (#7916)
• Trace connection open and close in RelationalConnection (#7479)
• Self-contained type mappings (#7434)
• Add a version of the ExecuteInTransaction() that supports specifying the isolation level (#7431)
• Provide access to referencing entity in TrackGraph (#7389)
• Query: Add support for User Defined Scalar Functions. (#7368)
• Better way to get application services from within a derived DbContext instance (#7185)
• Warn for non-nullable store-generated bool properties (#7163)
• Query: Translate String.CompareTo() (#7095)
• Xamarin support (#4269)
• Complex types and/or value objects (#246)

Bugs Fixed

• Query: Projecting second level collection navigation using First() generates invalid SQL (#8823)
• Migrations: Ignore RelationalAnnotationNames.TypeMapping while generating model snapshot file (#8665)
• Remove SqlServer TypeMapping for CLR type char (#8656)
• HasQueryFilter supporting any other type than string? (#8630)
• Migrations: InsertData() causes error "Table 'table_name' does not have the identity property. Cannot perform SET operation." (#8618)
• HasFilter generating migrations with string quotes missing (#8575)
• Design: Exception using Program.BuildWebHost (#8547)
• Tools: Default to Development environment (#8514)
• Query: SubQueryMemberPushDown optimization is too aggressive, which may lead to invalid sql or data corruption (#8505)
• non latin characters in migration name (#8483)
• DbContext.GetInfrastructure() method missing in 2.0 preview? (#8440)
• Query: ProjectStar table is set incorrectly in JoinEliminator (#8412)
• CLI Tools: --configuration switch does not work (#8399)
• Query: null propagation optimization doesn't work for navigations with composite keys (#8397)
• Query: EntityEqualityRewritingExpressionVisitor doesn't work with object.Equals method (#8366)
• Query: comparing collection navigations to null or to each other doesn't work (#8364)
• Tools: Improve message "Could not load assembly 'EFCore.Design'." (#8354)
• Argument types don't match for queries projecting conditional expression with anonymous type result (#8315)
• Query: Select with new DTO taking entity in constructor argument throws ArgumentException (#8282)
• Null semantics are not carried from subquery (#8254)
• Query: navigation rewrite fails for queries with navigation inside a subquery inside join inner key selector (#8216)
• Hidden columns are scaffolded (#8192)
• PMC Tools: Exception calling "Substring" (#8163)
• CLI Tools: Hide build success output (#8048)
• Query: we should propagate optional navigations thru nav rewrite, if the initial optional navigation was created using SelectMany-GroupJoin-DefaultIfEmpty (#7975)
• GroupBy needs a ToList before to work (#7943)
• Query: compilation error for complex query with SelectMany, optional navigation, subquery and string concat in projection (#7921)
• Inheritance does not discover Id as PK by conventions (#7885)
• ExecutionStrategyExtensions.ExecuteInTransactionAsync null reference exception (#7795)
• Query: NullConditional is not added to some complex queries with optional navigation and collection with subquery (#7787)
• Query : Missing null propagation logic for some complex queries with manually created GroupJoin-SelectMany-DefaultIfEmpty (#7761)
• Throw if the FK properties set by the convention are ambiguous in the hierarchy (#7736)
• PMC Tools: Error when project opened from a file share (#7540)
• PMC Tools: Error when using Docker tools (#7439)
• DbSet<>.Local InvalidOperationException with ListBox.ItemsSource (#7397)
• ModelValidator: Do not warn for explicitly configured shadow keys (#7238)
• ConventionSet API XML Document Error (#7177)
• ModelBuilder: Do not silently remove key when a property is made optional (#6919)
• ExecutionStrategy ctor argument - maxRetryCount has incorrect documentation (#6828)
• Migrations: Parameterless DbContext constructor is used in preference to overload taking DbContextOptions (#6826)
• Revisit public/abstract aspects of query context factories (#6713)
• Query: compilation error for queries projecting optional navigation, paging and another projecting of optional navigation (#6618)
• Scaffold annotations on DatabaseModel to the generated model (#6561)
• Query: Comparing collection navigation to NULL throws Null Exception (#5825)
• Update scaffolding to use ScaffoldingTypeMapper (#5410)
• Query :: some queries with Queryable.Cast don't work (#3736)

Features

• Port #7710 to 1.1.2 - Tools: Allow script/update etc. to run when context is not in target project, but can be found in services (#7711)

Bugs Fixed

• Tools: Port #7889 to 1.1.1 (#8142)
• QueryCache: Memory leak when using dbContext.Set<> in subquery (#8063)
• EF Core 1.1.1 has introduced a new ArgumentException for complex queries with with subqueries, if the same subquery is present multiple times in the query model (#7944)
• Port #7769 (missed reflection equality fixes) to patch? (#7899)
• Invalid query produced when projecting DTO containing subquery that returns a single element (#7714)
• Metadata: Stackoverflow on unambiguous model with InverseProperty on navigations on both directions (#7698)
• Scaffold-DbContext does not emit warning messages for failed entity generation (#7315)
• SaveChanges closes connection opened by user using EF API (#6968)

Features

• Design: Allow script/update etc. to run when context is not in target project, but can be found in services (#7710)

Bugs Fixed

• Could not load System.Diagnostics.DiagnosticSource (#7889)

Features

• Query: Anonymous type projections should use member names as column aliases wherever possible (#8204)
• Migrations: Specify NULL columns explicitly in DDL (#8146)
• Query: Lift subquery with nested orderby (#8054)
• Query: Implement "Like" function in core (#8004)
• Query: Prevent client evaluation when subquery returning entity is compared to null (#7915)
• Query: Improve SQL for queries with left join that generate subqueries due to discriminator predicate (#7689)
• Infrastructure: Allow custom SQLite builds (winsqlite3, SQLCipher, etc.) (#7667)
• Query: Remove redundant compilations of subquery models when processing MainFromClause, AdditionalFromClause and Join/GroupJoin clauses (#7647)
• Query: Flatten out subquery models at query optimizer (#7613)
• Query: Apply optimizations to composite predicates in all parts of the query (#7608)
• Query: Add missing translators for Math functions in SqlServer provider (#7601)
• Query: Prevent client evaluation if query modifiers precede condition (#7560)
• Infrastructure: Avoid reference counting for open and close in SQLite provider (#7527)
• DbContext: Require name for "persistent" in-memory database and add explicit API for creating transient database (#7482)
• Infrastructure: Add parameter objects and service rewriting code to avoid breaking base class D.I. constructors in patch/point releases (#7465)
• Infrastructure: Allow only one database provider per service provider (#7457)
• Query: Improved performance for String.StartsWith() filters (#7429)
• Migrations: CLI Tools: Honor ASPNETCORE_ENVIRONMENT (#7353)
• Query: Translate Distinct to SQL when applied after custom projection (#7234)
• Infrastructure: Improve experiece for filtering log data (#7217)
• Model configuration: Set ValueGenerated for store-generated properties using a convention (#7205)
• Query: Translate Average to server side (#7190)
• Migrations: Make generated code play well with StyleCop (#7189)
• Query: Translate querys with filter on sub-query to a single SQL statement (#7122)
• Infrastructure: Trace when query is done. This is needed in order to get SelectRows statistics. (#7105)
• Query: Prevent client evaluation when using certain result operators in complex query (#7096)
• Model configuration: Make filtered indexes play nice with other providers (#7087)
• Infrastructure: Improve Exception message: Unable to create or track an entity of type 'abc' because it has a null primary or alternate key value. (#7001)
• Infrastructure: Make RelationalFullAnnotationNames public (#6993)
• DbContext: Stop special-casing the root entity on Attach (#6990)
• DbContext: Throw on AddDbContext with options lambda when context has no options ctor (#6963)
• Infrastructure: Convert more services to be singletons (#6924)
• Performance: Implement DbContext pooling for high scale scenarios (#6923)
• Query: Allow providers to replace and extend SqlTranslatingExpressionVisitor (#6888)
• Query: Avoid adding unnecessary sort columns in query with projection and optional navigation properties (#6861)
• Model configuration: Ability to override IS NOT NULL clauses of an index (#6794)
• Query: Translate DateTimeOffset.Date (#6778)
• Migrations: Handle GO statements in SQL Server (#6747)
• Query: Simplify aliases for complex projection if being used in order by clause (#6703)
• Reverse engineering: Add IsConfigured check to avoid using hard-coded connection when previously configured (#6686)
• SaveChanges: Database.SetCommandTimeout overload that accepts a TimeSpan argument (#6614)
• Query: Prevent client evaluation and N+1 queries when calling result operators before other operators (#6611)
• Query: Issue warning for queries with paging operations (First, Take, Skip) without OrderBy (#6576)
• Query: Throw better exception when reading incorrect data for relational providers (#6471)
• Query: Ix-Async dependency updated to 3.1 (#6328)
• Query: Using Include and referencing a navigation property will not result in repeated joins (#6206)
• Migrations: SQL Server Filtered Indexes (#5817)
• Query: Model-level filters for queries (#5774)
• Reverse Engineering: Enable pluralization/singularization when scaffolding a model from a database (#3060)
• Query: Provide EF.Functions to define methods that correspond to standard SQL operations (#2850)
• Model configuration: Entity type configuration can be factored into a class (#2805)

Bugs Fixed

• Migrations: Exception thrown with model containing TPH in certain cases: The entity type should derive from to reflect the hierarchy of the corresponding CLR types. (#8423)
• DbContext: Owned entity types are incorrectly identified as tracked when clr types contain Equals implementation (#8284)
• Query: The generated identifiers in multi level queries are too long for SQLServer (#8255)
• Query: projecting stringColumn.Length may cause invalid cast exception, if the stringColumn is of type (n)varchar(max) on SqlServer (#8176)
• EntityType marked with NotMapped is still discovered by Conventions (#8151)
• Query: ProjectionShaper ignores the offset while Shaping (#8095)
• Query: Order by with condition evaluating to true/false produces invalid SQL (#8092)
• Reverse engineering: Scaffold-DbContext creates invalid code for default constraints with line breaks (#8077)
• Query: Navigation rewrite: EF.Property navigations not rewritten correctly (#8068)
• Query: The binary operator Equal is not defined for the types 'System.Nullable`1[System.Boolean]' and 'System.Boolean'. (#8065)
• Query: Make our reflection info selection logic deterministic (#8060)
• Query: QuerySourceTracingExpressionVisitor doesn't always prune EF.Property expressions (#8053)
• Query: Inner Join not generated when using custom projections or wrong alias when omitting custom projections (#8043)
• Query: SqlServerStringReplaceTranslator fails with Sequence contains more than one matching element on the latest runtime (#8021)
• Query: Unable to cast object of type when using Include in projection (#8005)
• Reverse engineering: Scaffold-DbContext can generate IsRequired() on nullable unique column if it is also an FK (#7956)
• Reverse engineering: Unique Index interpreted incorrectly to give one-to-one instead of one-to-many relationship (#7938)
• Query: AsNoTracking/AsTracking methods on Non-EF Queryable providers throws InvalidOperationException (#7937)
• Infrastructure: DatabaseName is only used by tooling and shouldn't be public runtime API (#7936)
• Query: Contains method on client list of nullable guid/int fails to translate to server (#7922)
• Reverse engineering: Scaffold-DbContext can result in invalid SQL for computed column constraint (#7918)
• Query: Navigation filter + navigation group by + order by grouping key throws exception (#7904)
• Query: Joined query isn't correctly translated (#7888)
• Query: Stop producing N+1 queries for cases where single element subquery is projected inside a DTO (#7882)
• Query: Query: Query containing subquery with annonymous type fails to translate to server (#7844)
• Query: Errorneous IS NULL check in SQL causing repetitive null checks or invalid SQL with coalesce (#7784)
• Query: DateTime.Add* functions throw exception when argument is larger than int range (#7756)
• Query: Property '...' is not defined for type for GroupBy with projection and ordering (#7740)
• Query: InvalidCastException when trying to Round int cast to double (#7700)
• Query: Aggregate operator generates wrong SQL with Top/Skip/Distinct (#7693)
• Query: Subquery.contains generates invalid SQL (#7666)
• Reverse engineering: Scaffolding reads and creates "hypothetical" indexes (#7665)
• Query: InvalidCastException on Where with Any (#7657)
• Query: incorrect query plan produced for complex query with groupjoins (#7654)
• Query: JOIN/Left-outer-join queries wrapped in client projection could be simplified to ShapedQueries to reduce client evaluation (#7648)
• Query: Nullable foreign-key can lead to client evaluation (#7616)
• Tools: Current Directory is wrong for .NET Core projects (#7588)
• Reverse engineering: SQL Server User Defined Data Type cannot be reverse engineered (#7576)
• Query: Navigations: Inverse one-to-one references not rewritten (#7573)
• Query: Translating Date using ".Contains" (#7548)
• Model configuration: Ignoring base types can leave behind unnecessary discriminator column (#7539)
• Migrations: AlterColumn tries to drop non-existing index on SQL Server (#7535)
• Query: Distinct followed by other operations can give rise to incorrect SQL (#7525)
• Query: Skip with Count always returns 0 (#7523)
• Query: Where() on derived property fails with undefined property on base class exception (#7499)
• Query: Error calling Count() after GroupJoin() (#7497)
• Tools: Finding runtime 1.2 compatible tools? (#7492)
• Model configuration: Non-primitive properties cannot be configured to use supported store type (#7488)
• Query: invalid cast for queries with nullable bool and coalesce (#7452)
• Query: Relational OfType op selects unnecessary columns (#7451)
• DbContext: Make AddAsync and AddRangeAsync really async (#7446)
• Query: Wrong Sql emitted when doing a .Distinct() query on a one-to-one join (#7421)
• Query: GroupJoin and SelectMany fails to translate (#7417)
• DbContext: Throw for explicit loading of an un-tracked entity (#7388)
• Model configuration: Shadow primary key should behave the same as non-shadow primary key (#7377)
• Query : ToString() method that takes a formatter argument should do client evaluation (#7364)
• Query: In TPH inheritance, int discriminator does not work, exception is thrown when compiling query (#7359)
• Query: Reference Include in derived type with siblings throws invalid cast expression (#7312)
• Query: Set operations applied after casting throws exception (#7280)
• Query: Set Operations throw ArgumentNullException when second source is DbSet (#7279)
• Query: Using Or instead of ElseOr, etc. can result in unexpected SQL (#7271)
• Model configuration: Changing PK of principal type loses the user configured index info on FK property (#7254)
• DbContext: Possible race condition affecting DbContext pooling (#7251)
• Query: Selecting column from wrong table when filtering on navigation property and using skip/take (#7220)
• Model configuration: Don't throw when SqlServer ValueGenerationStrategy is configured on an incompatible property by a convention (#7208)
• Query: compilation error for queries with navigations that also compare same navigation to null (#7207)
• Infrastructure: KeyPropagator doesn't propagate the temporality of values (#7203)
• SaveChanges: Unique indexes not taken into account during topological sort (#7193)
• Query: IncludeResultOperator not implemented in some client eval cases (#7187)
• Query: OrderBy with Contains emits invalid SQL to the DB (#7178)
• Query: Bad lifting causes some LINQ expressions to be evaluated locally when .Include() is involved (#7164)
• DbContext: Identity value generation cannot be used because the property type is byte (#7161)
• Query: Left Outer Join created incorrectly for some Skip/Take patterns (#7137)
• Query: Sum fails with "specified cast is not valid" when single/double mismatch (#7136)
• DbContext: Collection was modified; enumeration operation may not execute in some graph attach cases (#7119)
• Infrastructure: Redundant call to String.Format() in the RelationalLogger class (#7112)
• Query: 'SUM' is not a recognized built-in function name when using coalese (#7103)
• Query: Client evaluation warnings and invalid SQL generated with certain null checks (#7102)
• DbContext: ExecuteSqlCommand has poor usability when used with params and cancellation tokens (#7100)
• Infrastructure: DbSetInitializer does not check if type is not added to model (#7094)
• Query: .Where() ignored before .DefaultIfEmpty() (LEFT JOIN) (#7080)
• Infrastructure: AfterExecuteCommand tracing is missing the result info (#7073)
• Model configuration: Incorrect key discovery can result in exception saying another instance has same key, but it doesn't (#7049)
• Query: FromSql not composing with LINQ when it contains certain whitespace patterns (#7005)
• Query: Wrong SQL generated for query with group join on a subquery that is not present in the final projection (#7003)
• Query: Complex query with navigation properties, Contains, and client eval produces invalid query plan (#6997)
• Query: SubQuery with Aggregates causes unneeded queries in 1.0.0 and throws exception in 1.1.0-preview2-22683 (#6982)
• Model configuration: Configuring one-to-one in OnModelCreating causes NullReferenceException (#6957)
• Query: Contains on element coming from optional navigation doesn't get server-evaluated (#6937)
• Query: Expecting client eval warnings on Last and LastOrDefault query extensions (#6929)
• Query: System.ArgumentException: must be reducible node when using ternary operator (#6921)
• Query: Rewrite Principal key access to FK access only if FK entity is not projected out (#6896)
• Query: ArgumentOutOfRangeException when using DefaultIfEmpty() on a collection navigation in conjunction with SelectMany (#6879)
• Migrations: Attempt better ordering when adding computed columns (#6853)
• Query: Related tables sometimes result in incorrect type of join (#6844)
• Model configuration: Overlapping optional and required FKs results in attempt to null out properties inappropriately (#6840)
• Migrations: Parameterless DbContext constructor is used in preference to overload taking DbContextOptions (#6826)
• Query: Projection with nested query fails with crashing SQL query (#6824)
• Model configuration: A property that will be shadow and is used as part of an FK must be configured as a shadow property first (#6823)
• Query: NullReferenceException when property isn't marked as nullable but there is null data (#6818)
• Model configuration: Properties not always lifted correctly when using derived classes (#6814)
• Model configuration: FK exception with some combinations of property names and inheritance (#6792)
• Query: Where clause on optional reference navigation throws exception (#6782)
• Query: Include with OrderBy with Skip(0) cause OrderBy to be ignored (#6736)
• SaveChanges: The temporarity of a value is not restored after an exception during SaveChanges (#6720)
• Query: Simplifying Ternary expression in body of a Linq query breaks the query. (#6695)
• Migrations: SQLite should ignore schema rather than throwing. (#6679)
• Query: Left Join (GroupJoin) always materializes elements resulting in unnecessary data pulling (#6647)
• Query: Include doesn't work with SelectMany (#6451)
• Query: The wrong type is being selected when an extension method is used in a subquery (#6383)
• Query: Subquery comparison to null is translated incorrectly (#6353)
• Reverse engineering: Navigation properties should not be virtual by default (#6326)
• Query: orderby + include + complex projection doesn't work (#5612)
• Query: Group by on Join without DefaultIfEmpty throws ArgumentException (#5171)
• Query: Repeated joins generated for repeated .Include().ThenInclude() (#4900)
• Query: "The EF.Property method may only be used within LINQ queries" and unnecessary client-side evaluation triggered in certain generic usages (#4875)
• Query: Aggregate function over subquery produces incorrect SQL (#3792)

Bugs Fixed

• Query : SqlServerMathRoundTranslator wrong argument index results in returning incorrect data or throwing InvalidCastException (#7600)
• Fix reflection object equality comparisons. (#7591)
• Query : client-side result operators may cause extensive client-side evaluation for queries with GroupJoins (and/or optional navigations) in a subquery (#7476)
• Some result operators (e.g. Distinct) after selecting a property generate incorrect SQL if query also contains optional navigation or explicit GroupJoin call (#7348)
• EntityEntry.OriginalValues APIs incorrectly return current values (#7332)
• Child entities not persisting when using AddRangeAsync and SaveChangesAsync (#7298)
• Queries fail after upgrading to EF Core 1.1 (#7293)
• Query compilation error or data corruption for queries with GroupJoin wrapped in a subquery when the subset of columns is being projected (#7290)
• Query : Compilation error for queries with optional navigation, client side method and parameter (#7289)
• InverseProperty attribute doesn't always resolve navigation property ambiguity (#7266)
• Infinite loop in compiled query cache (#7230)
• EF Core 1.1 IsModified is not working (#7227)
• EFCore 1.1 doesn't use an existing property for the FK if it's part of the primary key (#7127)
• ThenInclude Method not found (#7116)
• DB query is executed with the parameters of the previous query (#7115)
• KeyAttribute specified on multiple properties creates an incorrect model (#7084)
• Uniquify index names (#7082)
• The binary operator Equal is not defined for the types 'System.Nullable`1[System.Boolean]' and 'System.Boolean' error for queries with complex predicates involving nullable boolean properties (#7061)
• StackOverflowException with InversePropertyAttribute on 1.1.0 (#7057)
• EF Core 1.1 .ToString() translation causes exception (#7048)
• v1.1 - The multi-part identifier "x.Id" could not be bound (#7033)
• [DatabaseGenerated(DatabaseGeneratedOption.Identity)] incorrectly configures the column as SqlServer identity (#7010)
• Materialization uses incorrect column value with multiple derived types and shadow properties (#6986)
• Error when using async queries involving result operators and projecting a collection (N+1 queries scenario) (#6534)

Features

• Tools: Better ConfigureDesignTimeServices entry point (#5617)

Bugs Fixed

• Query: Entities not being released due to leak in query caching (#6737)
• Query: Regression in 1.0.1 causes query with GroupBy on multiple keys to throw exception (#6620)
• Query: Select with Ternary Operator/CASE-WHEN Server Side Evaluation (#6598)
• Query: Connection is not closed after executing a query including a collection (#6581)
• Query: Take() with Include() generates incorrect SQL (#6530)
• Query: Include() for related collections are dropped when use Skip() (#6492)

The items listed below were completed after 1.1.0-preview1. The 1.1.0 release also includes the items listed for the 1.1.0-preview1 release.

Features

• Allow navigation backing fields to be assign-compatible (#6893)

Bugs Fixed

• Breaking changes in 1.1 affecting SapientGuardian MySQL provider (#6926)
• Method not found: 'System.String Microsoft.EntityFrameworkCore.Metadata.Internal.EntityTypeExtensions.DisplayName(Microsoft.EntityFrameworkCore.Metadata.IEntityType)'. (#6914)
• Misspelling in Find() Intellisense (#6876)
• Don't remove unique indexes covered by other unique indexes (#6875)
• NullReferenceException in ForeignKeyPropertyDiscoveryConvention.Apply (#6867)
• Query: Track proper table alias for star projection (#6785)
• LINQ Any() statement generates invalid SQL (#6710)
• Commands: Use MSBuild to get project metadata (#6139)