RAG using SqlServer and TextSearch v1.55.0

[idlemind]

Does anyone have an example of this but using the SqlServer connector? struggling to find any useful documentation for it. I've managed to generate embeddings but struggling to search them using textsearch.

I have it working fine in v1.51.0 but my code is no longer compatible with the latest updates. This is what my current code is based on. There is no search example here though.

I also noticed that var textEmbeddingGenerationService = build.kernel.GetRequiredService(); is now obsolete but can't find any examples showing it's replacement.

Here is the outdated documentation provided.

UPDATE: I managed to edit the VectorStoreRAG sample to work with SQL server perfectly. When I transferred the code over to my project I had an error. I'm not at my pc so I'm trying to remember it, but it was a method not found error for the SQL server connector calling SetValue and I believe it was on the Microsoft.Extensions.Abstractions class or similar (can't quite remember)

Any help is much appreciated

[idlemind]

Issue raised