Skip to content

.Net: [MEVD] [SQL Server] Support DateTimeOffset, string[] #13268

@roji

Description

@roji

From the standard types, it seems like we're misisng only DateTimeOffset and string[].

DateTimeOffset seems fairly straightforward, as SQL Server has a datetimeoffset date type which corresponds exactly to the .NET type (and this mapping exists both in SqlClient and in EF, Dapper, etc.).

string[] is slightly trickier - this is very useful for tags-like "Contains" queries, and many of the more primitive vector databases support that particular case. SQL Server 2025 is introduces a full-fledged JSON data type, including a JSON_CONTAINS function which seems ideal for this (note that vector search will only be available in SQL Server 2025, so it all aligns well). For now I'll likely implement only arrays of strings (as with most other databases) - we can always add arrays over other types later (though we'd have to be careful around client vs. server-side representations).

Metadata

Metadata

Assignees

Labels

.NETIssue or Pull requests regarding .NET codemsft.ext.vectordataRelated to Microsoft.Extensions.VectorDatatriage

Projects

Status

Sprint: In Review

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions