Error inserting into database using entity framework

Question

I am going to get mad. I have a so simple code but it doesn't work.

I have tested every thing and I can't understand the reason.

The code is like this:

FataDBEntities model = new FataDBEntities();

UserAccount nua = new UserAccount();

nua.username = username;
nua.pass = password;
nua.email = mailaddress;
nua.activated = false;

model.UserAccounts.Add(nua);

try
{
    model.SaveChanges();
}
catch (Exception)
{
    throw;
}

string activationCode;

try
{
    activationCode = genActivationCodeAndMail(mailaddress, username);
}
catch (Exception)
{
    throw;
}

ActivationCode ac = new ActivationCode();

ac.code = activationCode;
ac.expiration_date = DateTime.Now.AddDays(1);
nua = model.UserAccounts.Single(p => p.username == username);
ac.wichUser = nua.ID;

model.ActivationCodes.Add(ac);

try
{
    model.SaveChanges();
}
catch (Exception)
{
    throw;
}

and the model is like this :

enter image description here

The error is with second insertion ... the first one works fine.

Additional information: Unable to update the EntitySet 'ActivationCode' because it has a DefiningQuery and no element exists in the element to support the current operation.

Please help...

What is the foreign key relationship? ActivationCode.whichUser ==> UserAccount.ID? — jwatts1980, Aug 15 '14 at 14:18
Also, I assume that you have an autogenerated ID on the UserAccount table? What is the data type of the id? — jwatts1980, Aug 15 '14 at 14:18
Check here: http://stackoverflow.com/questions/7583770/unable-to-update-the-entityset-because-it-has-a-definingquery-and-no-updatefu Does this apply to you? — jwatts1980, Aug 15 '14 at 14:20
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/59417/discussion-between-conductedclever-and-jwatts1980). — ConductedClever, Aug 15 '14 at 14:25

score 3 · Answer 1 · edited May 23 '17 at 10:33

3

According to this SO article, this error can occur if the entity set is mapped from the database view, custom database query or if database table does not have primary key.

This has happened to me before, and I used that same article to fix the issue :)

edited May 23 '17 at 10:33

Community

1
1

answered Aug 15 '14 at 14:23

jwatts1980

7,254
2
28
44

Error inserting into database using entity framework

1 Answers1