Archives
-
Understanding LINQ to SQL (9) Concurrent Conflict
Conflicts are very common when concurrently accessing the same data.
Conflicts in concurrent data access
The following code demonstrates the concurrent conflict scenario:
-
Understanding LINQ to SQL (8) Transaction
Database data Changing cannot be talked about without transactions.
Implementing TRANSACTION (BEGIN / COMMIT / ROLLBACK)
The previous post has shown that, when invoking SubmitChanges(), the translated SQL (INSERT / UPDATE / DELETE) are always executed within a TRANSACTION.
Internally, DataContext.SubmitChanges() invokes DataContext.SubmitChanges(ConflictMode.FailOnFirstConflict). The latter is implemented like this:
-
Where Is Transaction Events In SQL Server Profiler?
SQL Server Profiler does not monitor transaction events by default.
After installing SQL Server, when creating a new trace, the default template is “Standard”:
-
Understanding LINQ to SQL (7) Data Changing
-
Understanding LINQ to SQL (6) Working With Deferred Execution
-
Understanding LINQ to SQL (5) Remote And Local Method Call
-
Crazy Bug in Visual Studio 2010 RTM: Copy And Paste
The copy / paste functionality is very buggy in Visual Studio 2010 Beta and RC. In Beta sometimes this even cause Visual Studio crash. Now after using RTM for a week, I found the bug remains, and greatly affect the experience. I searched the Internet and found this comment from Microsoft:
-
Blog Code Font Change: From Courier New to Consolas
Courier New is an excellent monospaced (non-proportional) typeface introduced with Windows 3.1. As a UI designer, I cannot tell how many year I have worked with Courier New. As the release of Visual Studio 2010 and the new MSDN, Consolas becomes the default font of code.
-
Understanding LINQ to SQL (4) Data Retrieving Via Query Methods
-
Playing with the CPU Usage Curve
In the book “The Beauty Of Programming”, which talks about Microsoft interview questions, there is a interesting section: Control the CPU curve of Windows Task Manager.
-
The Volume In Windows Media Center
I developed a tool for Windows Media Center in 2008 in Redmond, and I got a very cool Windows Media Center remote controller. Since then I became a fun of it. Windows Media Center + remote controller makes my Alienware M17x into a powerful home theatre.
-
Understanding LINQ to SQL (3) Expression Tree