I really want the new Data Port Console to go a few steps ahead of the old SQL CE Console when it comes to useability. One of the nice additions to the product is SQL syntax highlighting on the query editor. This allows you to write stuff like:
SELECT * FROM Customers
Fonts and colors are applied as you write and now I want to extend the editor to support auto-completion. Instead of purchasing a costly component, I decided to adapt the code on this article:
Syntax highlighting textbox written in C#
The code has some bugs and gotchas, but it is easy to use and adapt to VS 2005.