public override string GetDataProviderFieldType(FieldType fieldType) { var mySqlType = typeConverter.GetDataProviderFieldType(fieldType); return(MySqlDbTypeConverter.GetMySqlDataTypeStringValue(mySqlType)); }
//public override void InsertRecords(string tableName, IEnumerable<Record> records) //{ // const string INSERT_INTO_FORMAT = "INSERT INTO {0}({1}) VALUES({2})"; // string fieldNames = records.ElementAt(0).Fields // .Select(f => f.Name) // .OrderBy(f => f) // .Join("`,`").Prepend("`").Append("`"); // using (MySqlConnection connection = new MySqlConnection(ConnectionDetails.ConnectionString)) // { // connection.Open(); // using (MySqlTransaction transaction = connection.BeginTransaction()) // { // using (MySqlCommand command = connection.CreateCommand()) // { // command.Transaction = transaction; // //command.CommandText = "SET NAMES UTF8; SET CHARACTER SET UTF8;"; // //command.ExecuteNonQuery(); // StringBuilder sbValues = null; // records.ForEach(record => // { // sbValues = new StringBuilder(50); // record.Fields.OrderBy(f => f.Name).ForEach(field => // { // if (field.IsNumeric) // { // sbValues.Append(field.Value); // } // else if (field.Type == FieldType.DateTime) // { // sbValues.Append(field.GetValue<DateTime>().ToISO8601DateString().AddSingleQuotes()); // } // else // { // sbValues.Append("'", field.Value.ToString().Replace("'", "''"), "'"); // } // sbValues.Append(","); // }); // sbValues.Length -= 1; // Remove last comma "," // command.CommandText = string.Format(INSERT_INTO_FORMAT, tableName, fieldNames, sbValues.ToString()); // command.ExecuteNonQuery(); // }); // } // transaction.Commit(); // } // connection.Close(); // } //} public override FieldType GetDataMigratorFieldType(string providerFieldType) { var mySqlType = MySqlDbTypeConverter.GetMySqlDataType(providerFieldType); return(typeConverter.GetDataMigratorFieldType(mySqlType)); }