I'm working on an application that allows users to author T-Sql in a text editor, and displays an Intellisense like popup as the user types. After discovering the SqlServer
2008 R2 Feature Pack, I downloaded the SMO portion of the release, as it appears that Microsoft made a bunch of APIs public and redistributable that can be used for this purpose. However, after playing with it, I'm looking for help with using the Resolver.FindCompletions
Specifically, I'm looking to understand the purpose of its ParseResult and IMetadataDisplayInfoProvider parameters. Is the idea that I parse my SQL query locally and pass the result
to FindCompletions(), as opposed to giving it the SQL string directly? And what is expected for IMetadataDisplayInfoProvider? Also, how do I tell FindCompletions what SQL connection to access in order to derive a completions list? Are there examples somewhere
that demonstrate how this function is intended to be used?
Thanks very much for any help,
View Complete Post