Put an array in to a column

Question

I want to use EF code first to create a column into a table Task, which is an array. How?

public class Task
{
     // my presumption code
     public string[] Attempts { get; set; }

The Attempts has

   AttemptsMetadata---maybe string
   Time            ---DataTime
   Answered        ---bool

Jonny Piazzi · Accepted Answer · 2014-04-14 14:59:18Z

1

Create a property to be used in the code (and mark as ignore) and other property to be used in code.

EDITED

public class Task
{
    [Ignore]
    public string[] Attempts { get; set; }

    public string AttemptsMetadata
    {
        get
        {
            return Attempts != null && Attempts.Any()
                ? Attempts.Aggregate((ac, i) => ";" + ac + i).Substring(1)
                : null;
        }
        set { Attempts = value.Split(';'); }
    }
}

PS:
This strategy has a one flaw. When you use repository expressions you cannot use the ignore property. But I never find another way to do so.

edited Apr 14, 2014 at 14:59

answered Apr 14, 2014 at 14:42

Jonny Piazzi

3,8145 gold badges39 silver badges83 bronze badges

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

2 Comments

user1108948 Over a year ago

How about others such as Time? It is not a string. I mean should I define Attempt as an object rather than a string array?

Jonny Piazzi Over a year ago

If you have a array of primitive types, you can use this approach, but if you using a non primitive type I will advise you to create a table to store this info and you use foreign key to create a relationship. In LINQ this relationship will be represented like a ICollection<> property (it's not a array but is very closer to).

Collectives™ on Stack Overflow

Put an array in to a column

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