Entityframework Core Scaffold Database Model Stuck

[kerria]

I can't scaffold with Sap.EntityFrameworkCore.Hana.

v7.0, the process stuck for hours

[minghai_chang]

Hello,

Which client version are you using? Did you specify the "Current Schema", schemas, or tables? Here are some examples:

1. Install the Visual Studio PMC tools or the .NET CLI tools. Follow instructions of "Prerequisites" on

https://learn.microsoft.com/en-us/ef/core/managing-schemas/scaffolding/?tabs=vs

2. Create a .NET 6 C# console app (using Visual Studio 2022). Add

Sap.Data.Hana.Core.v2.1.dll and Sap.EntityFrameworkCore.Hana.v7.0.dll to the Project Reference.

3. Open a command prompt and CD <csproj directory>. Run the .NET CLI commands to scaffold entity types.

dotnet ef dbcontext scaffold "Server=<my-server:30015>;uid=<uid>;pwd=<pwd>r;Current Schema=DEMO" Sap.EntityFrameworkCore.Hana.v7.0

dotnet ef dbcontext scaffold "Server=<my-server:30015>;uid=<uid>;pwd=<pwd>" Sap.EntityFrameworkCore.Hana.v7.0 --schema DEMO --schema SYSTEM

dotnet ef dbcontext scaffold "Server=<my-server:30015>;uid=<uid>;pwd=<pwd>" Sap.EntityFrameworkCore.Hana.v7.0 --table Blogs --table Posts

Kind regards,

Minghai Chang

[minghai_chang]

Hello,

Yes, you can just specify several tables to scaffold the model (e.g. the 3rd example).

The first error looks like some tables are owned by different schemas. The second error looks like REF_SSBP table doesn't have primary key.

Kind regards,

Minghai Chang

[kerria]

but if i use 3rd example, that means i must set --table for each table? isn't that inefficient? i mean in this project we have tables more than 100.

table that mention in error are in the same schema, i think why error occurs because class model for table not generated, that's why i need scaffold using 'schema'.

table REF_SSBP of course have Primary Key

------------

Disclaimer

this is the old system that need rejuvenate, previously we use ADO.NET at .NET Framework for scaffold model. but since .NET Core / .NET has launched we must change everything that related to .NET Framework to .NET Core / .NET.

At ADO.NET we can select the schema we want to scaffold. Since it's using Gui we just checked the checkbox of schema name and click button okey at visual studio.