Databases
StackOverflow2013
Postsdbo
POEnumerate with return type other than string?
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POEnumerate with return type other than string?
    text
    copied!<p>Since enumeration uses integers, what other structure can I use to give me enum-like access to the value linked to the name:</p> <p>[I know this is wrong, looking for alternative]</p> <pre><code>private enum Project { Cleanup = new Guid("2ED3164-BB48-499B-86C4-A2B1114BF1"), Maintenance = new Guid("39D31D4-28EC-4832-827B-A11129EB2"), Upgrade = new Guid("892F865-E38D-46D7-809A-49510111C1"), Sales = new Guid("A5690E7-1111-4AFB-B44D-1DF3AD66D435"), Replacement = new Guid("11E5CBA2-EDDE-4ECA-BDFD-63BDBA725C8C"), Modem = new Guid("6F686C73-504B-111-9A0B-850C26FDB25F"), Audit = new Guid("30558C7-66D9-4189-9BD9-2B87D11190"), Queries = new Guid("9985242-516A-4151-B7DD-851112F562") } </code></pre> <p>EDIT 2014-07-20</p> <p>This is a newer answer to this question. Using the Attribute class with a helper method, define the extra attributes needed on your enum.</p> <pre><code> public enum MultiValueEnum { [FooAttribute("alpha", 20d, true)] First, [FooAttribute("beta", 40.91d, false)] Second, [FooAttribute("gamma", 1.2d, false)] Third, } public class FooAttribute : Attribute { internal FooAttribute(string name, double percentage, bool isGood) { this.Name = name; this.Percentage = (decimal)percentage; this.IsGood = isGood; } public string Name { get; private set; } public decimal Percentage { get; private set; } public bool IsGood { get; private set; } } public static TAttribute GetAttribute&lt;TAttribute&gt;(this Enum value) where TAttribute : Attribute { var type = value.GetType(); var name = Enum.GetName(type, value); return type.GetField(name) .GetCustomAttributes(false) .OfType&lt;TAttribute&gt;() .SingleOrDefault(); } </code></pre> <p>Which makes it this easy:</p> <pre><code> MultiValueEnum enumVar = MultiValueEnum.First; var enumStringValue = enumVar.GetAttribute&lt;FooAttribute&gt;().Name; var enumValueDecimal = enumVar.GetAttribute&lt;FooAttribute&gt;().Percentage; var enumBool = enumVar.GetAttribute&lt;FooAttribute&gt;().IsGood; </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload