public void AddOrUpdate(string key, T value) { var t = Get(key); cache[key] = value; using (IDbConnection connection = GameManager.DbFactory.OpenDbConnection()) { if (t == null) { var valueBytes = ProtoBufUtils.Serialize(value); //add var mysqlCommand = new MysqlCommand(); mysqlCommand.TypeFullName = typeof(T).FullName; mysqlCommand.CommandType = "insert"; mysqlCommand.DataBytes = valueBytes; GameManager.MysqlQueue.Enqueue(mysqlCommand); var redisCommand = new RedisCommand(); redisCommand.Key = typeof(T).FullName; redisCommand.Field = "insert"; redisCommand.DataBytes = valueBytes; connection.Insert(value); } else { //update connection.Update(value); } } }
//Now lets write the Id Binder.... public void BindId(MysqlCommand cmd) { cmd.Parameters.Add(new MySqlParameter { ParameterName = "@id", DbType = DbType.Int32, Value = Id, }); }
private void button1_Click(object sender,EventArgs e) {MySqlConnection con = new MySqlConnection("server=localhost;port=3306; username=seedcrypt;database=seed;password=xxxxxxx"); string query = "INSERT INTO info('id','seed','password','ip') VALUES (NULL,'"+seed.Text+ "','" +password.Text+ "',NULL)"; con.Open(); MysqlCommand cmd = new MysqlCommand(query,con); cmd.ExecuteNonQuery(); con.Close(); MessageBox.Show("INSERTED SUCCESSFULLY !!! "); }
//Bind the parameters title and content to the respective column names public void BindParams(MysqlCommand cmd) { cmd.Parameters.Add(new MySqlParameter { ParameterName = "@title", DbType = DbType.String, Value = Title, }); cmd.Parameters.Add(new MySqlParameter { ParameterName = "@content", DbType = DbType.String, Value = Content, }); }