Page Comparison

New Table:

• Id (PK, int)
• Name (nvarchar(255) not null)
• PreprocessorType (nvarchar(20), not null)
• ScriptContent (nvarchar(max) null)
• RequiresOdsApi (bit, not null)

Supports storage of PowerShell scripts.

EF Core note: Implement PreprocessorType as an enum.

New column:

• FileProcessorId (FK, int, null)

Removed columns:

• RowProcessor (nvarchar(max), null)
• FileGenerator (nvarchar(max), null)

New columns:

• RowProcessorId (FK, int, null)
• FileGeneratorId (FK, int, null)

Replace Custom Row Processor and Custom File Generator filenames with database references.

This will require a specialized migration:

• Create a preprocessor record with Name of the current value.
• Reference it from the new column, and drop the old column.
• On web application startup, for any Preprocessor records with a null ScriptContent value, get the file from the file system (by Name and known path per PreprocessorType) and populate contents into Script Content.