public static bool RedirectTableExists()
{
using (var context = ServiceLocator.Current.GetInstance<RedirectDbContext>())
{
var t = context.Database.SqlQuery<int?>(@"
SELECT 1 FROM sys.tables AS T
INNER JOIN sys.schemas AS S ON T.schema_id = S.schema_id
WHERE S.Name = 'dbo' AND T.Name = '" + RedirectTableName + @"'")
.SingleOrDefault() != null;
return TableExist = t;
}
}