private static void InsertRow(EquipParam row)
{
insert.Parameters["@ID"].Value = row.ID;
for (var i = 0; i < EquipParam.NumValues; i++)
{
insert.Parameters["@C" + i].Value = row.Values[i];
}
insert.ExecuteNonQuery();
}
public static EquipParam GetById(int modelId)
{
EquipParam result = null;
using (var conn = CacheManager.CreateConnection())
{
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "SELECT * FROM EquipParams WHERE ID = @ID";
cmd.Parameters.AddWithValue("@ID", modelId);
conn.Open();
using (var reader = cmd.ExecuteReader(CommandBehavior.SingleRow))
{
if (reader.Read())
{
result = EquipParam.FromDataReader(reader);
}
}
}
}
return(result);
}