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);
}
