Class XmlSchema.DataContext
- Namespace
- LinqToDB.Tools.DataProvider.SqlServer.Schemas
- Assembly
- linq2db.Tools.dll
public class XmlSchema.DataContext- Inheritance
-
XmlSchema.DataContext
- Extension Methods
Constructors
DataContext(IDataContext)
public DataContext(IDataContext dataContext)Parameters
dataContextIDataContext
Properties
ColumnXmlSchemaCollectionUsages
sys.column_xml_schema_collection_usages (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Returns a row for each column that is validated by an XML schema.
public ITable<XmlSchema.ColumnXmlSchemaCollectionUsage> ColumnXmlSchemaCollectionUsages { get; }Property Value
ParameterXmlSchemaCollectionUsages
sys.parameter_xml_schema_collection_usages (Transact-SQL)
Applies to: √ SQL Server (all supported versions) √ Azure SQL Database
Returns a row for each parameter that is validated by an XML schema.
public ITable<XmlSchema.ParameterXmlSchemaCollectionUsage> ParameterXmlSchemaCollectionUsages { get; }Property Value
SelectiveXmlIndexPaths
sys.selective_xml_index_paths (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Available beginning in SQL Server 2012 (11.x) Service Pack 1, each row in sys.selective_xml_index_paths represents one promoted path for particular selective xml index.
If you create a selective xml index on xmlcol of table T using following statement,
CREATE SELECTIVE XML INDEX sxi1 ON T(xmlcol)
FOR ( path1 = '/a/b/c' AS XQUERY 'xs:string',
path2 = '/a/b/d' AS XQUERY 'xs:double'
)There will be two new rows in sys.selective_xml_index_paths corresponding to the index sxi1.
public ITable<XmlSchema.SelectiveXmlIndexPath> SelectiveXmlIndexPaths { get; }Property Value
XmlIndexes
sys.xml_indexes (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Returns one row per XML index.
See sys.xml_indexes.
public ITable<XmlSchema.XmlIndex> XmlIndexes { get; }Property Value
XmlSchemaAttributes
sys.xml_schema_attributes (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Returns a row per XML schema component that is an attribute, symbol_space of A.
public ITable<XmlSchema.XmlSchemaAttribute> XmlSchemaAttributes { get; }Property Value
XmlSchemaCollections
sys.xml_schema_collections (Transact-SQL)
Applies to: √ SQL Server (all supported versions) √ Azure SQL Database
Returns a row per XML schema collection. An XML schema collection is a named set of XSD definitions. The XML schema collection itself is contained in a relational schema, and it is identified by a schema-scoped Transact\-SQL name. The following tuples are unique: xml_collection_id, and schema_id and name.
public ITable<XmlSchema.XmlSchemaCollection> XmlSchemaCollections { get; }Property Value
XmlSchemaComponentPlacements
sys.xml_schema_component_placements (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Returns a row per placement for XML schema components.
public ITable<XmlSchema.XmlSchemaComponentPlacement> XmlSchemaComponentPlacements { get; }Property Value
XmlSchemaComponents
sys.xml_schema_components (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Returns a row per component of an XML schema. The pair (collection_id, namespace_id) is a compound foreign key to the containing namespace. For named components, the values for symbol_space, name, scoping_xml_component_id, is_qualified, xml_namespace_id, xml_collection_id are unique.
public ITable<XmlSchema.XmlSchemaComponent> XmlSchemaComponents { get; }Property Value
XmlSchemaElements
sys.xml_schema_elements (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Returns a row per XML schema component that is a Type, symbol_space of E.
public ITable<XmlSchema.XmlSchemaElement> XmlSchemaElements { get; }Property Value
XmlSchemaFacets
sys.xml_schema_facets (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Returns a row per facet (restriction) of an xml-type definition (corresponds to sys.xml_types).
public ITable<XmlSchema.XmlSchemaFacet> XmlSchemaFacets { get; }Property Value
XmlSchemaModelGroups
sys.xml_schema_model_groups (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Returns a row per XML schema component that is a Model-Group, symbol_space of M..
public ITable<XmlSchema.XmlSchemaModelGroup> XmlSchemaModelGroups { get; }Property Value
XmlSchemaNamespaces
sys.xml_schema_namespaces (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Returns a row per XSD-defined XML namespace. The following tuples are unique: collection_id, namespace_id, and collection_id, and name.
public ITable<XmlSchema.XmlSchemaNamespace> XmlSchemaNamespaces { get; }Property Value
XmlSchemaTypes
sys.xml_schema_types (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Returns a row per XML schema component that is a Type, symbol_space of T.
See sys.xml_schema_types.
public ITable<XmlSchema.XmlSchemaType> XmlSchemaTypes { get; }Property Value
XmlSchemaWildcardNamespaces
sys.xml_schema_wildcard_namespaces (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Returns a row per enumerated namespace for an XML schema wildcard.
public ITable<XmlSchema.XmlSchemaWildcardNamespace> XmlSchemaWildcardNamespaces { get; }Property Value
XmlSchemaWildcards
sys.xml_schema_wildcards (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Returns a row per XML schema component that is an Attribute-Wildcard (kind of V) or Element-Wildcard (kind of W), both with symbol_space of N.
public ITable<XmlSchema.XmlSchemaWildcard> XmlSchemaWildcards { get; }