Postgreapp

今回の記事はpostgreSQLを使って簡単なSQL操作をメモします。まずはpostgresppをダウンロードし、セットアップしてください。そして、PSequelというGUIを使ってDBを操作します。postgreAppsudo mkdir. I am using postgresapp for the PostgreSQL and without password I was able to connect to the database and perform operations. I am curious to learn about the password. Also I use Postico as Interface. Postgres.app is a full featured PostgreSQL installation packaged as a standard Mac app.

  1. Postgres Append Columns
  2. Postgres App Windows
  3. Postgres App
  4. Postgres Append String

loading...

我已经通过nuget添加了 Microsoft.AspNetCore.Identity.EntityFrameworkCore .

启动

Postgreapp

Postgres Append Columns

在StartUp'配置中,我添加了以下内容:

这是我的代码:

然后我得到这个:

Postgres App Windows

System.InvalidOperationException:类型为text的Column Id具有ValueGenerated.OnAdd,但在Microsoft.EntityFrameworkCore.Migrations.NpgsqlMigrationsSqlGenerator.ColumnDefinition(字符串模式,字符串表,字符串名称,类型clrType,字符串类型,Nullable1 unicode,Nullable1)中未定义默认值 . maxLength,Boolean rowVersion,Boolean nullable,Object default Value,String defaultValueSql,String computedColumnSql,IAnnotatable annotatable,IModel model,MigrationCommandListBuilder builder),位于Microsoft的Microsoft.EntityFrameworkCore.Migrations.MigrationsSqlGenerator.ColumnDefinition(AddColumnOperation操作,IModel模型,MigrationCommandListBuilder构建器) . Microsoft.EntityFrameworkCore.Migrations.MigrationsSqlGenerator.Generate中的EntityFrameworkCore.Migrations.MigrationsSqlGenerator.Generate(CreateTableOperation操作,IModel模型,MigrationCommandListBuilder构建器,布尔终止)(CreateTableOperation操作,IModel模型,MigrationCommandListBuilder构建)呃)Microsoft.EntityFrameworkCore.Migrations.MigrationsSqlGenerator.Generate(MigrationOperation操作,IModel模型,MigrationCommandListBuilder构建器),位于Microsoft.EntityFrameworkCore.Migrations.MigrationsSqlGenerator.Generate(IReadOnlyList`1操作,IModel模型),位于Microsoft.EntityFrameworkCore.Migrations.Internal . Microsoft.EntityFrameworkCore.Tools.Cli.DatabaseUpdateCommand中Microsoft.EntityFrameworkCore.Design.MigrationsOperations.UpdateDatabase(String targetMigration,String contextType)上的Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.Migrate(String targetMigration)中的Migrator.GenerateUpSql(迁移迁移) . <> c__DisplayClass0_0.b__0()at Microsoft.Extensions.CommandLineUtils.CommandLineApplication.Execute(String []
args)at Microsoft.EntityFrameworkCore.Tools.Cli.Program.Main(String [] args)text类型的文字ID具有ValueGenerated.OnAdd但没有定义默认值

Postgres App

我该如何解决这个问题?

Postgres Append String

  • c#postgresqlasp.net-coreasp.net-identityentity-framework-core