I need to create a schema before the first table is created because it relies on it to exist.
I have tried Add-Migration CreateSchema
with and without the flag -IgnoreChanges
and then replaced Up and Down methods with my SQL script.
The issue is that then, after the command Add-Migration InitialCreate -Verbose
creates an empty migration in both cases.
I need to create the schema first because my table attribute [Table("schema.TableName")]
in the C# class is in lowercase, but the schema should be in uppercase (SCHEMA
).