public void GetDbProviderManifestTokenDoesNotThrowWhenMissingPersistSecurityInfo() { using (MySqlConnection connection = new MySqlConnection(GetConnectionString(this.user, this.password, false, true))) { MySqlProviderServices providerServices = new MySqlProviderServices(); string token = null; connection.Open(); Assert.DoesNotThrow(delegate() { token = providerServices.GetProviderManifestToken(connection); }); Assert.IsNotNull(token); connection.Close(); } }
public void GetDbProviderManifestTokenDoesNotThrowWhenLocalized() { Thread.CurrentThread.CurrentCulture = new CultureInfo("fr-CA"); using (MySqlConnection connection = new MySqlConnection(GetConnectionString(true))) { MySqlProviderServices providerServices = new MySqlProviderServices(); string token = null; Assert.DoesNotThrow(delegate() { token = providerServices.GetProviderManifestToken(connection); }); Assert.IsNotNull(token); } }
public string GetTableCreateScript(EntitySet entitySet, string connectionString, string version) { MySqlProviderServices service = new MySqlProviderServices(); if (!String.IsNullOrEmpty(version)) service.serverVersion = new Version(version); else { using (var conn = new MySqlConnection(connectionString.Replace(@"""", ""))) { conn.Open(); var v = DBVersion.Parse(conn.ServerVersion.ToString()); service.serverVersion = new Version(v.Major + "." + v.Minor); } } if (service.serverVersion == null) service.serverVersion = new Version("5.5"); return service.GetTableCreateScript(entitySet); }
public string GetTableCreateScript(EntitySet entitySet, string connectionString, string version) { MySqlProviderServices service = new MySqlProviderServices(); if (!String.IsNullOrEmpty(version)) { service.serverVersion = new Version(version); } else { using (var conn = new MySqlConnection(connectionString.Replace(@"""", ""))) { conn.Open(); var v = DBVersion.Parse(conn.ServerVersion.ToString()); service.serverVersion = new Version(v.Major + "." + v.Minor); } } if (service.serverVersion == null) { service.serverVersion = new Version("5.5"); } return(service.GetTableCreateScript(entitySet)); }
static MySqlProviderServices() { Instance = new MySqlProviderServices(); }
static MySqlProviderServices() { Instance = new MySqlProviderServices(); }
/// <summary> /// Generate and apply sql statemens from the /// migration operations list /// return false is case of fail or if database doesn't exist /// </summary> private bool GenerateAndExecuteMySQLStatements(List<MigrationOperation> migrationOperations) { MySqlProviderServices ProviderServices; ProviderServices = new MySqlProviderServices(); using (BlogContext context = new BlogContext()) { if (!context.Database.Exists()) return false; using (MySqlConnection conn = new MySqlConnection(context.Database.Connection.ConnectionString)) { var migratorGenerator = new MySqlMigrationSqlGenerator(); var Token = ProviderServices.GetProviderManifestToken(conn); var sqlStmts = migratorGenerator.Generate(migrationOperations, providerManifestToken: Token); if (conn.State == System.Data.ConnectionState.Closed) conn.Open(); foreach (MigrationStatement stmt in sqlStmts) { try { MySqlCommand cmd = new MySqlCommand(stmt.Sql, conn); cmd.ExecuteNonQuery(); } catch (Exception) { return false; } } } } return true; }