Code first database creation

Question

I have two entities. User and UserContacts.

I have created two classes. User

public class PUser
{
    public int PUserId { get; set; }

    public virtual UserContact UserContact { get; set; }
}

public class UserContact
{
    public int UserContactId { get; set; }

    public virtual PUser PUser { get; set; }
}

I may have multiple user contacts but In my MVC view - I want to add only one user contact.

How can I do that? Above is creating tables but not inserting Puserid in user contact table.

Fluent api used is.

 modelBuilder.Entity<PUser>()
                .HasOptional(p => p.UserContact).WithRequired(p => p.PUser);

Can you be more specific about what the problem is? Your primary key is missing from the insert? — Chris Searles
– Chris Searles, Commented May 16, 2013 at 18:30
Yes, When I do insert. It inserts user contacts but userid goes null. — Briskstar Technologies
– Briskstar Technologies, Commented May 16, 2013 at 18:39
Wrote an answer but I don't think your yes was actually a yes. Post your code that adds the item to the DB. — Chris Searles
– Chris Searles, Commented May 16, 2013 at 18:46

Komengem · Accepted Answer · 2013-05-16 19:54:31Z

This is a one-to-one relationship, so you need to initialize your UserContact when you create User. This is how i would do it.

    [HttpGet]
    public ActionResult Create()
    {
        return View();
    }

    [HttpPost]
    public ActionResult Create(PUser model)//You should use a ViewModel here
    {
        if (ModelState.IsValid)
        {
            var db = new EfDb(); // If you introduce abstration to you Context, you could avoid this.               
            var user= new PUser
                             {   
                                 Name = model.Name,                                             
                                 UserContact= new UserContact
                                                    {
                                                       Phone = model.UserContact.Phone             
                                                    }
                              };

             db.PUser.Add(user);
             db.SaveChanges();
             return RedirectToAction("Index", "Home");
         }                        
        return View(model);
    }

Collectives™ on Stack Overflow

Code first database creation

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related