LINQ really does require a different mindset at times. I came across the following post when I was trying to find out how to read the Id (Primary Key) of an entity that I had just inserted into the database.
http://blog.jemm.net/articles/databases/how-to-common-data-patterns-with-linq-to-sql/
The answer is to simply read the property from your entity object directly after calling “SubmitChanges()”:
[...] Entity February 6, 2008 14:19 by Admin How do you get the inserted ID from a LINQ Entity? Read the Id property… Be the first to rate this postCurrently 0/5 Stars.12345 Tags: Categories: c# | recipe Actions: [...]
By: How to get inserted ID from LINQ Entity on February 7, 2008
at 4:20 am
Great. I start to like Linq more and more
By: Zalmoxis on June 10, 2008
at 10:57 am
It’s realy simply! thanks for information!
I like LINQ!
By: Calabonga on June 27, 2008
at 12:09 am
Wow, thats really convenient! that simplifies my problem a lot. Thanks!
By: phild on August 22, 2008
at 2:36 pm
[...] Read inserted Id from LINQ Tagged with: Linq leave a comment « Convert wav to m4a [...]
By: Linq Read Inserted Id of a Record « Kenno’s OpenNote on August 4, 2009
at 5:21 am