Enumeration support in OpenAccess?

[Kendall Bennett]

Is there any support for enumeration types layered on type of database integer values in OpenAccess? I have my own implementation I use for enumerations in our Entity Framework code I want to convert over, and I thought I read somewhere that OpenAccess supports enumerations natively, but I cannot seem to find anything in the documentation about that?

[IT-Als]

Hi Kendall,

You're right. OpenAccess natively supports enums. If you define an enum like:

public enum CaseStatusEnum { New, Open, Closed }

you can use this enum in your persistent class like

public class Case
{
   // Private field definition
   private CaseStatusEnum status;

  // Public getter / setter for the field goes here
}

and OpenAccess will map this default to and integer column in the table.

Regards

Henrik

[Kendall Bennett]

Excellent. How do I tell the designer where to find my enumeration types? Do I put them in the same namespace as the resulting entities, and then it will find it?

[IT-Als]

I don't know how you structured solution, but if you have a separate project / class library for the persistent classes I suggest you put the enums there.

[IT-Als]

Hi Kendall,

Did you manage to solve it?

Regards

Henrik

[Kendall Bennett]

I am stuck right now until the Q2 release is out, as I need some features and bug fixes that are coming in that release.