Author: Pakbaz


How to convert a numeric value to string in Linq query

Sometimes there is a need to convert a numeric value to string but the method ‘toString()’ or ‘Convert.ToString ()’ does not work. It is because linq to entities does not support and not aware of these functions. The workaround in EF V4.0 is to use SqlFunctions.StringConvert Just...


Merge records in SQL Server

Sometime multiple records have to be compared and somehow merged to update one record. Logically there should be some kind of for loop to go through all the records and find those matching and then do some update. Obviously it’s an expensive process. Luckily there...


An Introduction, let me begin !

It’s been my desire to share my knowledge and any particular experience I gain in programming with world! I believe that is the main idea behind this blog. I am a software developer and eager to learn and update myself in different areas whether it is...