/// <summary> /// Can connect to the database? /// </summary> /// <returns></returns> public static bool CanConnect() { var returnValue = TypeExtension.DefaultBoolean; var configuration = new ConfigurationManagerCore(ApplicationTypes.Native); using (var connection = new SqlConnection(configuration.ConnectionStringValue("DefaultConnection"))) { returnValue = connection.CanOpen(); } return(returnValue); }
public static void ClassInit(TestContext context) { // Database is required for these tests var databaseAccess = false; var configuration = new ConfigurationManagerCore(ApplicationTypes.Native); using (var connection = new SqlConnection(configuration.ConnectionStringValue("DefaultConnection"))) { databaseAccess = connection.CanOpen(); } Assert.IsTrue(databaseAccess); }
/// <summary> /// Removes EF code-first migration history table /// </summary> /// <param name="database"></param> /// <param name="schema"></param> public static void DropMigrationHistory(string database = "[FrameworkData]", string schema = "[Activity]") { // Must remove __MigrationHistory for EF Code First objects to auto-create their tables var configuration = new ConfigurationManagerCore(ApplicationTypes.Native); try { using (var connection = new SqlConnection(configuration.ConnectionStringValue("DefaultConnection"))) { using (var command = new SqlCommand("Drop Table " + database + "." + schema + ".[__MigrationHistory]", connection)) { connection.Open(); command.ExecuteNonQuery(); } } } catch (SqlException) { // Ignore connection errors } }