When using Linq To SQL, here’s the pattern I use to retry an operation after it failed because a deadlock occurred in a SQL Database: while (true) { try { using (var scope = new TransactionScope()) { using (var db = new MyDataContext()) { // Do what you need to do on the DB… db.SubmitChanges(); …
C# – Linq To Sql – Handle a Transaction Deadlock Read More »
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# – Linq to Sql – Reattach and Update an entity Read More »
If you have ever used the Microsoft Office COM Interop classes to automate Word (or any other Office Application), you know those methods often take a lot of parameters, which can be tedious. Note: This was written a while ago before .Net 4.0 was available. .Net 4.0 introduces the dynamic keyword which makes COM Interop …
Introduction After some time learning Python and tinkering with it, I decided that it was time to use it in a “real world” application. After some thinking, I came up with the idea to program a web gallery generator, which would not be a too big project to work on my spare time and would …
Python Programming – Photo Web Gallery Generator Read More »
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? string query = @” SELECT User.FirstName, User.LastName, User.Age, User.Gender, User.HairColor, Adress.Street, Adresse.Zip, Adress.City, Adress.Country FROM User INNER JOIN Adress ON User.AdressId = Adress.Id SORT BY User.FirstName, User.LastName “; …