EntityFramework Npgsql DbConfiguration不起作用 [英] EntityFramework Npgsql DbConfiguration doesn't work
问题描述
我正在尝试使用Npgsql首先使用代码配置EntityFramework。
Im trying to configure EntityFramework with Npgsql with code first.
- EntityFramework 6.1.3
- Npgsql 3.0.5
现在,我想按类设置自定义配置,让我们看看:
Now, i want to set a custom configuration by a class, let's see:
public class DbConfig : DbConfiguration
{
public DbConfig()
{
SetProviderFactory("Npgsql", Npgsql.NpgsqlFactory.Instance);
SetProviderServices("Npgsql", provider: NpgsqlServices.Instance);
SetDefaultConnectionFactory(new NpgsqlConnectionFactory());
}
}
和我的上下文类:
[DbConfigurationType(typeof(DbConfig))]
public class Db: DbContext
{
public virtual DbSet<Products> Products {get;set;}
public Db(DbConnection Connection): base(Connection, true)
{
}
public Db(): base()
{
}
public Db(string connectionString): base(connectionString)
{
}
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
modelBuilder.Conventions.Remove<OneToManyCascadeDeleteConvention>();
modelBuilder.Conventions.Add<CascadeDeleteAttributeConvention>();
modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();
modelBuilder.HasDefaultSchema("public");
base.OnModelCreating(modelBuilder);
}
}
然后,我尝试访问产品:
And I try to get access to Products:
class Program
{
static void Main(string[] args)
{
Db.ConfigureMigrations();
string connectionString = "Server=localhost;Port=5432;Database=stockDb;User Id=postgres;Password=123456;";
using (var C = new Db(connectionString))
{
var productos = C.Productos.Count();
Console.WriteLine(productos);
}
Console.WriteLine("listo");
Console.ReadKey();
}
}
但是我有一些例外:
- EntityFramework.dll中发生了'System.Data.Entity.Core.ProviderIncompatibleException'。内部异常:{提供程序未返回ProviderManifestToken字符串。}
或:
初始化字符串的格式不符合从索引0开始的规范。
The format of the initialization string does not conform to specification starting at index 0.
我不知道怎么了。
我得到了参考:
https://msdn.microsoft.com/en-us/data/jj680699.aspx
csomeone可以帮我吗?
csomeone can help me?
推荐答案
我解决了这个问题:
问题与Db.ConfigureMigrations();
The problem is with Db.ConfigureMigrations(); line.
如果我正确地注释了该行,但是我需要迁移,那么在我的ConfigureMigrations方法的Db上下文中,我需要更改:
if i comment that line all right, but i need the migrations, then in my Db context in my ConfigureMigrations method i need to change for:
Database.SetInitializer(new MigrateDatabaseToLatestVersion(true));
Database.SetInitializer(new MigrateDatabaseToLatestVersion(true));
仅此而已。
谢谢。
And that'a all. Thanks.
这篇关于EntityFramework Npgsql DbConfiguration不起作用的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!