Entity Framework 6.2 Emerges Out of Preview

This more fully-fledged version of Microsoft's object relational/mapper is now at the initial beta testing stage, with quicker startups and a number of fixes from the preview, but there's also more work to do to resolve some issues that can impact EF providers. Also: a list of new features of the EF Core 2.0 preview released at Build.

A version of the Entity Framework runtime has emerged out of preview, and it's now in the initial beta stage. Dubbed EF 6.2 Beta 1, it comes with a number of fixes for issues that surfaced in the preview, and it's now faster at startup. But there is some work to do, and the .NET team is looking for help to resolve some issues impacting EF providers.

"We suspect some of the existing EF providers could be negatively impacted by a fix included in our tooling in this release, and we are asking for help from provider writers to validate this hypothesis," wrote Diego Vega, a program manager with Microsoft's EF team, in a blog post.

"The fix addresses a long-standing problem with schema discovery queries used in the 'Update model from database' feature of the EF tools," he explained. "When using the feature against a database with a large number of objects, the schema discovery queries can contain large numbers of parameters." He noted that SQL Server is limited of 2,100 parameters per query, and failures can occur with models that contain more than 300 objects because of the complexity with how queries and parameters are generated. So, the workaround, he said was to reduce "the number of parameters required by schema discovery queries by reusing parameter objects for each distinct value." A more detailed explanation of the fix is in this pull request on GitHub.

Vega noted that the fix was implemented in shared code and applied to all providers, but because of the way some providers "implement schema discovery by matching patterns in the schema discovery queries and then translating those patterns into calls to their native schema discovery API calls," the fix might actually break with some of those providers.

It's worth noting that Entity Framework continues to be enhanced and improved, even though the runtime is being superseded in future versions of Visual Studio with Entity Framework Core. EF Core is currently at version 1.0, with a version 2.0 preview made available at Build earlier this month. As such, EF 6.2 Beta 1 consists mainly of improvements and fixes, of which these ones were highlighted in Vega's blog:

  • Reduce start up time by loading finished code first models from a persistent cache
  • Fluent API to define indexes
  • EF tools Update Model issue when provider reports nullable keys
  • Add DbFunctions.Like() to enable writing LINQ queries that translate to LIKE in SQL
  • Migrate.exe should support -script option
  • Updating large models from database can make sp_executesql fail with too many parameters

The blog post also provides guidance on downgrading back to the originally installed EF tooling install, should developers run into issues using this initial beta.

The beta release of EF 6.2 runtime follows a preview release of EF Core 2.0 that was let loose at Build a few weeks ago. Microsoft describes EF Core as a "lightweight, extensible, and cross-platform version" of EF. Among the improvements to this version:

  • Enhanced LINQ translations and query execution
  • Addition of EF.Functions property that EF Core or providers can use "to define methods that map to database functions or operators so that those can be invoked in LINQ queries"
  • Types can be mapped even though they might not "posses their own identity and for which instances can only be tracked and referenced as dependents of instances of other entity types"
  • Global query filters
  • DbContext pooling
  • Manual compiled queries are more performant

Details of each of these features are contained in this blog post.

About the Author

Michael Domingo is a long-time software publishing veteran, having started up and managed several developer publications for the Clipper compiler, Microsoft Access, and Visual Basic. He's also managed IT pubs for 1105 Media, including Microsoft Certified Professional Magazine and Virtualization Review before landing his current gig as Visual Studio Magazine Editor in Chief. Besides his publishing life, he's a professional photographer, whose work can be found by Googling domingophoto.

comments powered by Disqus


  • GitLab Takes Over VS Code Extension, Plans Improvements

    DevOps specialist GitLab has officially taken over the control of a GitLab extension for Microsoft's open source, cross-platform Visual Studio Code editor.

  • VS Code Python Tool Now Does Native Notebooks

    The Python Extension for VS Code Insiders team is previewing the newest implementation of notebooks, used frequently in data science with offerings such as Jupyter Notebooks.

  • As .NET 5 Nears, Content/Documentation Reorganization Starts

    A GitHub project is seeking to reorganize documentation and developer content in advance of the November debut of .NET 5, a unification of all things .NET that combines. .NET Core and other components.

  • Windows Devs Get Cross-Platform Page, Issues Repo

    Developers doing their coding on the Windows OS have received two new resource gifts from Microsoft: a new landing page for those using cross-platform technologies and a new GitHub repo with which to report issues to Windows engineering teams.Developers doing their coding on the Windows OS have received two new resource gifts from Microsoft: a new landing page for those using cross-platform technologies and a new GitHub repo with which to report issues to Windows engineering teams.

  • What's New in Entity Framework Core 5.0 Preview 7

    Microsoft shipped the seventh preview of Entity Framework Core 5.0, boosting its data access technology with a factory to create DbContext instances and more.

.NET Insight

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.

Upcoming Events