public virtual void Create(ItemCreatedEvent message)
{
string insertText = "INSERT INTO inventory(id,version) VALUES(@id,@version)";
using (var conn = new MySqlConnection())
{
var mysqlConn = System.Configuration.ConfigurationManager.ConnectionStrings["mysqlConn"].ConnectionString;
conn.ConnectionString = mysqlConn;
conn.Open();
MySqlHelper.ExecuteNonQuery(
conn,
insertText,
new MySqlParameter[] { new MySqlParameter("@id", message.Id),
new MySqlParameter("@version", message.Version) }
);
conn.Close();
}
}
public virtual void Create(ItemCreatedEvent message)
{
string insertText = "INSERT INTO inventory(id,version) VALUES(@id,@version)";
using (var conn = new MySqlConnection())
{
var mysqlConn = System.Configuration.ConfigurationManager.ConnectionStrings["mysqlConn"].ConnectionString;
conn.ConnectionString = mysqlConn;
conn.Open();
MySqlHelper.ExecuteNonQuery(
conn,
insertText,
new MySqlParameter[] { new MySqlParameter("@id", message.Id),
new MySqlParameter("@version", message.Version)
}
);
conn.Close();
}
}