KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
So I'd like to write a generic Upsert function for LINQ to SQL and I'm having some trouble conceptualizing how to do it. I'd like it to work something like this: var db = new DataContext(); db.Customers.UpsertOnSubmit(customer); So it would have to be generic in some way and I guess and extension method on Table. I've been able to get this far in determining the primary key of the underlying table: var context = source.Context; var table = context.Mapping.GetTable(source.GetType()); var primaryMember = table.RowType.DataMembers.SingleOrDefault(m => m.IsPrimaryKey); I'm assuming it will be necessary to have this to compose a query to tell if the item is in the DB already or not but I don't really know what to do with it at this point.
Tags (comma-separated)
Save Edits
Cancel