Use linq to generate direct update without select

by

You can actually let LINQ-to-SQL generate update statements:

Foo foo=new Foo { FooId=fooId }; // create obj and set keys
context.Foos.Attach(foo);
foo.Name="test";
context.SubmitChanges();

In your Dbml set UpdateCheck=”Never” for all properties.

This will generate a single update statement without having to do a select first.

One caveat: if you want to be able to set Name to null you would have to initialize your foo object to a different value so Linq can detect the change:

Foo foo=new Foo { FooId=fooId, Name="###" };
...
foo.Name=null;

If you want to check for a timestamp while updating you can do this as well:

Foo foo=new Foo { FooId=fooId, Modified=... }; 
// Modified needs to be set to UpdateCheck="Always" in the dbml

More Related Contents:

  1. Join and Include in Entity Framework
  2. Issues Doing a String Comparison in LINQ
  3. Is there a good LINQ way to do a cartesian product?
  4. When to use Cast() and Oftype() in Linq
  5. How to get index using LINQ? [duplicate]
  6. How do I concatenate two arrays in C#?
  7. Order of LINQ extension methods does not affect performance?
  8. Read SQL Table into C# DataTable
  9. LINQ to SQL – Left Outer Join with multiple join conditions
  10. Why is .Contains slow? Most efficient way to get multiple entities by primary key?
  11. Entity Framework/Linq EXpression converting from string to int
  12. How to flatten nested objects with linq expression
  13. Difference between Lookup() and Dictionary(Of list())
  14. Code to validate SQL Scripts
  15. How to convert an expression tree to a partial SQL query?
  16. Apply function to all elements of collection through LINQ [duplicate]
  17. How to convert linq results to HashSet or HashedSet
  18. IEqualityComparer for SequenceEqual
  19. LINQ – Query syntax vs method chains & lambda [closed]
  20. Resolving extension methods/LINQ ambiguity
  21. Performance of Find() vs. FirstOrDefault() [duplicate]
  22. What does this C# code with an “arrow” (=>, an equal sign and greater than sign) mean and how is it called?
  23. Using Linq Except not Working as I Thought
  24. What is the purpose of AsQueryable()?
  25. Calling a SQL User-defined function in a LINQ query
  26. LINQ query to return a Dictionary
  27. How to convert DataTable to class Object?
  28. How do I compose Linq Expressions? ie Func
  29. Generating sql code programmatically
  30. Do we have transactions in MS-Access?

Leave a Comment