BetterMembership.IntegrationTests.Helpers.HttpContextExtensions.InitializeDatabase C# (CSharp) Метод

InitializeDatabase() приватный статический Метод

private static InitializeDatabase ( string connectionString, string userTable ) : void
connectionString string
userTable string
Результат void
        private static void InitializeDatabase(string connectionString, string userTable)
        {
            using (var context = new MembershipContext(connectionString))
            {
                context.Database.CreateIfNotExists();

                if (
                    context.Database.SqlQuery<int?>(
                        "SELECT 1 from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'webpages_UsersInRoles'")
                           .SingleOrDefault() != null)
                {
                    context.Database.ExecuteSqlCommand("Delete From webpages_UsersInRoles");
                    context.Database.ExecuteSqlCommand("Delete From webpages_Roles");
                }

                if (
                    context.Database.SqlQuery<int?>(
                        "SELECT 1 from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'webpages_Membership'")
                           .SingleOrDefault() != null)
                {
                    context.Database.ExecuteSqlCommand("Delete From webpages_Membership");
                }

                if (
                    context.Database.SqlQuery<int?>(
                        "SELECT 1 from INFORMATION_SCHEMA.TABLES where TABLE_NAME = {0}", userTable).SingleOrDefault()
                    != null)
                {
                    context.Database.ExecuteSqlCommand("Delete From " + userTable);
                }
            }
        }
    }