[C#] ASP.NET -- aspnet_Users table, db creates new row on update

[Umair Ahmad khan]

Hi, my code

aspnet_User user = c.aspnet_Users.First(u => u.UserName == userName);

user.UserName = e.NewValues["UserName"].ToString();
user.LoweredUserName = user.UserName.ToLower();

    c.SubmitChanges();

after submit changes my aspnet_user table have 2 rows. one is with old username and another one is with new .. hmm.gif i only want to update the row

[Andreas X]

Have you got a primary key on the table?

Andreas Johansson
IT Professional at Office IT Partner i Norrbotten Sweden
What we don't know. We learn.
What you don't know. We teach