title: How do I select an enum value from the string representation of the 'name'?
body: <p>I have enum like this</p>
  
  <pre><code>public enum PetType
  {
      Dog = 1,
      Cat = 2
  }
  </code></pre>
  
  <p>I also have <code>string pet = "Dog"</code>. How do I return 1? Pseudo code I'm thinking about is:</p>
  
  <pre><code>select Dog_Id from PetType where PetName = pet
  </code></pre>