Hi everyone, I'm having a problem When I'm trying to update-database in Postgre SQL I can't able to create all the table. I'm Using .net core 2.2 with angular
- I Install Npgsql.EntityFrameworkCore.PostgreSQL (package (Version 2.2.0))
- In GrantVantageDbContextConfigurer.cs i replace the builder.UseSqlServer method with builder.UseNpgsql method.
- in Migrations files i replace "SqlServer:ValueGenerationStrategy" with “Npgsql:ValueGenerationStrategy” and "IdentityColumn" with "NpgsqlValueGenerationStrategy.SerialColumn" and MaxLength of Value from 67108864 to 10485760
- and change it's connection
but can only able to create only 28 table instead of 35 table. But when i do it with sql server i'm able to create all 35 tables.
When trying to update database getting this error-
Posgre SQL- 
SQL Server - 
<span class="colour" style="color:rgb(0, 0, 0)">Can anybody help?</span>
6 Answer(s)
-
0
Have you seen this document? https://aspnetboilerplate.com/Pages/Documents/EF-Core-PostgreSql-Integration
Markdown is supportedCopy & paste or drag & drop images (max 30 MB per image) -
0
Thanks for your replay. I can't able to find Program.BuildWebHost() and when I Delete the *.EntityFrameworkCore/Migrations folder, it's giving me errors -
Markdown is supportedCopy & paste or drag & drop images (max 30 MB per image) -
0
Do not delete the Seed directory. Delete the migration file of the Migrations directory, and keep the Seed directory.
Markdown is supportedCopy & paste or drag & drop images (max 30 MB per image) -
0
I can't able to find Program.BuildWebHost().
Markdown is supportedCopy & paste or drag & drop images (max 30 MB per image) -
0
You can ignore this. Continue to try.
Markdown is supportedCopy & paste or drag & drop images (max 30 MB per image) -
0
It's working now, Thanks 😃.
Markdown is supportedCopy & paste or drag & drop images (max 30 MB per image)
