public void Create(ZipEntity entity) { MySqlParameter[] parameters = new MySqlParameter[] { new MySqlParameter("@Id", MySqlDbType.Int32) { Direction = ParameterDirection.Output }, new MySqlParameter("@my_data", MySqlDbType.LongBlob) { Value = entity.Data }, new MySqlParameter("@my_before", MySqlDbType.Double) { Value = entity.Before }, new MySqlParameter("@my_after", MySqlDbType.Double) { Value = entity.After }, }; MariaHelper.ExecuteNonQuery( DBConfig.ConnStr, CommandType.StoredProcedure, "usp_myimage_create", parameters); }
public List <ZipEntity> GetAll() { return(MariaHelper.Query <ZipEntity>(DBConfig.ConnStr, CommandType.StoredProcedure, "usp_myimage_getall", null).ToList()); }
public ZipEntity Find(int id) { MySqlParameter[] parameters = new MySqlParameter[] { new MySqlParameter("@my_id", MySqlDbType.Int32) { Value = id }, }; return(MariaHelper.Query <ZipEntity>( DBConfig.ConnStr, CommandType.StoredProcedure, "usp_myimage_get", parameters).FirstOrDefault()); }
public static IEnumerable <T> Query <T>(string connectionString, CommandType commandType, string commandText, MySqlParameter[] commandParameters) { if (string.IsNullOrEmpty(connectionString)) { throw new ArgumentNullException(nameof(connectionString)); } if (string.IsNullOrEmpty(commandText)) { throw new ArgumentNullException(nameof(commandText)); } IEnumerable <T> objs; using (MySqlConnection cnn = new MySqlConnection(connectionString)) { DynamicParameters parameters = MariaHelper.ParseParameters(commandParameters); objs = cnn.Query <T>(commandText, (object)parameters, commandType: new CommandType?(commandType)); MariaHelper.SetOutputParameterValue(commandParameters, parameters); } return(objs); }