Sci-fi questions

• How would I encrypt string data in SQL server 2008 while keeping the ability to query over it?
• Does a wrapper class calling a COM component through C# need to implement the Dispose pattern?
• When using LINQ, what is the difference between && and multiple where clauses?
• How do I clear MVC client side validation errors when a cancel button is clicked when a user has invalidated a form?

Sci-fi answers