Lingua

SqlServerQueryableExtensions Class

Definition

SQL Server extension methods for LINQ queries.

[System.Runtime.CompilerServices.Nullable(0)]
public static class SqlServerQueryableExtensions
[<System.Runtime.CompilerServices.Nullable(0)>]
type SqlServerQueryableExtensions = class
Public Module SqlServerQueryableExtensions
Inheritance
SqlServerQueryableExtensions
Attributes

Methods

Name Description
ContainsTable<T,TKey>(DbSet<T>, String, Expression<Func<T,Object>>, String, Nullable<Int32>)

Queries a full-text index using the SQL Server CONTAINSTABLE function.

FreeTextTable<T,TKey>(DbSet<T>, String, Expression<Func<T,Object>>, String, Nullable<Int32>)

Queries a full-text index using the SQL Server FREETEXTTABLE function.

VectorSearch<T,TVector>(DbSet<T>, Expression<Func<T,TVector>>, TVector, String)

Search for vectors similar to a given query vector using the SQL Server VECTOR_SEARCH() function.

WithApproximate<T>(IQueryable<T>)

Enables approximate nearest neighbor (ANN) search for a vector search query. This causes WITH APPROXIMATE to be added to the SQL TOP clause, instructing SQL Server to use the vector index for better performance.

Applies to