Class FullTextSearchSchema.DataContext
- Namespace
- LinqToDB.Tools.DataProvider.SqlServer.Schemas
- Assembly
- linq2db.Tools.dll
public class FullTextSearchSchema.DataContext- Inheritance
-
FullTextSearchSchema.DataContext
- Extension Methods
Constructors
DataContext(IDataContext)
public DataContext(IDataContext dataContext)Parameters
dataContextIDataContext
Properties
Catalogs
sys.fulltext_catalogs (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Contains a row for each full-text catalog.
note
The following columns will be removed in a future release of SQL Server: data_space_id, file_id, and path. Do not use these columns in new development work, and modify applications that currently use any of these columns as soon as possible.
public ITable<FullTextSearchSchema.Catalog> Catalogs { get; }Property Value
DocumentTypes
sys.fulltext_document_types (Transact-SQL)
Applies to: √ SQL Server (all supported versions) √ Azure SQL Database
Returns a row for each document type that is available for full-text indexing operations. Each row represents the IFilter interface that is registered in the instance of SQL Server.
public ITable<FullTextSearchSchema.DocumentType> DocumentTypes { get; }Property Value
IndexCatalogUsages
sys.fulltext_index_catalog_usages (Transact-SQL)
Applies to: √ SQL Server (all supported versions) √ Azure SQL Database
Returns a row for each full-text catalog to full-text index reference.
public ITable<FullTextSearchSchema.IndexCatalogUsage> IndexCatalogUsages { get; }Property Value
IndexColumns
sys.fulltext_index_columns (Transact-SQL)
Applies to: √ SQL Server (all supported versions) √ Azure SQL Database
Contains a row for each column that is part of a full-text index.
public ITable<FullTextSearchSchema.IndexColumn> IndexColumns { get; }Property Value
IndexFragments
sys.fulltext_index_fragments (Transact-SQL)
Applies to: √ SQL Server (all supported versions) √ Azure SQL Database
A fulltext index uses internal tables called *full-text index fragments* to store the inverted index data. This view can be used to query the metadata about these fragments. This view contains a row for each full-text index fragment in every table that contains a full-text index.
public ITable<FullTextSearchSchema.IndexFragment> IndexFragments { get; }Property Value
Indexes
sys.fulltext_indexes (Transact-SQL)
Applies to: √ SQL Server (all supported versions) √ Azure SQL Database
Contains a row per full-text index of a tabular object.
See sys.fulltext_indexes.
public ITable<FullTextSearchSchema.Index> Indexes { get; }Property Value
Languages
sys.fulltext_languages (Transact-SQL)
Applies to: √ SQL Server (all supported versions) √ Azure SQL Database
This catalog view contains one row per language whose word breakers are registered with SQL Server. Each row displays the LCID and name of the language. When word breakers are registered for a language, its other linguistic resources-stemmers, noise words (stopwords), and thesaurus files-become available to full-text indexing/querying operations. The value of name or lcid can be specified in the full-text queries and full-text index Transact\-SQL statements.
public ITable<FullTextSearchSchema.Language> Languages { get; }Property Value
RegisteredSearchProperties
sys.registered_search_properties (Transact-SQL)
Applies to: √ SQL Server (all supported versions) √ Azure SQL Database
Contains a row for each search property contained by any search property list on the current database.
public ITable<FullTextSearchSchema.RegisteredSearchProperty> RegisteredSearchProperties { get; }Property Value
RegisteredSearchPropertyLists
sys.registered_search_property_lists (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Contains a row for each search property list on the current database.
public ITable<FullTextSearchSchema.RegisteredSearchPropertyList> RegisteredSearchPropertyLists { get; }Property Value
SemanticLanguageStatisticsDatabases
sys.fulltext_semantic_language_statistics_database (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Returns a row about the semantic language statistics database installed on the current instance of SQL Server.
You can query this view to find out about the semantic language statistics component required for semantic processing.
public ITable<FullTextSearchSchema.SemanticLanguageStatisticsDatabase> SemanticLanguageStatisticsDatabases { get; }Property Value
SemanticLanguages
sys.fulltext_semantic_languages (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Returns a row for each language whose statistics model is registered with the instance of SQL Server. When a language model is registered, that language is enabled for semantic indexing.
This catalog view is similar to sys.fulltext_languages (Transact-SQL).
public ITable<FullTextSearchSchema.SemanticLanguage> SemanticLanguages { get; }Property Value
StopWords
sys.fulltext_stopwords (Transact-SQL)
Applies to: √ SQL Server (all supported versions) √ Azure SQL Database
Contains a row per stopword for all stoplists in the database.
public ITable<FullTextSearchSchema.StopWord> StopWords { get; }Property Value
Stoplists
sys.fulltext_stoplists (Transact-SQL)
Applies to: √ SQL Server (all supported versions) √ Azure SQL Database
Contains a row per full-text stoplist in the database.
public ITable<FullTextSearchSchema.Stoplist> Stoplists { get; }Property Value
SystemStopWords
sys.fulltext_system_stopwords (Transact-SQL)
Applies to: √ SQL Server (all supported versions) √ Azure SQL Database
Provides access to the system stoplist.
public ITable<FullTextSearchSchema.SystemStopWord> SystemStopWords { get; }