Mapping PostgreSQL ENUM types to C# Enums

[Mike Christensen]

In ActiveRecord, I can easily map a column to an enum..

enum enumColors {Green, Blue, Red};

[Property(NotNull = true)]
public enumColors Color
{
get { return color; }
set { color = value; }
}

In the DB, it creates an integer column type and green is stored as 0,
blue is stored as 1 and red is stored as 2. This is fine. However, I
want to take advantage of Postgres ENUM types:

CREATE TYPE colors AS ENUM ('Green', 'Blue', 'Red);
ALTER TABLE Foo ADD COLUMN Color colors;

Now I have a DB type called colors and a column in the table Foo
called Color which is of type colors. The question is how do I map my
class to this data type? ActiveRecord appears to want to read/write
the data as an integer, and Postgres returns it as a string. Any
ideas? Thanks!

Mike

[Tyler Burd]

From memory, so it may be inaccurate:

NHibernate.Type.EnumStringType is the class you're interested in.

Usage:

[Property(ColumnType="NHibernate.Type.EnumStringType`1[[enumColors, YOUR_ASSEMBLY]], NHibernate")]

public enumColors Color
{
get { return color; }
set { color = value; }
}

[Mauricio Scheffer]

Didn't this work? http://forum.castleproject.org/viewtopic.php?p=15401#15401