开发者

Cast exception error when i am trying to insert an entity in Entity Framework (using code-first)

开发者 https://www.devze.com 2023-02-09 20:53 出处:网络
I get an cast exception when i am trying to insert an entityin Entity Framework (using code-first). The cast exception is like \"impossible to cast ...Collection\'1(Entity) to type (Entity)\"

I get an cast exception when i am trying to insert an entity in Entity Framework (using code-first).

The cast exception is like "impossible to cast ...Collection'1(Entity) to type (Entity)"

From this code :

public virtual T Insert(T entity)
{
      return Context.Set<T>().Add(entity);
}

I can't figure out why. I am pretty sure ive done everything right.

Post entity

public class Post
    {
        public long PostId { get; private set; }
        public DateTime date { get; set; }
        [Required]
        public string Subject { get; set; }
        public User User { get; set; }
        public Category Category { get; set; }
        [Required]
        public string Body { get; set; }

        public virtual ICollection<Tag> Tags { get; private set; }

        public Post()
        {
            Category = new Category();
            if (Tags == null) 
                Tags = new Collection<Tag>();
        }

        public void AttachTag(string name, User user)
        {
            if (Tags.Count(x => x.Name == name) == 0)
                Tags.Add(new Tag { 
                    Name = name, 
                    User = user 
                });
            else
                throw new Exception("Tag with specified name is already attached to this post.");
        }

        public Tag DeleteTag(string name)
        {
            Tag tag = Tags.Single(x => x.Name == name);
            Tags.Remove(tag);

            return tag;
        }

        public bool HasTags()
        {
            return (Tags.Count > 0);
        }
    }

Tag entity

public class Tag
{
    public long TagId { get; private set; }
    public string Name { get; set; }
    // Qui a ajouté le tag ?
    public User User { get; set; }
}

Mapping

public class PostMap: EntityTypeConfiguration<Post>
{
    public PostMap()
    {
        ToTable("Posts");
        HasKey(x => x.PostId);
        Property(x => x.Subjec开发者_JAVA百科t)
            .HasColumnType("varchar")
            .HasMaxLength(256)
            .IsRequired();
        Property(x => x.Body)
            .HasColumnType("text")
            .IsRequired();
        HasMany(x => x.Tags);
        HasOptional(x => x.Tags);
    }
}

class TagMap : EntityTypeConfiguration<Tag>
{
    public TagMap()
    {
        ToTable("Tags");
        HasKey(x => x.TagId);
        Property(x => x.Name)
            .HasColumnType("varchar")
            .HasMaxLength(256)
            .IsRequired();
        HasRequired(x => x.User);


}
    }

Thanks a lots.


Please make sure that you have passed a single element to the Insert method, not a collection containing a single element.


I found the solution.

Here the correct mapping scenario for Post :

public PostMap()
        {
            ToTable("Posts");
            HasKey(x => x.PostId);
            Property(x => x.Subject)
                .HasColumnType("varchar")
                .HasMaxLength(256)
                .IsRequired();
            Property(x => x.Body)
                .HasColumnType("text")
                .IsRequired();
            HasRequired(x => x.User);
            HasMany(x => x.Tags).WithOptional();
        }

It is important to specify the the Tags collection is optional. Which is the case in this scenario. A Post can have zero tags attached to it.

HasMany(x => x.Tags).WithOptional();

0

精彩评论

暂无评论...
验证码 换一张
取 消