SCOPE_IDENTITY() with LINQ (31Oct09)
While reading about a recent question concerning @@Identity and the reasons to use SCOPE_IDENTITY() instead I experimented with LINQ to get the SCOPE_IDENTITY() results. using (var dbc = new siteDataContext()) { dbc.Log = Console.Out; repertoire newSkill = new repertoire { skill = “a new item” }; dbc.repertoires.InsertOnSubmit(newSkill); dbc.SubmitChanges(); Console.Write(newSkill.id.ToString()); } It seems that calling the [...]
Posted in ASP.NET, C#, LINQ, Programming | No Comments »





