ASP.NET MVC - EF Code First doesn't want to create a row in my database

Question

I have this piece of code:

var data = context.Accounts.Where(a => a.UserName == User.Identity.Name).Select(a => a.UserAddons).SingleOrDefault();
if (data == null)
   data = new UserAddons();
{setting up properties of data}
context.SaveChanges();

I want it to create a new row of UserAddons. But it doesn't want to. Do i need to select whole Account entity to do that?

You need to add the new entity to the context

Rui Jarimba
– Rui Jarimba

2013-01-02 13:59:12 +00:00
Commented Jan 2, 2013 at 13:59 — Rui Jarimba
– Rui Jarimba, Commented Jan 2, 2013 at 13:59

Rui Jarimba · Accepted Answer · 2013-01-02 14:04:41Z

1

You're probably forgetting to add the new entity to the context. Try this (not tested):

bool isNew = false;
var data = context.Accounts.Where(a => a.UserName == User.Identity.Name).Select(a => a.UserAddons).SingleOrDefault();

if (data == null)
{
   data = new UserAddons();
   isNew = true;
}  

// setting up properties of data

if(isNew)
    context.Add(data);

context.SaveChanges();

answered Jan 2, 2013 at 14:04

Rui Jarimba

18.5k11 gold badges64 silver badges101 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

ojek Over a year ago

Yeah. But then i will need to look for the Account entity for the second time, to properly associate entities. :-/

Rui Jarimba Over a year ago

Then you need to load the Account entity first with the associated UserAddons. If there aren't any, create the new entity. PS: Are you using a DbContext or ObjectContext?

ojek Over a year ago

I'm using DbContext. Why does that matter?

Esteban Elverdin · Accepted Answer · 2013-01-02 14:20:46Z

1

If I understand your model correctly, you should add the new UserAddons to the Account

var account = context.Accounts.Where(a => a.UserName == User.Identity.Name).Single();

if (account.Addons == null)
   account.UserAddons = new UserAddons();

{setting up properties of account.Addons}

context.SaveChanges();

answered Jan 2, 2013 at 14:20

Esteban Elverdin

3,5821 gold badge20 silver badges21 bronze badges

Collectives™ on Stack Overflow

ASP.NET MVC - EF Code First doesn't want to create a row in my database

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related