How to use a monospaced font in the TableAdapter Configuration Wizard's SQL Statement?

Question

How do I change the fonts used in the TableAdapter Configuration Wizard SQL Statement?

As you see here, the alignment of the Query is wrong, so I want to set this box so it uses a monospaced font like "Consolas" or "Courier New".

I think I need to change something in Tool - Options - Environment - Fonts and Colors:

But I cannot find which setting/display item I need to select to change it. There's one named "Query and View Designer" but it (only) changes the font when you use the Query builder by clicking the "Query builder" button.

How do I do this? Do I need to change a setting somewhere else?

Answer 1

It looks like this wizard has a TextBox, probably in WPF since Visual Studio 2010 is mostly WPF. Since Visual Studio has many hooks to support extensions, it is possible that an extension could be created. I would not use my time trying to find it--my gut is that down such a path lies much suffering.

Seems easier to leave open a SQL Management Studio query window (or a SQL syntax-highlighting text editor of your choice) on the side, then copy and paste as needed.

Answer 2

Sure, just ask Microsoft to add it in ;-)

https://connect.microsoft.com/VisualStudio/feedback/details/657090/make-fonts-and-colors-query-and-view-designers-affect-tableadapter-configuration-wizard