Syntax highlighting in search schema object definition

[patelriki13]

Hi Akarzazi,

I would like to have Syntax highlighting in SQL object definition of Search schema.

I have made some R&D on that.
Following are way we can implement it.

1. AvalonEdit WPF based control (https://github.com/icsharpcode/AvalonEdit)
2. Add FastColoredTextBox win form based control (https://github.com/PavelTorgashov/FastColoredTextBox)
3. Create our custom control which highlight syntax of SQL. (Problem for this option we need to make error/bug free control for that it will take time.)

I would like to contribute on this but give me suggestion, how I can progress or crease basic architecture and we peer it for this implementation.

[akarzazi]

Hi Rikin,
The syntax highlighting can be a nice addition, but in "Search schema" the detail is not always SQL as for tables and columns.

Also, i emphasis the primary & secondary text in some cases.
see : /src/SSMSPlusCore/Ui/Search/TextFragment.cs

Nonetheless, if you want to give it a try, the window "Execution History" is an easier target to begin with.
AvalonEdit seems to be a fair choice.
I've tried the nuget package.
It seems working ok and it has a "TSQL" syntax support.

<avalonEdit:TextEditor  Grid.Row="1"  Margin="0,10,0,0" 
		Name="textEditor"
                Document="{Binding Doc, Mode=OneWay, UpdateSourceTrigger=PropertyChanged}"
		FontFamily="Consolas"
                IsReadOnly="True"
		FontSize="10pt"
		SyntaxHighlighting="TSQL">
</avalonEdit:TextEditor>

Now I think, the difficult part is about highlighting the search term efficiently.

[patelriki13]

Thanks for updates, Let me try with your suggestion ("Execution History").
And for search schema part let me do R&D how we can handle it.