efcore.pg: Scaffold-DbContext - Unable to find design-time provider assembly.

I’ve created .NET Framework 4.6.1 Console project in VS 2015. I try to use EntityFrameworkCore with Npgsql.EntityFrameworkCore.PostgreSQL driver.

I have the following packages.config:

<?xml version="1.0" encoding="utf-8"?>
<packages>
  <package id="Microsoft.AspNetCore.Hosting.Abstractions" version="1.1.1" targetFramework="net461" />
  <package id="Microsoft.AspNetCore.Hosting.Server.Abstractions" version="1.1.1" targetFramework="net461" />
  <package id="Microsoft.AspNetCore.Http.Abstractions" version="1.1.1" targetFramework="net461" />
  <package id="Microsoft.AspNetCore.Http.Features" version="1.1.1" targetFramework="net461" />
  <package id="Microsoft.CSharp" version="4.3.0" targetFramework="net461" />
  <package id="Microsoft.EntityFrameworkCore" version="2.0.0-preview1-final" targetFramework="net461" />
  <package id="Microsoft.EntityFrameworkCore.Design" version="2.0.0-preview1-final" targetFramework="net461" />
  <package id="Microsoft.EntityFrameworkCore.Relational" version="2.0.0-preview1-final" targetFramework="net461" />
  <package id="Microsoft.EntityFrameworkCore.Relational.Design" version="2.0.0-preview1-final" targetFramework="net461" />
  <package id="Microsoft.EntityFrameworkCore.Tools" version="2.0.0-preview1-final" targetFramework="net461" developmentDependency="true" />
  <package id="Microsoft.Extensions.Caching.Abstractions" version="2.0.0-preview1-final" targetFramework="net461" />
  <package id="Microsoft.Extensions.Caching.Memory" version="2.0.0-preview1-final" targetFramework="net461" />
  <package id="Microsoft.Extensions.Configuration" version="2.0.0-preview1-final" targetFramework="net461" />
  <package id="Microsoft.Extensions.Configuration.Abstractions" version="2.0.0-preview1-final" targetFramework="net461" />
  <package id="Microsoft.Extensions.DependencyInjection" version="2.0.0-preview1-final" targetFramework="net461" />
  <package id="Microsoft.Extensions.DependencyInjection.Abstractions" version="2.0.0-preview1-final" targetFramework="net461" />
  <package id="Microsoft.Extensions.FileProviders.Abstractions" version="1.1.0" targetFramework="net461" />
  <package id="Microsoft.Extensions.Logging" version="2.0.0-preview1-final" targetFramework="net461" />
  <package id="Microsoft.Extensions.Logging.Abstractions" version="2.0.0-preview1-final" targetFramework="net461" />
  <package id="Microsoft.Extensions.Options" version="2.0.0-preview1-final" targetFramework="net461" />
  <package id="Microsoft.Extensions.Primitives" version="2.0.0-preview1-final" targetFramework="net461" />
  <package id="Microsoft.NETCore.Platforms" version="1.1.0" targetFramework="net461" />
  <package id="Microsoft.Packaging.Tools" version="1.0.0-preview1-25301-01" targetFramework="net461" />
  <package id="NETStandard.Library" version="2.0.0-preview1-25301-01" targetFramework="net461" />
  <package id="Npgsql" version="3.2.2" targetFramework="net461" />
  <package id="Npgsql.EntityFrameworkCore.PostgreSQL" version="2.0.0-preview1" targetFramework="net461" />
  <package id="Npgsql.EntityFrameworkCore.PostgreSQL.Design" version="2.0.0-preview1" targetFramework="net461" />
  <package id="Remotion.Linq" version="2.1.1" targetFramework="net461" />
  <package id="System.Collections" version="4.0.11" targetFramework="net461" />
  <package id="System.Collections.Immutable" version="1.3.1" targetFramework="net461" />
  <package id="System.ComponentModel" version="4.3.0" targetFramework="net461" />
  <package id="System.ComponentModel.Annotations" version="4.3.0" targetFramework="net461" />
  <package id="System.Data.Common" version="4.3.0" targetFramework="net461" />
  <package id="System.Diagnostics.Debug" version="4.0.11" targetFramework="net461" />
  <package id="System.Diagnostics.DiagnosticSource" version="4.3.0" targetFramework="net461" />
  <package id="System.Interactive.Async" version="3.1.1" targetFramework="net461" />
  <package id="System.Linq" version="4.1.0" targetFramework="net461" />
  <package id="System.Linq.Expressions" version="4.1.0" targetFramework="net461" />
  <package id="System.Linq.Queryable" version="4.0.1" targetFramework="net461" />
  <package id="System.ObjectModel" version="4.0.12" targetFramework="net461" />
  <package id="System.Reflection" version="4.1.0" targetFramework="net461" />
  <package id="System.Reflection.Extensions" version="4.0.1" targetFramework="net461" />
  <package id="System.Runtime" version="4.1.0" targetFramework="net461" />
  <package id="System.Runtime.CompilerServices.Unsafe" version="4.4.0-preview1-25305-02" targetFramework="net461" />
  <package id="System.Runtime.Extensions" version="4.1.0" targetFramework="net461" />
  <package id="System.Text.Encodings.Web" version="4.3.0" targetFramework="net461" />
  <package id="System.Threading" version="4.0.11" targetFramework="net461" />
  <package id="System.Threading.Tasks.Extensions" version="4.3.0" targetFramework="net461" />
  <package id="System.ValueTuple" version="4.3.0" targetFramework="net461" />
</packages>`

When I try to execute the following command in Package Manager Console:
Scaffold-DbContext "Host=localhost;Database=mydatabase;Username=myuser;Password=mypassword" Npgsql.EntityFrameworkCore.PostgreSQL

I get the following error: Unable to find design-time provider assembly. Please install the Npgsql.EntityFrameworkCore.PostgreSQL.Design NuGet package and ensure that the package is referenced by the project.

I’ve checked the bin\Debug directory of project and I see there both files: Npgsql.EntityFrameworkCore.PostgreSQL.dll and Npgsql.EntityFrameworkCore.PostgreSQL.Design.dll

About this issue

  • Original URL
  • State: closed
  • Created 7 years ago
  • Comments: 20 (6 by maintainers)

Most upvoted comments

Closing, this should no longer be relevant as design has been merged into the main EF Core assembly.