Read-only temporal table columns with Linq2DB

Asked Dec 03 '22 at 14:56

Active Dec 03 '22 at 18:57

Viewed 86 times

I have this table with temporal columns:

CREATE TABLE [dbo].[Profile](
    [Id] [int] IDENTITY(1,1) NOT NULL,
    [CreatedDate] [datetime2](7) GENERATED ALWAYS AS ROW START NOT NULL,
    [UpdatedDate] [datetime2](7) GENERATED ALWAYS AS ROW END NOT NULL,
    PERIOD FOR SYSTEM_TIME (CreatedDate, UpdatedDate),
 CONSTRAINT [PK_Profile] PRIMARY KEY CLUSTERED 
(
    [Id] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]

I ran the CLI

dotnet linq2db scaffold -i database.json

I changed my models to have:

[Column(SkipOnUpdate=false, SkipOnInsert=false)]

For UpdatedDate and CreatedDate

But when I re-run the linq2db scaffold, it overwrites these attributes, is there a way of preventing that?

Created issue for this here: https://github.com/linq2db/linq2db/issues/3854

edited Dec 03 '22 at 18:57

asked Dec 03 '22 at 14:56

Hugo Forte

5,718
5
35
44

How do you scaffold? T4 or CLI? – Svyatoslav Danyliv Dec 03 '22 at 15:16
CLI, using dotnet linq2db scaffold -i database.json – Hugo Forte Dec 03 '22 at 15:24
Have you tried [this](https://linq2db.github.io/articles/CLI.html#customization-with-assembly)? – Svyatoslav Danyliv Dec 03 '22 at 16:05
Yeah - that would work, but I was hoping I would not have to write custom code and just do something like: --ignoreColumnWithName createdDate – Hugo Forte Dec 03 '22 at 17:54

Read-only temporal table columns with Linq2DB

0 Answers0