public MySqlDataReader Select(string query) { SampleConnection sample = new SampleConnection(); MySqlConnection conn = sample.GetConnection(); log.Info("Select..."); MySqlCommand cmd = new MySqlCommand(); cmd.Connection = conn; cmd.CommandText = query; MySqlDataReader rd = cmd.ExecuteReader(); //sample.Close(conn); return(rd); }
public void Insert(string query) { //throw new NotImplementedException(); SampleConnection sample = new SampleConnection(); MySqlConnection conn = sample.GetConnection(); log.Info("Create..."); MySqlCommand cmd = new MySqlCommand(); cmd.Connection = conn; cmd.CommandText = query; cmd.ExecuteNonQuery(); sample.Close(conn); return; }