Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Entity Framework Weekly Status Updates (2020) #19549

Open
ajcvickers opened this issue Jan 10, 2020 · 2 comments
Open

Entity Framework Weekly Status Updates (2020) #19549

ajcvickers opened this issue Jan 10, 2020 · 2 comments
Milestone

Comments

@ajcvickers
Copy link
Member

@ajcvickers ajcvickers commented Jan 10, 2020

This issue contains status updates from the Entity Framework team to provide insight into what we are focused on, progress made, and other interesting highlights from the week.

More Information

Broader information on EF Core planning can be found in the EF Core roadmap.

Use GitHub queries to find full details of

Please note that there is never a guarantee that an issue will be fixed in its assigned release. Re-evaluation of the plan throughout the release cycle sometimes results in issues being pushed out to a later release.

Comments are disabled on this issue to reduce noise. Please use the related discussion issue for any comments on these status updates.

Previous years

Weekly status updates for 2019

@ajcvickers ajcvickers added this to the Discussions milestone Jan 10, 2020
@dotnet dotnet locked and limited conversation to collaborators Jan 10, 2020
@ajcvickers

This comment has been minimized.

Copy link
Member Author

@ajcvickers ajcvickers commented Jan 10, 2020

January 9, 2020

Expand to see status from this week...

We're back with weekly updates after a break for the holiday period.

What are we doing now?

Critical bugs in 3.1 are now being considered for patch releases. The first patch release is scheduled for later this month.

Planning for the EF Core "5.0" release (i.e. the one after 3.1) is being finalized and we hope to post an overview in the next couple of weeks.

Work on several major features planned for 5.0 has already begun. See the pull requests section below for details. The 115+ issues already fixed for 5.0 can be found on GitHUb

In addition, we are working on:

  • Technical debt
    • Code cleanup, additional testing, test reliability, etc.
  • Documentation
    • Updating docs to be cover changes in the 3.0 and 3.1 releases
    • An overhaul of the getting started docs to make them more approachable/easier to follow
    • Reorganization of docs to make things easier to find and to add cross-references
    • Adding more details and clarifications to existing docs
    • Updating the samples and adding more examples

Builds to use

  • The daily builds are the most up-to-date available.
    • Using the daily builds is a great way to find issues and provide feedback as early as possible. The sooner we get such feedback, the more likely it will be actionable before the next official release.
    • We work hard to keep the daily builds in good shape by running over 50,000 tests per TFM for each build.
    • Daily builds now contain work scheduled for release in EF Core 5.0.
    • There are already 115 issues closed and merged for EF Core 5.0.
  • Current and LTS: EF Core 3.1.0

New features in EF Core 5.0

As stated above, planning of 5.0 major features is ongoing, but in addition to bug fixes we have already merged a few small features/enhancements.

Simple way to get generated SQL

EF Core 5.0 introduces the ToQueryString extension method which will return the SQL that EF Core will generate when executing a LINQ query. For example, the code:

var query = context.Set<Customer>().Where(c => c.City == city);
Console.WriteLine(query.ToQueryString())

results in this output when using the SQL Server database provider:

DECLARE p0 nvarchar(4000) = N'London';

SELECT [c].[CustomerID], [c].[Address], [c].[City], [c].[CompanyName], [c].[ContactName], [c].[ContactTitle], [c].[Country], [c].[Fax], [c].[Phone], [c].[PostalCode], [c].[Region]
FROM [Customers] AS [c]
WHERE [c].[City] = @__city_0

Notice that declarations for parameters of the correct type are also included in the output. This allows copy/pasting to SQL Server Management Studio, or similar tools, such that the query can be executed for debugging/analysis.

Pull requests over the holiday period

Community contributions

Many thanks to all our contributors!

EF Core

Microsoft.Data.Sqlite

Issues remaining for 5.0

The burn-down will return for 5.0 once the plan is finalized.

Latest releases

EF Core:

EF6:

More Information

See the top of this issue for links to more information.

Comments are disabled on this issue to reduce noise. Please use the related discussion issue for any comments on these status updates.

@ajcvickers ajcvickers pinned this issue Jan 10, 2020
@ajcvickers

This comment has been minimized.

Copy link
Member Author

@ajcvickers ajcvickers commented Jan 16, 2020

January 16, 2020

EF Core 3.1.1

EF Core 3.1.1 is now available on NuGet. This is a patch release of 3.1 containing critical bug fixes.

EF Core 5.0

The initial plan for EF Core 5.0 is now live on our docs site.

This plan is not set-in-stone; we expect it will evolve throughout the release cycle as we learn. We are always grateful for your feedback so that it can influence this learning process, as well as influence future planning. Please use the Feedback links at the bottom of the document.

Themes for EF Core 5.0

The high-level themes for EF Core 5.0 are detailed in the 5.0 plan. These themes are:

  • Many-to-many navigation properties (a.k.a "skip navigations")
  • Table-per-type (TPT) inheritance mapping
  • Filtered Include
  • Rationalize ToTable, ToQuery, ToView, FromSql, etc.
  • General query enhancements
  • Migrations and deployment experience
  • EF Core platforms experience
  • Performance
  • Architectural/contributor documentation
  • Microsoft.Data.Sqlite documentation
  • General documentation
  • Fixing bugs
  • Small enhancements

Builds to use

  • The daily builds are the most up-to-date available.
    • Using the daily builds is a great way to find issues and provide feedback as early as possible. The sooner we get such feedback, the more likely it will be actionable before the next official release.
    • We work hard to keep the daily builds in good shape by running over 55,000 tests per target for each build.
    • Daily builds now contain work scheduled for release in EF Core 5.0.
    • There are already 120 issues closed and merged for EF Core 5.0.
  • Current and LTS: EF Core 3.1.1

Pull requests from the last week

Community contributions

Many thanks to all our contributors!

EF Core

Issues remaining for 5.0

The burn-down will return for EF Core 5.0 next week.

Latest releases

See EF Core releases and planning in our documentation for full details.

EF Core:

EF6:

More Information

See the top of this issue for links to more information.

Comments are disabled on this issue to reduce noise. Please use the related discussion issue for any comments on these status updates.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
1 participant
You can’t perform that action at this time.