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]

I'm not problem with only CLI. i'm just want tell when using ado.net we can scaffold by schema so several table can be generated at once, and don't have problem anything.

What my problem is 'Can i scaffold using --schema options'. Because when i use --schema options, it's say 'Hana doesn't support schema'

Unfortunately I can't post the entire schema, because it's written in my contract not to post anything.