public static bool CreateTable()
{
using (var context = ServiceLocator.Current.GetInstance<RedirectDbContext>())
{
context.Database.ExecuteSqlCommand(
@"CREATE TABLE [dbo].[" + RedirectTableName + @"](
[Id][int] IDENTITY(1, 1) NOT NULL,
[SortOrder][int] NOT NULL,
[FromUrl][nvarchar](max) NULL,
[ToUrl][nvarchar](max) NULL,
[ToContentId][int] NOT NULL,
[ToContentLang][nvarchar](10) NULL,
[Wildcard] [bit] NOT NULL DEFAULT ((0)),
CONSTRAINT[PK_dbo." + RedirectTableName + @"] PRIMARY KEY CLUSTERED
( [Id] ASC)WITH(PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON[PRIMARY]) ON[PRIMARY] TEXTIMAGE_ON[PRIMARY]
");
return TableExist = true;
}
}