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,

Sorry for not getting back to you sooner. I tried to create the HIS_TUKIN table with the schema. But it always fails with the following error.

"sql syntax error: incorrect syntax near: line 5 col 21 (at pos 136)"

If I remove all CS_ types, I can create the table and scaffold code for it.

Which server version are you using? Do you know of any configuration settings which can enable the use of CS_ types?

Kind regards,

Minghai Chang

[kerria]

Server version i've using is 2.00.074.00.1698716871, and for configuration about CS_types i think is default from begining because nether i don't know anything about CS_types