Convert a comma separated values string into string[] by Entity Framework

Question

Say, the field of Race in my table has values like "W,A" (white and asian), "H, W" (hispanic and white), "I" (Indian only).

How can I use Entity Framework to build this field into: public string[] Race {get;set;} or public List<string> Race {get;set;} instead of public string[] Race {get;set;}?

I believe it should be possible. Can someone here help me? Thank you.

BrokenGlass · Accepted Answer · 2012-02-09 20:23:50Z

4

Since Entity Framework uses partial classes you can extend it, e.g. if want to extend the entity SomeEntityName something like this should work:

public partial class SomeEntityName
{
    public string[] RaceProperties
    { get { return Race.Split(','); } }
}

answered Feb 9, 2012 at 20:23

BrokenGlass

161k28 gold badges297 silver badges339 bronze badges

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

2 Comments

Blaise Over a year ago

Thank you. That is really helpful. But is it possible to have both get and set? I am using a CheckBoxListFor in MVC3 as an editor for Race.

BrokenGlass Over a year ago

yes - you would have to map that to an update of the Race property, e.g. set { Race = string.Join(",", value); }

Collectives™ on Stack Overflow

Convert a comma separated values string into string[] by Entity Framework

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related