Entity Framework 5 DbUpdateException: Null value for non-nullable member

c# entity-framework

Question

I have some data models:

[DataContract(Name = "artist")]
public class artist : IEqualityComparer<artist>
{
    [Key]
    [XmlIgnore]
    [DataMember]
    public int ID { get; set; }

    [DataMember]
    [XmlElement(ElementName = "name")]
    public string name { get; set; }

    [DataMember]
    [XmlElement(ElementName = "mbid", IsNullable = true)]
    public string mbid { get; set; }

    [DataMember]
    [XmlElement(ElementName = "url")]
    public string url { get; set; }

    [XmlElement(ElementName = "image", IsNullable = true)]
    public List<string> image { get; set; }

    [DataMember(IsRequired=false)]
    [XmlElement(ElementName = "stats", IsNullable = true)]
    public stats stats { get; set; }

    public double? match { get; set; }
    public List<tag> tags { get; set; }
    [XmlElement(ElementName = "similar")]
    [DataMember(Name = "similar")]
    public List<artist> similar { get; set; }

    [DataMember]
    [XmlElement(ElementName = "bio", IsNullable = true)]
    public wiki bio { get; set; }


    public bool Equals(artist x, artist y)
    {
        return x.name == y.name;
    }

    public int GetHashCode(artist obj)
    {
        return obj.name.GetHashCode();
    }
}

and a complex type:

    [DataContract]
[ComplexType]
[XmlRoot(ElementName = "streamable", IsNullable = true)]
public class stats
{
    [DataMember(IsRequired = false)]
    public int listeners { get; set; }

    [DataMember(IsRequired = false)]
    public int playcount { get; set; }
}

and database inclusion:

[Table("CachedArtistInfo")]
public class MusicArtists
{
    [Key]
    public string artistName { get; set; }
    public artist artistInfo { get; set; }

    private DateTime _added = default(DateTime);
    [DataMember(IsRequired = true)]
    [Timestamp]
    public DateTime added
    {
        get
        {
            return (_added == default(DateTime)) ? DateTime.Now : _added;
        }
        set { _added = value; }
    }
}

Final step:

        foreach (artist a in id)
        {
            df.CachedArtists.Add(new MusicArtists() { artistName = a.name, artistInfo = a });
            df.SaveChanges();
        }

ERROR: ExceptionType "System.Data.Entity.Infrastructure.DbUpdateException" "Null value for non-nullable member. Member: 'stats'." a variable is fully filled and object stats in it. what's wrong?

enter image description here enter image description here

1
9
1/21/2015 9:55:14 AM

Accepted Answer

Complex types cannot be null - so you have to create an instance of the class before saving. This article helped me solve the same problem. http://weblogs.asp.net/manavi/archive/2011/03/28/associations-in-ef-4-1-code-first-part-2-complex-types.aspx

24
9/5/2012 2:24:10 AM


Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow