Tag: sql
-
C# – Linq to Sql – Reattach and Update an entity
If you’d listen to Microsoft, you’d believe than in Linq to SQL, you can’t reattach a changed entity to a new DataContext and submit the changed entity to the database. Well this isn’t true. It can be done with a little bit of foresight. The first step is to make sure that the underlying table…
-
C#: Use verbatim strings for SQL queries
Using verbatim strings for SQL queries can make your code much more readable. For example, which one of the following queries is easier to read? This one? or this one? The SQL engine doesn’t care for the whitespace you introduce in queries with verbatim strings. So do your fellow programmers a favor and use them…