Setting enum based on values from DB

Question

I have an enum class as follows:

namespace Import.DataObject
{
    internal enum Status
    {
        FullTime,
        Terminated,
    }
}

In my main program I have a DB call then a

  foreach (ClientStatus status in databaseStatus)
            {
                if (status.Name == "FullTime")
                {
                }
                if (status.Name == "Terminated")
                {
                }

            }

How would I set the enum based on the if statements? The Name has an ID associated with it, and I want that ID to = the respecitve name in the enum, I have both the name and id available within the if statement.

McGarnagle · Accepted Answer · 2012-10-22 16:07:27Z

2

Use Enum.Parse:

Status val = (Status)Enum.Parse(typeof(Status), status.Name);

If you're not sure the string is a valid enum, use Enum.TryParse:

Status? val;
if (!Enum.TryParse<Status>(status.Name, out val))
    val = null;

Then just cast to (int) to get the number value:

status.ID = (int)val;

answered Oct 22, 2012 at 16:07

McGarnagle

103k31 gold badges235 silver badges264 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Setting enum based on values from DB

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related