My latest work is this Silverlight control for discovering and visualizing the difference between two text files or just two strings that you copy and paste. You can choose files either by clicking on the file buttons and selecting them from the file dialogue or you can just drag and drop them in the boxes.

Demo is available here: http://www.bodurov.com/TextDiff/

Unlike my previous post at http://blog.bodurov.com/Implementing-Longest-Common-Subsequence-Algorithm-in-JavaScript-Text-Diff/ where I just wanted to prove the concept that it is possible to implement the Longest Common Subsequence Algorithm in JavaScript, this app is optimized and capable to handle much bigger strings. It also can work with files.

When we use SqlCommand with a set of parameters, they are being executed as a parametrized query. You may or may not pass the desired type with each SqlParameter. If you do not specify desired database type it will be determined by the ADO provider, but you will not know what the actual SQL type is. Below I provide a code that will give you the actual parameters. This code can also help you find out what the actual SQL query executed in the database is.