IServiceCollection不包含AddNpgsql的定义或扩展

问题描述

我第一次尝试使用PostgreSQL，并且在没有错误的情况下进行构建会遇到一些麻烦，除非我锁定到RC2软件包中。锁定到RC2程序包后，出现了一个似乎无法撼动的错误，可以使用帮助疑难解答：

I'm trying to use PostgreSQL for the first time and having a little trouble getting it to build without errors unless I lock into RC2 packages which is fine. After locking into the RC2 packages, I have one error that I can't seem to shake that I could use help troubleshooting:

错误

Startup.cs(22,18): error CS1061: 'IServiceCollection' does not contain a definition for 'AddNpgsql' and no extension method 'AddNpgsql' accepting a first argument of type 'IServiceCollection' could be found (are you missing a using directive or an assembly reference?)

PROJECT.JSON

{
  "buildOptions": {
    "preserveCompilationContext": true,
    "emitEntryPoint": true,
    "warningsAsErrors": true,
    "debugType": "portable",

  "copyToOutput": {
      "include": [
        "wwwroot",
        "Views",
        "config.json",
        "web.config"
      ]
    }
  },

  "dependencies": {
    "AspNet.Security.OAuth.Introspection": "1.0.0-alpha1-final",
    "AspNet.Security.OAuth.Validation": "1.0.0-alpha1-final",
    "Microsoft.AspNetCore.Diagnostics": "1.0.0-rc2-final",
    "Microsoft.AspNetCore.Diagnostics.EntityFrameworkCore": "1.0.0-rc2-final",
    "Microsoft.AspNetCore.Server.IISIntegration": "1.0.0-rc2-final",
    "Microsoft.AspNetCore.Mvc": "1.0.0-rc2-final",
    "Microsoft.AspNetCore.Mvc.Formatters.Json": "1.0.0-rc2-final",
    "Microsoft.AspNetCore.Mvc.Cors": "1.0.0-rc2-final",
    "Microsoft.AspNetCore.Server.Kestrel": "1.0.0-rc2-final",

    "Microsoft.Extensions.Configuration.CommandLine": "1.0.0-rc2-final",
    "Microsoft.Extensions.Configuration.EnvironmentVariables": "1.0.0-rc2-final",
    "Microsoft.Extensions.Configuration.Json": "1.0.0-rc2-final",
    "Microsoft.Extensions.Logging.Console": "1.0.0-rc2-final",
    "Microsoft.Extensions.Logging.Debug": "1.0.0-rc2-final",

    "Microsoft.EntityFrameworkCore": "1.0.0-rc2-final",
    "Microsoft.EntityFrameworkCore.Commands": "1.0.0-rc2-*",
    "Microsoft.EntityFrameworkCore.Relational": "1.0.0-rc2-final",
    "Npgsql.EntityFrameworkCore.PostgreSQL": "1.0.0-*",
    "Microsoft.AspNetCore.Identity.EntityFrameworkCore": "1.0.0-rc2-final",

    "OpenIddict.Core": "1.0.0-*",
    "OpenIddict.EF": "1.0.0-*"
  },


  "frameworks": {
    "netcoreapp1.0": {
      "dependencies": {
        "Microsoft.NETCore.App": {
          "type": "platform",
          "version": "1.0.0-rc2-3002702"
        }
      },

      "imports": [
        "dnxcore50",
        "portable-net451+win8"
      ]
    }
  },

  "tools": {
    "Microsoft.AspNetCore.Server.IISIntegration.Tools": {
      "version": "1.0.0-preview1-final",
      "imports": "portable-net45+wp80+win8+wpa81+dnxcore50"
    }
  },

  "scripts": {
    "postpublish": "dotnet publish-iis --publish-folder %publish:OutputPath% --framework %publish:FullTargetFramework%"
  },

  "publishOptions": {
    "include": [
      "wwwroot",
      "Views",
      "config.json",
      "web.config"
    ]
  }
}

STARTUP.CS（部分）

public void ConfigureServices(IServiceCollection services)
{
    services.AddMvc();

    services.AddEntityFramework()
        .AddNpgsql()
        .AddDbContext<ApplicationContext>(options =>
            options.UseNpgsql("Host=localhost;Username=dev;Password=dev;Database=tesdb"));

    services.AddIdentity<tbl_ApplicationUser, tbl_ApplicationRole>()
        .AddEntityFrameworkStores<ApplicationContext>()
        .AddUserStore<CustomStore>()
        .AddDefaultTokenProviders()
        .AddOpenIddictCore<tbl_Application>
            (conf => conf.UseEntityFramework());

    services.AddAuthorization(options => {
        options.AddPolicy("Default", builder => {
            builder.RequireAuthenticatedUser();
            builder.RequireActiveUser();
        });

        options.DefaultPolicy = options.GetPolicy("Default");
    });

    services.AddTransient<IEmailSender, AuthMessageSender>();
    services.AddTransient<IDatabaseInitializer, DatabaseInitializer>();
    services.AddTransient<IUtilityService, UtilityService>();
    services.AddScoped<ICommonRepository, CommonRepository>();
}

推荐答案

RC2驱动程序已替换 AddNpgsql 和 AddEntityFrameworkNpgsql ，因此
替换此代码块：

The RC2 driver replaced AddNpgsql with AddEntityFrameworkNpgsql, soreplace this code block:

services.AddEntityFramework()
    .AddNpgsql()
    .AddDbContext<ApplicationContext>(options =>
        options.UseNpgsql("Host=localhost;Username=dev;Password=dev;Database=tesdb"));

与此一起：

services.AddEntityFrameworkNpgsql()
    .AddDbContext<ApplicationContext>(options => 
        options.UseNpgsql("Host=localhost;Username=dev;Password=dev;Database=tesdb"));

这篇关于IServiceCollection不包含AddNpgsql的定义或扩展的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！