Entity Framework Code First one-to-one relation

Question

I'm trying to create a one-to-one relation between two tables, but as a result I have one-to-many. What is the problem with this code?

namespace EFCF_Demo.Models
{
    public class Post
    {
        [Key]
        public int ID { get; set; }
        public string Title { get; set; }
        public string MiniContent { get; set; }
        public string Author { get; set; }
        public DateTime PublishDate { get; set; }
        public int Rating { get; set; }
        public virtual Content MainContent { get; set; }   
    }

    public class Content
    {
        public int ID { get; set; }
        public virtual Post Post { get; set; }
        public string FullContent { get; set; }
    }

    public class PostEntities : DbContext
    {
        public DbSet<Post> Posts { get; set; }
        public DbSet<Content> Contents { get; set; }
    }
}

Key is detecting automatically by EFCF and it's - ID. I resolve this with fluent API but steel have some problems with saving Content. — Ihor Bats, Jan 18 '11 at 08:12
if I am not wrong, When the property is named Id, or ClassNameId, it is presumed to be the primary key — hazimdikenli, May 10 '11 at 12:23

score 2 · Answer 1 · answered May 10 '11 at 12:27

Don't you need PostId in the Content class, and ContentId in the Post class?

        public class Content
        {
            [Key]
            public int PostId { get; set; }
            public virtual Post Post { get; set; }
            public string FullContent { get; set; }
        }

what about this:) This should do it.

score 1 · Answer 2 · edited Oct 25 '13 at 16:19

1

Problem was resolved by removing

public DbSet<Content> Contents { get; set; }

After that we don't need to use the Fluent API but I have some problems with saving.

edited Oct 25 '13 at 16:19

ProgramFOX

6,131
11
45
51

answered Jan 18 '11 at 09:21

Ihor Bats

169
1
12

score 0 · Answer 3 · edited May 23 '17 at 12:18

0

Try this:

edited May 23 '17 at 12:18

Community

1
1

answered Jan 17 '11 at 16:40

Brian Mains

50,520
35
148
257

Entity Framework Code First one-to-one relation

3 Answers3