StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POC# class design with Generic structure
primarykey
Id
4592229
data
AcceptedAnswerId
4592445
AnswerCount
4
ClosedDate
CommentCount
9
CommunityOwnedDate
CreationDate
2011-01-04T09:41:31.273
FavoriteCount
0
LastActivityDate
2011-01-04T14:54:21.317
LastEditDate
2011-01-04T14:54:21.317
LastEditorUserId
362140
OwnerUserId
362140
ParentId
0
PostTypeId
1
Score
1
ViewCount
797
LastEditorDisplayName
text
Body
This might be a simple one, but my head is refusing to wrap around that, so an outside view is always useful in that case! I need to design an object hierarchy to implement a Parameter Registration for a patient. This will take place on a certain date and collect a number of different parameters about a patient (bloodpressure, heartrate etc). The values of those Parameter Registrations can be of different types, such as strings, integers, floats or even guids (for lookup lists). So we have: <pre><code>public class ParameterRegistration { public DateTime RegistrationDate { get; set; } public IList<ParameterRegistrationValue> ParameterRegistrationValues { get; set; } } public class ParameterRegistrationValue { public Parameter Parameter { get; set; } public RegistrationValue RegistrationValue { get; set; } // this needs to accomodate the different possible types of registrations! } public class Parameter { // some general information about Parameters } public class RegistrationValue<T> { public RegistrationValue(T value) { Value = value; } public T Value { get; private set; } } </code></pre> UPDATE: Thanks to the suggestions, the model has now morphed to the following: <pre><code>public class ParameterRegistration { public DateTime RegistrationDate { get; set; } public IList<ParameterRegistrationValue> ParameterRegistrationValues { get; set; } } public abstract class ParameterRegistrationValue() { public static ParameterRegistrationValue CreateParameterRegistrationValue(ParameterType type) { switch(type) { case ParameterType.Integer: return new ParameterRegistrationValue<Int32>(); case ParameterType.String: return new ParameterRegistrationValue<String>(); case ParameterType.Guid: return new ParameterRegistrationValue<Guid>(); default: throw new ArgumentOutOfRangeException("Invalid ParameterType: " + type); } } public Parameter Parameter { get; set; } } public class ParameterRegistrationValue<T> : ParameterRegistrationValue { public T RegistrationValue {get; set; } } public enum ParameterType { Integer, Guid, String } public class Parameter { public string ParameterName { get; set; } public ParameterType ParameterType { get; set;} } </code></pre> which is indeed a bit simpler, but now I'm wondering, since the IList in ParameterRegistration points to the abstract ParameterRegistrationValue object, how will I be able to get the actual value out (since its stored on the sub-objects)? Maybe the whole generic thing is indeed not quite the way to go after all :s
Tags
<c#><generics><class-design><object-design>
Title
C# class design with Generic structure
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USSam
UserOwnerUserId
1. USSam
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
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId

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.