Mapping Enumeration

I seem to be having a problem with something that should be really simple, mapping an enumeration.  For some reason then value 0 is always stored in the db, no matter what value I assign to the entities field.

Then enumeration is:
    Public Enum UomDistance As Integer
        Mm = 1
        Inch = 2
        Foot = 3
        Yard = 4
        Meter = 5
    End Enum

In the Forward Mapping wizard both type and SQL Type are set to integer. In the app.config it is:
<field name="_sizeOUM">
              <extension key="db-column">
                <extension key="db-sql-type" value="INT" />
                <extension key="db-column-name" value="SizeUom" />
              </extension>
</field>
I've search the docs and forums but don't see anything. Any thought about what might be causing this or how to dig deeper would be greatly appreciated.

Thanks
Chris

Hi Chris,

This should work out-of-the-box. For instance I have (I know C#, but nevertheless):

    public enum InvoiceStateEnum
    {
        Created = 1,
        Printed = 2,
        Accepted = 3,
        Recorded = 4
    };

and this enum is used directly as a field in my class like:

public class SomePersistentClass
{
   private InvoiceStateEnum;

   ...
   ...
   // Public properties goes here
}

In the forward mapping I do nothing else but giving the db column a meaningful name

and it works like a charm.

Regards

Henrik

Hello hgsdc,

Each enumeration has an underlying type, which can be any integral type except char. By default this is int. In the provided example you use integer as underlying type, so the enumeration field is mapped to an integer column in the database.

You could use the provided enumeration inside a class in the following way:

In order to insert new records in the database you could do the following:
I hope the provided information will be helpful to you.

All the best,
Damyan Bogoev
the Telerik team

Hi Damyan,

Yes, I know about the underlying type. I was giving the answer to Chris.

Naturally, you have to give the property (enum) a value in your instance of the persistent class...and also within a transaction to store it.

Regards

Henrik

Thanks for the replies.

I give everything a shot tomorrow.