using Enum in database and .net

Question

this is how I declare enums:

Enum GROUP_TYPE {
    TYPE1,
    TYPE2
}

this is how I store them:

GroupTypes(id, code) //code is the enum value name
Groups(id, groupName, groupTypeId)

In the InsertGroup stored procedure (I am using stored procedures) I receive @type_code as nvarchar and use it to find the correct id of the group type. I am using this method in order to seperate between the code and the db (the enum number doesn't have to be the same as the id in GroupTypes table).

In the GetGroups stored procedure, in order to read the code from the datatable, I am checking if the type code is defined in GROUP_TYPE and if so I parse the string code to the enum object.

Am I doing things right? Is there any better way to deal with enums in code and db?

possible duplicate of SQL Table and C# Enumeration

John Saunders
– John Saunders

2011-03-13 04:18:36 +00:00
Commented Mar 13, 2011 at 4:18 — John Saunders
– John Saunders, Commented Mar 13, 2011 at 4:18
See also stackoverflow.com/questions/2093764/…

John Saunders
– John Saunders

2011-03-13 04:19:45 +00:00
Commented Mar 13, 2011 at 4:19 — John Saunders
– John Saunders, Commented Mar 13, 2011 at 4:19

Rob Hruska · Accepted Answer · 2011-03-13 03:00:48Z

3

I would make the enum and the id in the table be the same.

enum Group
{
  Group1 = 1,
  Group3 = 3
}

This is the easiest and most failsafe way.

edited Mar 13, 2011 at 3:00

Rob Hruska

121k32 gold badges170 silver badges193 bronze badges

answered Mar 13, 2011 at 2:49

BryceH

2,8082 gold badges23 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Naor Over a year ago

But this makes the code depend on the db in terms of data and not in terms of scheme.

Mark Sowul · Accepted Answer · 2011-03-13 03:04:15Z

0

I usually map the enum value or name (preferably the explicitly set numeric value as per BryceH) as a database column and add a constraint to the column, making sure to note that in the comment for the enum

answered Mar 13, 2011 at 3:04

Mark Sowul

10.7k1 gold badge49 silver badges52 bronze badges

Collectives™ on Stack Overflow

using Enum in database and .net

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related