public static void CreateSchemas(NavMenuDbContext dbContext)
{
dbContext.Database.ExecuteSqlCommand(@"
IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'plugin')
BEGIN
EXEC('CREATE SCHEMA plugin')
END
");
}
public static void CreateTables(NavMenuDbContext dbContext)
{
if (!dbContext.Database.TableExists("plugin.NavMenuWidget"))
{
dbContext.Database.ExecuteSqlCommand(@"
CREATE TABLE [plugin].[NavMenuWidget](
[Id] [nvarchar](50) NOT NULL,
[Title] [nvarchar](500) NULL,
[NavMenuId] [nvarchar](500) NULL,
CONSTRAINT [PK_NavMenuWidget] PRIMARY KEY CLUSTERED ([Id] ASC)
)
");
}
}
public static void InsertSeedData(NavMenuDbContext dbContext)
{
//dbContext.SaveChanges();
}
