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

[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.