Can the SSMS editor be reused in your own application or is there an alternative?

Question

I would like to have IntelliSence or code completion and syntax highlighting for SQL queries in my own .NET application.

• Can I use SQL Server Management Studio in the same way you can use the SMO API?

• Are there any open source controls that can be used?

I found code / syntax highlighting elements, but SQL is a funny beast because of column / table aliases.

Answer 1

• No. Cannot use SQL Server Management Studio in your application.

• ScintillaNET is an open source alternative that supports MS Flavored TSQL (and Postgre SQL) out of the box.