Problem with casting integer values to enum

[mitdej]

Hi there,
I have an several enum types that starts from a nunmber other than 0.
For example:
public enum InternalStatus
{
Pending = 1,
Ported = 2,
Suspended = 3
}
I put this values in a int column of a MSSQL table.

When I try to read tha values back from the database and cast it to
the enuum type, the casting acts as the enum type starts from 0.

I tried Enum.Parse, but it didn't help.

Any suggestion...?

[Jon Skeet [C# MVP]]

On Aug 17, 9:35 am, mitdej <mit...@gmail.c omwrote:

I have an several enum types that starts from a nunmber other than 0.
For example:
public enum InternalStatus
{
Pending = 1,
Ported = 2,
Suspended = 3
}
I put this values in a int column of a MSSQL table.

When I try to read tha values back from the database and cast it to
the enuum type, the casting acts as the enum type starts from 0.

I tried Enum.Parse, but it didn't help.

Any suggestion...?

That sounds very unlikely to me. Could you post a short but complete
example showing the problem? The database side should be irrelevant,
as by the time you're casting you should already have the value as an
integer.

Jon

[mitdej]

This is the problem code. Now that I look closely to the code it is
the opposite situation. Converting the enumeration to int value.

psn.RemoveSent( (int)PortingNot ification_WS.CD BMessageType.Po rtingFromDonor_ Notification
+1, Convert.ToInt32 (dr["OperatorID "]), fromDate, toDate))

This is called from a Client App which is calling a web service and
the enumeration is trransferred as part of the proxy class.

The enumeration is on the server side and is defined as:

public enum CDBMessageType
{
SuspensionOfSer vice_Notificati on = 1,
TerminateSuspen sion_Notificati on = 2,
Disconnection_N otification = 3,
RoutingErrors_N otification = 4,
PortingFromDono r_Notification = 5,
PortAccross_Not ification = 6,
PortingAcceptan ce_Notification = 7,
PortingRejectio n_Notification = 8,
CancelPorting_N otification = 9,
ChangeInAssigne dSeriesOfSubscr iberNumbers_Not ification = 10
}

As You can see I have to add 1 to the value of the enumeration so it
can be casted to the correct int.
I think that WSDL doesn't transfer the information of the values of
the enuumeration types.
Any smarter solution?

[Jon Skeet [C# MVP]]

On Aug 17, 10:58 am, mitdej <mit...@gmail.c omwrote:

<snip>

This is called from a Client App which is calling a web service and
the enumeration is trransferred as part of the proxy class.

That may well be the problem. Have you tried looking at the XML
responses with something like Fiddler?

Jon

[mitdej]

I haven't heard about fiddler :)

this is the enumeration as is generated in the proxy class:

/// <remarks/>
[System.CodeDom. Compiler.Genera tedCodeAttribut e("System.Xml ",
"2.0.50727.832" )]
[System.Serializ ableAttribute()]
[System.Xml.Seri alization.XmlTy peAttribute(Nam espace="http://
tempuri.org/")]
public enum CDBMessageType {

/// <remarks/>
SuspensionOfSer vice_Notificati on,

/// <remarks/>
TerminateSuspen sion_Notificati on,

/// <remarks/>
Disconnection_N otification,

/// <remarks/>
RoutingErrors_N otification,

/// <remarks/>
PortingFromDono r_Notification,

/// <remarks/>
PortAccross_Not ification,

/// <remarks/>
PortingAcceptan ce_Notification ,

/// <remarks/>
PortingRejectio n_Notification,

/// <remarks/>
CancelPorting_N otification,

/// <remarks/>
ChangeInAssigne dSeriesOfSubscr iberNumbers_Not ification,
}

there are no assigned int values to the enumeration values, so I Guess
this is the problem.
Maybe Microsoft team should be informed about this.

Anyway thank You for Your quick responses to my posts.