Tagged: Sql


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