I could go down that path, but I am not abstracted from the details of
index server. I am have gone down the path of interop. Won't be as fast,
but at least I have an API and not going agains raw storage of data.
Dim Q As Object = Server.CreateObject("ixsso.Query")
Dim Util As Object = Server.CreateObject("ixsso.Util")
Q.Query = searchString ' String provided by user.
Q.Catalog = ConfigurationSettings.AppSettings.Item("Catalog")
Q.SortBy = "rank[d]"
Q.Columns = "vpath, path, filename, write, characterization, rank"
Q.MaxRecords = 10
For Each searchScopeItem In searchScopeItems
Util.AddScopeToQuery(Q, searchScopeItem, "deep")
Next
Dim searchResults As Object = Q.CreateRecordSet("nonsequential")
'Iterate through resultset and format into result table.
I would think that going against the data provider directly, that I would
have to create queries/sprocs that would have knowledge of tables,
relationships, and constraints on the data storage. Right now I will
stick with interop until there is some equivalent within the Framework.
Thanks for your suggestion Adrian.
Cheers,
Tommy
You can read messages from the Advanced DOTNET archive, unsubscribe from Advanced
DOTNET, or
subscribe to other DevelopMentor lists at http://discuss.develop.com.