April 2010 - Posts

4
Comments

Understanding LINQ to SQL (9) Concurrent Conflict by Dixin

[ LINQ via C# series ] Conflicts are very common when concurrently accessing the same data. Conflicts in concurrent data access The following code presents the concurrent conflict scenario: Action < int , Action < Category >> updateCategory...
3
Comments

Understanding LINQ to SQL (8) Transaction by Dixin

[ LINQ via C# series ] 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...
1
Comments

Where Is Transaction Events In SQL Server Profiler? by Dixin

SQL Server Profiler does not monitor transaction events by default. After installing SQL Server, when creating a new trace, the default template is “Standard”: Transaction events will not show in the trace because “Transactions” is not included in the...
Filed under: , ,
3
Comments

Understanding LINQ to SQL (7) Data Changing by Dixin

[ LINQ via C# series ] After understanding how to retrieve data with LINQ to SQL, now take a look at data change (create (insert) / update / delete). Object Identity When changing data queried by LINQ to SQL, one common confusion for LINQ to SQL beginners...
1
Comments

Understanding LINQ to SQL (6) Working With Deferred Execution by Dixin

[ LINQ via C# series ] Similar with LINQ to Objects, LINQ to SQL supports deferred execution when possible. For example: using ( NorthwindDataContext database = new NorthwindDataContext ()) { IQueryable < Category > source = database.Categories;...
1
Comments

Understanding LINQ to SQL (5) Remote And Local Method Call by Dixin

[ LINQ via C# series ] Since LINQ to SQL is translating C# methods into SQL, all the C# methods are required to make sense in SQL. According to MSDN : A local method call is one that is executed within the object model. A remote method call is one that...
15
Comments

Crazy Bug in Visual Studio 2010 RTM: Copy And Paste by Dixin

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...
5
Comments

Blog Code Font Change: From Courier New to Consolas by Dixin

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...
3
Comments

Understanding LINQ to SQL (4) Data Retrieving Via Query Methods by Dixin

[ LINQ via C# series ] After understanding: object model generating from SQL Server schema query method chaining on IQueryable<T> SQL are translated from expression tree, which is required by IQueryable<T> now it is time to take a deeper look...
3
Comments

Playing with the CPU Usage Curve by Dixin

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 above image is from the book. Nowadays, when someone buys a mainstream CPU...
Filed under: , , , ,
More Posts Next page »