How can I add an array type to my database using EF7?

Question

How can I add an array type to my database using EF7?

c# entity-framework entity-framework-core

Question

I'm using ASP.NET MVC 6 and Entity Framework 7.

My Model:

public class Contact {

    public int[] SelectedEstimator { set; get; }

}

I get the following error:

System.InvalidOperationException: The property 'SelectedEstimator'
on entity type 'ContactsManagerV3.Models.Contact' 
has not been added to the model or ignored.

If I change the SelectedEstimator property to an int, it works. How can I get int[] to work?

I was trying to follow MVC 6 - TagHelper Select

Eugene Fedotov

View more on Stack Overflow

wajiro_91 · Accepted Answer · 5/23/2017 10:32:29 AM

You can't create a column of int[] type ( in fact can't be any type of array), which is what you are trying to do with the SelectedEstimator property. You can follow this answer (How to store double[] array to database with Entity Framework Code-First approach) where they transform the array to string to save the array and then from string to array to take it or you can do something like this:

public class Estimator{

      public int EstimatorId {get;set;}

      public int Value {get;set;}

      public int ContactId {get;set;}

      public Contact Contact {get;set;}
}

public class Contact {

      public int ContactId {get;set;}

      public ICollection<Estimator> SelectedEstimator { set; get; }   

}

Now you can accomplish what you want selecting the Estimator.Value. Hope it helps

How can I add an array type to my database using EF7?

Question

Fastest Entity Framework Extensions

Popular Answer

Performance

Expression Evaluator

Related