Running transformation: System.NullReferenceException: Object reference not set to an instance of an object. Possible solution.

Running-transformation-NullReferenceException.md

The problem seems to be related to Visual Studio 2022 versions higher than 17.5.5

See the problem at: https://developercommunity.visualstudio.com/t/Cannot-import-anymore-tables-into-edmx/10368835 or https://developercommunity.visualstudio.com/t/Create-or-recreate-a-Model-does-not-work/10318478

Solutions:

• Use Visual Studio 2019 when updating the models, or
• Use Visual Studio 2022 version 17.5.5
• A possible solution I didn't used is suggested here: https://developercommunity.visualstudio.com/t/Create-or-recreate-a-Model-does-not-work/10318478#T-N10371304

The problem:

After generating a ".edmx.sql" file from Entity Framework, SQL script based on the Entity Data Model (EDM) defined in an Entity Data Model Designer (EDMX) file, I was getting the following error:

Running transformation: System.NullReferenceException: Object reference not set to an instance of an object.
   at Microsoft.VisualStudio.TextTemplating4BFC159FFC763A9FEF7F81C28AB81BA5E15C3D4A0C34D4B6E99C2F7D1565BC72EDDD4A4695F40920E6831837FEFF595ECC8510D6101E0FA5E132DB91F89A6490.GeneratedTextTransformation.DynamicTextTransformation.get_GenerationEnvironment()
   at Microsoft.VisualStudio.TextTemplating4BFC159FFC763A9FEF7F81C28AB81BA5E15C3D4A0C34D4B6E99C2F7D1565BC72EDDD4A4695F40920E6831837FEFF595ECC8510D6101E0FA5E132DB91F89A6490.GeneratedTextTransformation.EntityFrameworkTemplateFileManager..ctor(Object textTransformation)
   at Microsoft.VisualStudio.TextTemplating4BFC159FFC763A9FEF7F81C28AB81BA5E15C3D4A0C34D4B6E99C2F7D1565BC72EDDD4A4695F40920E6831837FEFF595ECC8510D6101E0FA5E132DB91F89A6490.GeneratedTextTransformation.EntityFrameworkTemplateFileManager.VsEntityFrameworkTemplateFileManager..ctor(Object textTemplating)
   at Microsoft.VisualStudio.TextTemplating4BFC159FFC763A9FEF7F81C28AB81BA5E15C3D4A0C34D4B6E99C2F7D1565BC72EDDD4A4695F40920E6831837FEFF595ECC8510D6101E0FA5E132DB91F89A6490.GeneratedTextTransformation.EntityFrameworkTemplateFileManager.Create(Object textTransformation)
   at Microsoft.VisualStudio.TextTemplating4BFC159FFC763A9FEF7F81C28AB81BA5E15C3D4A0C34D4B6E99C2F7D1565BC72EDDD4A4695F40920E6831837FEFF595ECC8510D6101E0FA5E132DB91F89A6490.GeneratedTextTransformation.TransformText()
   Running transformation: System.NullReferenceException: Object reference not set to an instance of an object.
   at Microsoft.VisualStudio.TextTemplating4BFC159FFC763A9FEF7F81C28AB81BA5E15C3D4A0C34D4B6E99C2F7D1565BC72EDDD4A4695F40920E6831837FEFF595ECC8510D6101E0FA5E132DB91F89A6490.GeneratedTextTransformation.DynamicTextTransformation.get_GenerationEnvironment()
   at Microsoft.VisualStudio.TextTemplating4BFC159FFC763A9FEF7F81C28AB81BA5E15C3D4A0C34D4B6E99C2F7D1565BC72EDDD4A4695F40920E6831837FEFF595ECC8510D6101E0FA5E132DB91F89A6490.GeneratedTextTransformation.EntityFrameworkTemplateFileManager..ctor(Object textTransformation)
   at Microsoft.VisualStudio.TextTemplating4BFC159FFC763A9FEF7F81C28AB81BA5E15C3D4A0C34D4B6E99C2F7D1565BC72EDDD4A4695F40920E6831837FEFF595ECC8510D6101E0FA5E132DB91F89A6490.GeneratedTextTransformation.EntityFrameworkTemplateFileManager.VsEntityFrameworkTemplateFileManager..ctor(Object textTemplating)
   at Microsoft.VisualStudio.TextTemplating4BFC159FFC763A9FEF7F81C28AB81BA5E15C3D4A0C34D4B6E99C2F7D1565BC72EDDD4A4695F40920E6831837FEFF595ECC8510D6101E0FA5E132DB91F89A6490.GeneratedTextTransformation.EntityFrameworkTemplateFileManager.Create(Object textTransformation)
   at Microsoft.VisualStudio.TextTemplating4BFC159FFC763A9FEF7F81C28AB81BA5E15C3D4A0C34D4B6E99C2F7D1565BC72EDDD4A4695F40920E6831837FEFF595ECC8510D6101E0FA5E132DB91F89A6490.GeneratedTextTransformation.TransformText()

It was a database model with 29 models.