denis-ivanov / EntityFrameworkCore.ClickHouse

ClickHouse provider for Entity Framework Core.
https://clickhouse.tech/
16 stars 3 forks source link

(Question) Support for MATERIALIZED and/or ALIAS? #52

Closed TPCharts closed 1 week ago

TPCharts commented 1 month ago

I'm considering using MATERIALIZED and/or ALIAS columns, if available.

Does this library currently support these, or anything similar?

Entity Framework computed columns: https://learn.microsoft.com/en-us/ef/core/modeling/generated-properties?tabs=data-annotations#computed-columns

ClickHouse Materialized columns: https://clickhouse.com/docs/en/sql-reference/statements/create/table#materialized

ClickHouse Alias columns: https://clickhouse.com/docs/en/sql-reference/statements/create/table#alias

denis-ivanov commented 1 month ago

https://github.com/denis-ivanov/EntityFrameworkCore.ClickHouse/blob/master/EntityFrameworkCore.ClickHouse/Migrations/ClickHouseMigrationsSqlGenerator.cs#L21

Yes, it does