public static void CreateSchemas(HtmlDbContext dbContext)
{
dbContext.Database.ExecuteSqlCommand(@"
IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'plugin')
BEGIN
EXEC('CREATE SCHEMA plugin')
END
");
}
public static void CreateTables(HtmlDbContext dbContext)
{
if (!dbContext.Database.TableExists("plugin.NavBar"))
{
dbContext.Database.ExecuteSqlCommand(@"
CREATE TABLE [plugin].[NavBar] (
[Id] NVARCHAR (50) NOT NULL,
[ItemWidth] NVARCHAR (50) NULL,
[NavMenuId] NVARCHAR (50) NULL,
CONSTRAINT [PK_NavBar] PRIMARY KEY CLUSTERED ([Id] ASC)
)
");
}
}
