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]

Haii it's me again. I tried scaffold with --schema option, and i think it's work because i found new error.

When i searched there's only one with column 'ID_HIS_TUKIN'

# Here's detail data

SCHEMA_NAME : TDES
TABLE_NAME : HIS_TUKIN
TABLE_OID : 1,270,955
COLUMN_NAME : ID_HIS_TUKIN
POSITION : 1
DATA_TYPE_ID : 12
DATA_TYPE_NAME : VARCHAR
OFFSET : 72
LENGTH : 32
SCALE : [NULL]
IS_NULLABLE : FALSE
DEFAULT_VALUE : SYSUUID
COLLATION :
COMMENTS : [NULL]
MAX_VALUE : [NULL]
MIN_VALUE : [NULL]
CS_DATA_TYPE_ID : 83
CS_DATA_TYPE_NAME : STRING
DDIC_DATA_TYPE_ID : 32
DDIC_DATA_TYPE_NAME : INVALID
COMPRESSION_TYPE : DEFAULT
INDEX_TYPE : FULL
COLUMN_ID : 1,294,853
PRELOAD : FALSE
GENERATED_ALWAYS_AS : [NULL]
HAS_SCHEMA_FLEXIBILITY : FALSE
FUZZY_SEARCH_INDEX : FALSE
FUZZY_SEARCH_MODE : [NULL]
MEMORY_THRESHOLD : [NULL]
LOAD_UNIT : DEFAULT
GENERATION_TYPE : [NULL]
IS_CACHABLE : FALSE
IS_CACHE_KEY : FALSE
ROW_ORDER_POSITION : [NULL]
IS_HIDDEN : FALSE
IS_MASKED : FALSE
MASK_EXPRESSION : [NULL]
CLIENTSIDE_ENCRYPTION_STATUS : [NULL]
CLIENTSIDE_ENCRYPTION_COLUMN_KEY_ID : [NULL]
CLIENTSIDE_ENCRYPTION_MODE : [NULL]
PERSISTENT_MEMORY : [NULL]
NUMA_NODE_INDEXES : [NULL]

# Here;s DDL from the table HIS_TUKIN