Entity Framework PowerShell script cannot be loaded by Visual Studio because its operation is blocked by software restriction policies
When I load Package Manager Console within Visual Studio 2017 v15.9.6 in a project that uses Entity Framework I receive the following error:
\packages\EntityFramework.6.2.0\tools\init.ps1 cannot be loaded because its operation is blocked by software restriction policies, such as those created by using Group Policy. At line:1 char:45 + ... rgs+=$_}; & 'C:\Bitbucket\project-path\packages\EntityFramework.6.2. ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : SecurityError: (:) [], PSSecurityException + FullyQualifiedErrorId : UnauthorizedAccess
This prevents me from running commands specific to Entity Framework like "Update-Database" or "Add-Migration".
Here are things I have tried:
- Reinstall Visual Studio
In Group Policy Editor, for both Computer Configuration and User Configuration, I have enabled the setting "Turn on Script Execution" that is located at "Administrative Templates\Windows Components\Windows PowerShell". The setting for both configurations has the "Execution Policy" set to "Allow all scripts".
I've tried locally in the Package Manager Console setting the "Process" scope to both "Bypass" and "Unrestricted", and then manually loading the Entity Framework init.ps1 script. I receive the same error.
- I've also tried modifying registry keys for PowerShell to set the ExecutionPolicy to "Unrestricted" in a few places. Those places are at:
- HKLM\Software\Microsoft\PowerShell\1\ShellIds\Microsoft.PowerShell
- HKLM\Software\Microsoft\PowerShell\1\ShellIds\Microsoft.SqlServer.Management.PowerShell.sqlps120
- HKLM\Software\Microsoft\PowerShell\1\ShellIds\Microsoft.SqlServer.Management.PowerShell.sqlps140
- I've restarted multiple times in between doing all of the above.
When I run the command "Get-ExecutionPolicy -List", here are my results"
Scope ExecutionPolicy
----- -----------------------
MachinePolicy Undefined
UserPolicy Unrestricted
Process Undefined
CurrentUser Unrestricted
LocalMachine Unrestricted
After all of the above I expected to be able to just load Visual Studio as normal, launch Package Manager Console, and not receive any errors when it tries to run the Entity Framework init.ps1 script. I must be missing something or doing something incorrectly. What do I need to do to get Visual Studio to work as expected?
Some more information is that this is a computer joined to a company domain, but no other developers have this issue. There isn't a group policy set by an administrator that is trickling down preventing me from running scripts.
The error may be occurring because of an invalid certificate from Microsoft. Check in Control Panel => Internet Options => Content => Certificates on the Untrusted Publishers tab. Remove Microsoft Corporation from this list.
Sounds bizarre but it worked for me.
- How do I view the SQL generated by the Entity Framework?
- Log Queries executed by Entity Framework DbContext
- Use int Id for a bigint column in EF6
- Entity Framework not loading related objects
- What does the DBContext.Entry do?
- "where" clause: entity id is in a potentially null array
- Entity Framework query slow, but same SQL in SqlQuery is fast
- What is the right way to get data from related tables using an entity and business models separately in ASP.NET Core Web API?
- How to add a model in asp.net mvc project
- Entity Framework - Check for pending migrations
- Check for pending migrations in Entity Framework?
- How to use query with quotes inside a parent query
- Constructor injection into IDesignTimeDbContextFactory
- An error occurred while accessing the Microsoft.Extensions.Hosting services when do first migrations
- Can I create an app with swift to controle a go pro camera from the phone?
- EF Core navigation properties to both a collection and a specific item in the collection
- Assign Credentials (user name/password) to EF in Code
- How to get next value of SQL Server sequence in Entity Framework?
- How to set a default value on a Boolean in a Code First model?
- Catch SqlException at the controller level?
- BeginTransaction with IsolationLevel in EF Core
- in entity framework code first, how to use KeyAttribute on multiple columns
- Cannot access a disposed context instance EF core
- Multiple includes using Entity Framework and Repository Pattern
- Roslyn analyzer for checking syntax of SQL literals in VS2022?
- How do I add a row in Entity Framework?
- Why is the Entity Framework Model Browser not displaying?
- howt to Include related entities with filter condition using AsExpandable
- How to deal with a list of EF database first contexts and cast them correctly?
- Error Adding DataTable Rows to Entity Framework Invoices Table