Click here to Skip to main content
65,938 articles
CodeProject is changing. Read more.
Articles / entity-framework

VS2022, ver. 17.6.2 – EntityFramework6 Broken

5.00/5 (3 votes)
6 Jun 2023CPOL 7.9K  
Fix for adding new DB tables does not work in VS 2022, ver. 17.6.2, EF6 (Classic)
In Visual Studio 2022, ver. 17.6.2, Entity Framework 6 (Classic) is broken, adding new DB tables in the “Database-First” approach does not work. We are showing how to manually fix it.

Symptoms

  • In Visual Studio 2022, ver. 17.6.2, Entity Framework 6 (Classic) is broken, adding new DB tables in the “Database-First” approach does not work.
  • You get build error:
    Running transformation: System.NullReferenceException: 
    Object reference not set to an instance of an object.

Image 1

Reason

Seems like a bug in Visual Studio 2022, ver. 17.6.2.

Manual Fix

I tried steps from [1] by Chirag Prajapati and they worked:

====================================
Start Notepad in administrator mode, and open the file 
(substituting Community for Professional or Enterprise depending on your version):
C:\Program Files\Microsoft Visual Studio\2022\Community\Common7\IDE\Extensions\
Microsoft\Entity Framework Tools\Templates\Includes\EF6.Utility.CS.ttinclude

Update the following code in DynamicTextTransformation (approx line 1920) and change:

_generationEnvironment = type.GetProperty("GenerationEnvironment", 
                         BindingFlags.Instance | BindingFlags.NonPublic);

to

_generationEnvironment = type.GetProperty("GenerationEnvironment", 
BindingFlags.Instance | BindingFlags.NonPublic | BindingFlags.Public);
=================================================

Click to enlarge image

Click to enlarge image

Conclusion

Will please somebody post when that bug is fixed?

Reference

History

  • 6th June, 2023: Initial version

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)