June 2010 - Posts

1
Comments

Watch out for let operator in linq to entities by zhirani

LINQ has a really cool operator call Let that lets you declare variables inside the query. The benefit i find in using let is, it makes my query much easier to read because using Let keyword i can create a variable and assign it a calculated value. Then...
0
Comments

Small SQL improvement in Table Per Hierarchy by zhirani

Well the title of my post is somewhat disguising the actual point which I wanted to communicate. There is basically two important things that i wanted to talk about in this posting. First a slight improvement in T-SQL generation for Table Per Hierarchy...
More Posts