Web Technologist
Archive for May, 2010
Whats your High Score?
May 22nd
Google has brought innovation to a whole new level by building the first interactive and playable doodle (Google Logo) as the famous Pac-Man game to celebrate its 30th anniversary.
Google has spent a lot of effort to make sure this version had all the original arcade game features. This includes the game crashing after the 255th level, the hint of which direction they were going to turn by moving their eyes, etc.
For a game that’s 30 years old, it holds up remarkably well over time, and still has a hold on popular culture. Bring on the fun…
NOLOCK in LINQ
May 8th
The NOLOCK table hint, also known as READUNCOMITTED, is applicable to SELECT statements only. NOLOCK indicates that no shared locks are issued against the table that would prohibit other transactions from modifying the data in the table.
The most recommended way of implementing NOLOCK is to use a TransactionScope to affect the TransactionOptions associated with the commands of the LINQ context.
Heres a sample code :
using (new System.Transactions.TransactionScope(
System.Transactions.TransactionScopeOption.Required,
new System.Transactions.TransactionOptions
{
IsolationLevel = System.Transactions.IsolationLevel.ReadUncommitted
}))
{
// Retreive Data
}


