StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO.Net Serialization, XmlDataReader, a SQL Database and the FlagsAttribute!
primarykey
Id
2113682
data
AcceptedAnswerId
2113767
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2010-01-21T23:06:18.743
FavoriteCount
0
LastActivityDate
2010-01-21T23:20:55.297
LastEditDate
LastEditorUserId
0
OwnerUserId
126454
ParentId
0
PostTypeId
1
Score
1
ViewCount
346
LastEditorDisplayName
text
Body
Giving a quick overview of my situation: I am working on an N-Tier app that relies a lot on serialization, objects interact with the database mainly in a serialized fashion, objects and collections are inserted, updated and read as XML from within stored procedures. For some of the smaller data classes I am simply using ExecuteNonQuery, Reader, etc to interact with the data, as its easier, but I have encountered a problem. Data is inserted into the database using ExecuteNonQuery, using Parameters - some of the data inserted are properties that are Enums (stored in the DB as ints) that have the FlagAttribute attached. On a Enum such as: <pre><code><Flags()> _ Public Enum Fruit As Integer <Description("None"), XmlEnum("0")> None = 0 <Description("Apple"), XmlEnum("1")> Apple = 1 <Description("Banana"), XmlEnum("2")> Banana = 2 <Description("Orange"), XmlEnum("4")> Orange = 4 End Enum </code></pre> The value read back might be an Integer value of 1, 3, 7, etc, and inserted into the database not using serialization, when it is read back however as part of a larger group of classes using the ExecuteXmlReader (filling a XmlReader object) and then needing to be deserialized, it can not be, as 7 for example, causes 'Instance validation error: '7' is not a valid value for Fruit', as it is expecting it to be serialized in the format of: <pre><code><fruitOptions>1 2 4<fruitOptions> </code></pre> All in all it is a little confusing, and I could probably work around it by storing it in the database in the 1, 2, 4 format, but sadly not in the int type that it currently is in. Does anyone have any ideas on this?
Tags
<enums><xmlreader><flags><xmlserializer>
Title
.Net Serialization, XmlDataReader, a SQL Database and the FlagsAttribute!
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USNathan
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO.Net Serialization, XmlDataReader, a SQL Database and the FlagsAttribute!
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.