public void ExecuteSqlCommand(string name, List<KeyValuePair<string, string>> data) { StringBuilder strkeys = new StringBuilder(); StringBuilder strvalues = new StringBuilder(); strkeys.Append("("); strvalues.Append("("); for (int i=0; i<data.Count; i++) { KeyValuePair<string, string> keyvalue = data[i]; strkeys.Append(string.Format("`{0}`", keyvalue.Key)); strvalues.Append(string.Format("'{0}'", keyvalue.Value)); if (i<(data.Count -1)) { strkeys.Append(","); strvalues.Append(","); } } strkeys.Append(")"); strvalues.Append(")"); string k = strkeys.ToString(); string v = strvalues.ToString(); string query = string.Format("INSERT INTO `{0}`.`{1}` {2} VALUES {3}", Program.dbname, name, k, v); try { context.Database.ExecuteSqlCommand(query); MessageBox.Show("Data Saved..."); } catch (Exception e) { MessageBox.Show(e.Message); context.Dispose(); context = Program.CreateConnection(); } }
public static DatabaseContext CreateConnection() { //pass = "******"; DbProviderFactory factory = DbProviderFactories.GetFactory("MySql.Data.MySqlClient"); string connectionString = string.Format("Server=localhost; port=3306; Database={0}; Uid=root; Pwd={1}", dbname, pass); DbConnection conn = factory.CreateConnection(); conn.ConnectionString = connectionString; //conn.Open(); DatabaseContext _context = null; try { _context = new DatabaseContext(conn); _context.Database.CreateIfNotExists(); return _context; } catch (Exception e) { Console.WriteLine(e.Message); Console.WriteLine("Enter MySQL Password..."); pass = Console.ReadLine(); try { return CreateConnection(); } catch (Exception) { throw; } } }
public UnitOfWork() { context = Program.CreateConnection(); //context = new DatabaseContext(); }