.Net: Bug: Microsoft.SemanticKernel.Connectors.SqlServer Method not found: 'Void Microsoft.Extensions.VectorData.ProviderServices.PropertyModel.SetValue(System.Object, !!0)'.

[idlemind]

Describe the bug
Exception Method not found: 'Void Microsoft.Extensions.VectorData.ProviderServices.PropertyModel.SetValue(System.Object, !!0)'. when executing await foreach (TextSearchResult result in textResults.Results)

Message:
Method not found: 'Void Microsoft.Extensions.VectorData.ProviderServices.PropertyModel.SetValue(System.Object, !!0)'.

Source:
Microsoft.SemanticKernel.Connectors.SqlServer

Stak Trace:
at Microsoft.SemanticKernel.Connectors.SqlServer.SqlServerMapper1.<MapFromStorageToDataModel>g__PopulateValue|2_0(SqlDataReader reader, PropertyModel property, Object record) at Microsoft.SemanticKernel.Connectors.SqlServer.SqlServerMapper1.MapFromStorageToDataModel(SqlDataReader reader, Boolean includeVectors)
at Microsoft.SemanticKernel.Connectors.SqlServer.SqlServerCollection2.<ReadVectorSearchResultsAsync>d__23.MoveNext() at Microsoft.SemanticKernel.Connectors.SqlServer.SqlServerCollection2.d__23.System.Threading.Tasks.Sources.IValueTaskSource<System.Boolean>.GetResult(Int16 token)
at Microsoft.SemanticKernel.Connectors.SqlServer.SqlServerCollection2.<SearchAsync>d__211.MoveNext()
at Microsoft.SemanticKernel.Connectors.SqlServer.SqlServerCollection2.<SearchAsync>d__211.MoveNext()
at Microsoft.SemanticKernel.Connectors.SqlServer.SqlServerCollection2.<SearchAsync>d__211.System.Threading.Tasks.Sources.IValueTaskSource<System.Boolean>.GetResult(Int16 token)
at Microsoft.SemanticKernel.Data.VectorStoreTextSearch1.<ExecuteVectorSearchAsync>d__16.MoveNext() at Microsoft.SemanticKernel.Data.VectorStoreTextSearch1.d__16.MoveNext()
at Microsoft.SemanticKernel.Data.VectorStoreTextSearch1.<ExecuteVectorSearchAsync>d__16.System.Threading.Tasks.Sources.IValueTaskSource<System.Boolean>.GetResult(Int16 token) at Microsoft.SemanticKernel.Data.VectorStoreTextSearch1.d__18.MoveNext()
at Microsoft.SemanticKernel.Data.VectorStoreTextSearch1.<GetResultsAsTextSearchResultAsync>d__18.MoveNext() at Microsoft.SemanticKernel.Data.VectorStoreTextSearch1.d__18.System.Threading.Tasks.Sources.IValueTaskSource<System.Boolean>.GetResult(Int16 token)

To Reproduce
Steps to reproduce the behavior:

1. Builder kernel with IEmbeddingGenerator AsIEmbeddingGenerator()
2. Add AddSqlServerCollection
3. Build the collection
4. Search the collection using new VectorStoreTextSearch(vectorStoreCollection);
5. KernelSearchResults textResults = await textSearch.GetTextSearchResultsAsync(query, new() { Top = 5, Skip = 0 });
6. Exception caught here:

try
{
await foreach (TextSearchResult result in textResults.Results)
{
memoryBuilder.AppendLine(result.Value);
}
}
catch (Exception ex)
{
throw;
}

Expected behavior
TextSearchResult returns search results for the created collection

Screenshots
If applicable, add screenshots to help explain your problem.

Platform

• Language: C#
• Source: Microsoft.Extensions.VectorData.Abstractions 9.5.0, Microsoft.SemanticKernel 1.56.0, Microsoft.SemanticKernel.Connectors.SqlServer 1.56.0-preview
• AI model: text-embedding-ada-002
• IDE: Visual Studio
• OS: Windows

Additional context
I have created a console app here (https://github.com/idlemind/RAGTest).

The solution uses AzureOpenAIEmbeddings text-embedding-ada-002

[rwjdk]

I've hit this error as well. In 1.54.0 it works, but 1.55.0 and 1.56.0 fail with this error (using SQL Server as the Vector provider)

[roji]

You are almost certainly mixing incompatible versions of Microsoft.Extensions.VectorData (the general abstractions library) and Microsoft.SemanticKernel.Connectors.SqlServer (the SQL Server provider). I'd recommend using the latest version of both - these should be compatible; otherwise, check which exact version of ME.VectorData is referenced by your MSC.SqlServer version and use that.

If you can't get this to work, please post your csproj.

[rwjdk]

@roji: I don't have the Microsoft.Extensions.VectorData nuget referenced (trasative via Microsoft.SemanticKernel.Connectors.SqlServer as 9.5.0)

Adding it as Nuget specifically does not resolve the issue

Here are the nuget of the failing packages:

<ItemGroup>
		<PackageReference Include="Azure.Security.KeyVault.Secrets" Version="4.7.0" />
		<PackageReference Include="Blazored.LocalStorage" Version="4.5.0" />
		<PackageReference Include="Coravel" Version="6.0.2" />
		<PackageReference Include="CronExpressionDescriptor" Version="2.41.0" />
		<PackageReference Include="JetBrains.Annotations" Version="2024.3.0" />
		<PackageReference Include="KristofferStrube.Blazor.Confetti" Version="0.2.1" />
		<PackageReference Include="Markdig" Version="0.41.2" />
		<PackageReference Include="Markdown.ColorCode" Version="3.0.0" />
		<PackageReference Include="Microsoft.AspNetCore.DataProtection.EntityFrameworkCore" Version="9.0.5" />
		<PackageReference Include="Microsoft.AspNetCore.Identity.EntityFrameworkCore" Version="9.0.5" />
		<PackageReference Include="Microsoft.AspNetCore.Identity.UI" Version="9.0.5" />
		<PackageReference Include="Microsoft.EntityFrameworkCore.SqlServer" Version="9.0.5" />
		<PackageReference Include="Microsoft.EntityFrameworkCore.Tools" Version="9.0.5">
			<PrivateAssets>all</PrivateAssets>
			<IncludeAssets>runtime; build; native; contentfiles; analyzers; buildtransitive</IncludeAssets>
		</PackageReference>
		<PackageReference Include="Microsoft.Extensions.Logging.Console" Version="9.0.5" />
		<PackageReference Include="Microsoft.Identity.Web" Version="3.9.3" />
		<PackageReference Include="Microsoft.Identity.Web.UI" Version="3.9.3" />
		<PackageReference Include="Microsoft.SemanticKernel" Version="1,56.0" />
		<PackageReference Include="Microsoft.SemanticKernel.Connectors.SqlServer" Version="1.56.0-preview" />
		<PackageReference Include="Microsoft.SemanticKernel.Agents.Core" Version="1.56.0" />
		<PackageReference Include="NCrontab.Signed" Version="3.3.3" />
		<PackageReference Include="Octokit.Webhooks.AspNetCore" Version="2.4.1" />
		<PackageReference Include="OpenTelemetry.Api" Version="1.12.0" />
		<PackageReference Include="Radzen.Blazor" Version="7.0.8" />
		<PackageReference Include="Relewise.Internals.SecretKeys" Version="1.12.0" />
		<PackageReference Include="MudBlazor" Version="8.6.0" />
		<PackageReference Include="Octokit" Version="14.0.0" />
		<PackageReference Include="ReverseMarkdown" Version="4.7.0" />
		<PackageReference Include="ScottPlot" Version="5.0.55" />
		<PackageReference Include="SendGrid" Version="9.29.3" />
		<PackageReference Include="SkiaSharp" Version="3.119.0" />
		<PackageReference Include="Slack.NetStandard" Version="9.9.0" />
		<PackageReference Include="TrelloDotNet" Version="2.0.5" />
		<PackageReference Include="CsvHelper" Version="33.1.0" />
		<PackageReference Include="WorkTimeCalculator" Version="1.0.5" />
	</ItemGroup> ```

[roji]

@rwjdk thanks, I looked into it and you're right - the latest provider packages have a problematic dependency - I'll discuss this with the team and we'll fix it. In the meantime, avoid using the latest versions - I can see 1.54.0-preview working well.

Minimal repro

using var collection = new SqlServerCollection<int, Record>(connectionString, "Records");
await collection.EnsureCollectionDeletedAsync();
await collection.EnsureCollectionExistsAsync();

await collection.UpsertAsync(new Record
{
    Id = 1,
    Name = "Test Record",
    Vector = [0.1f, 0.2f, 0.3f]
});

var record = await collection.GetAsync(1);
Console.WriteLine(record!.Name);

public class Record
{
    [VectorStoreKey]
    public int Id { get; set; }

    [VectorStoreData]
    public required string Name { get; set; }

    [VectorStoreVector(Dimensions: 3)]
    public float[]? Vector { get; set; }
}

[rwjdk]

@roji : Thanks. Already downgraded so not a big issue on my end...