Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Return ID after insert with LINQ to SQL

i know there are numerous topics already concerning this, since i googled it already but none of them can fit/work with my code as far as i can see. I simply want to return an Auto Generated ID form my database after an insert. This is a part of my code:

    using (***LINQDataContext dc = new ***LINQDataContext())
    {
        dc.Users.InsertOnSubmit(new User
        {
            Username = user,
            Password = EncryptPassword(user, pass, 1, null, null),
            Email = email
        });

        dc.SubmitChanges();

        return true;
    }
like image 550
Blank EDjok Avatar asked Jan 18 '26 10:01

Blank EDjok


1 Answers

var newUser = new User {
    Username = user,
    Password = EncryptPassword(user, pass, 1, null, null),
    Email = email
};
dc.Users.InsertOnSubmit(newUser);
dc.SubmitChanges();
// any identity / rowversion properties should now have values
var id = newUser.Id;
like image 127
Marc Gravell Avatar answered Jan 20 '26 01:01

Marc Gravell



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!