Linq: no update in row

[Arjen]

Hi,

Here is my code:

MyDataContext db = new MyDataContext();
Profile profile = db.Profiles.Single(u => u.UserId == userId);

// Edit
profile.Surname = surname;
profile.DateOfBirth = dateOfBirth;
profile.LastUpdate = DateTime.Now;

// Update
db.SubmitChanges();

Here is my situation:
- The data connection works (the user profile gets selected with database
values)
- All input values are new (surname, dateOfBirth, and DateTime.Now)
- I receive no errors, but the row gets not updated for some reasons.

Any ideas why not?

Thanks!

 

[Arjen]

Hi,

Here is my code:

MyDataContext db = new MyDataContext();
Profile profile = db.Profiles.Single(u => u.UserId == userId);

// Edit
profile.Surname = surname;
profile.DateOfBirth = dateOfBirth;
profile.LastUpdate = DateTime.Now;

// Update
db.SubmitChanges();

Here is my situation:
- The data connection works (the user profile gets selected with database
values)
- All input values are new (surname, dateOfBirth, and DateTime.Now)
- I receive no errors, but the row gets not updated for some reasons.

Any ideas why not?

Thanks!

Aha, I forgot to set the primary key. Stupid!