EFCore scaffold

Question

I am trying to create a Model, by using scaffold:

dotnet ef dbcontext scaffold "DataSource=database.sqlite" Microsoft.EntityFrameworkCore.Sqlite -o Model

But this return error:

Could not scaffold the foreign key 'PoolsInDepartments(pools_id)'. A key for 'id' was not found in the principal entity type 'Pools'.
Could not scaffold the foreign key 'PoolsInDepartments(departaments_id)'. A key for 'id' was not found in the principal entity type 'Departments'.

I don't understund where error in my PoolInDepertaments table. Please, check my database: https://pastebin.com/Mmi6fnrV

And diagram for this DB:

https://i.stack.imgur.com/TV7EB.png

I uploading sqlite3 file https://www.sendspace.com/file/hwixx7 — Ruslan, Jun 12 '18 at 14:33

score 0 · Answer 1 · answered Jul 08 '18 at 08:53

0

Try with this command:

Scaffold-DbContext "Filename=mydatabase.sqlite3" Microsoft.EntityFrameworkCore.Sqlite -OutputDir Models

I use this since the first versions of EF Core until the new 2.1 and it works for me.

answered Jul 08 '18 at 08:53

Álvaro García

18,114
30
102
193

EFCore scaffold

1 Answers1