我有aspnet零项目,并试图与 Postgresql 一起使用它 . 我按照说明操作,当我试图 Update-Database
时,它给了我错误:
执行DbCommand失败(18ms)[Parameters = [],CommandType ='Text',CommandTimeout ='30']创建序列“AppSubscriptionPayments_Id_seq”开始1增加1 NO NOVALUE NO MAXVALUE NO CYCLE; ALTER TABLE“AppSubscriptionPayments”ALTER COLUMN“Id”TYPE int8; ALTER TABLE“AppSubscriptionPayments”ALTER COLUMN“Id”SET NOT NULL; ALTER TABLE“AppSubscriptionPayments”ALTER COLUMN“Id”SET DEFAULT(nextval('“AppSubscriptionPayments_Id_seq”')); ALTER SEQUENCE“AppSubscriptionPayments_Id_seq”拥有“AppSubscriptionPayments” . “Id”42P01:“AppSubscriptionPayments”对象不存在
我正在使用Postgresql 10,Visual Studio 2017和ASPNET Zero .
1 回答
从头开始删除所有现有迁移和添加迁移 .
确保添加迁移时没有现有数据库(在连接字符串中指定) . 如果您之前已经创建了数据库,则无法正确构建迁移 .
https://aspnetboilerplate.com/Pages/Documents/EF-Core-PostgreSql-Integration