Assigning a variable enum value

Question

I have the following enum

public enum Outcome
{
   DontKnow = 0,
   Good = 1,
   Bad = 2,
   NotBad = 3
}

In my Results class, I have a property with this enum:

public class Result
{
   public int Id { get; set; }
   public string Name { get; set; }
   public Outcome FinalOutcome { get; set; }
}

As I read data from the database -- using SqlDataReader -- how do I assign its value?

while(reader.Read())
{
   Id = Convert.IsDbNull(reader[0]) ? Convert.ToInt32(0) : Convert.ToInt32(reader[0]);
   Name = Convert.IsDbNull(reader[1]) ? string.Empty : reader[1].ToString();
   FinalOutcome = Convert.IsDbNull(reader[2]) ? WhatGoesHere? : WhatGoesHere?;
}

What is the column type in the database? Integer? You should just be able to cast the reader value to the enum type. — Ron Beyer, Dec 14 '15 at 19:17
If the data type in the SQL table is a int, then you just cast it as an integer, then Enum.TryParse against it. I can give you a code example if you would like. — Casey ScriptFu Pharr, Dec 14 '15 at 19:18
An example is the following, if the SQL data type is an integer : obj.OutCome = (OutCome) sqlIntValue; — Casey ScriptFu Pharr, Dec 14 '15 at 19:19

score 3 · Accepted Answer · answered Dec 14 '15 at 19:22

while(reader.Read())
{
   Id = Convert.IsDbNull(reader[0]) ? Convert.ToInt32(0) : Convert.ToInt32(reader[0]);
   Name = Convert.IsDbNull(reader[1]) ? string.Empty : reader[1].ToString();
   FinalOutcome = Convert.IsDbNull(reader[2]) ? FinalOutcome.DontKnow : (Outcome) Convert.ToInt32(reader[2]);
}

Maess · Answer 2 · 2015-12-14T19:23:28.730

0

Assuming your source column is a nullable int:

FinalOutcome = !Convert.IsDbNull(reader[2]) ?(OutCome)reader[2] : (OutCome)0;

edited Dec 14 '15 at 19:23

answered Dec 14 '15 at 19:22

Maess

4,118
20
29

Corrected, I just added a not :) – Maess Dec 14 '15 at 19:23

Assigning a variable enum value

2 Answers2