如何在SQL Server中使用AXSD？(How do I use AXSD in SQL Server?)

如何在SQL Server中使用AXSD？(How do I use AXSD in SQL Server?)

在SQL Server中，您可以使用XML数据类型并使用AXSD架构将其映射到关系列。

XML和关系存储之间的映射通过使用带注释的模式（AXSD），XML被分解为一个或多个表中的列。 这保持了关系级数据的保真度。 结果，尽管忽略了元素之间的顺序，但仍保留了分层结构。 架构不能递归。

来自MSDN

但是，我找不到任何关于如何执行此操作的文档 - 甚至是关于AXSD的好页面。

任何人都有任何好的AXSD信息。 它似乎非常适合我想做的事情（暂时使用XML，直到我可以迁移到像nHibernate这样的东西，但仍然允许某些相关数据字段的列视图。

In SQL Server you can use an XML datatype and map it to relational columns using an AXSD schema.

Mapping between XML and relational storage By using an annotated schema (AXSD), the XML is decomposed into columns in one or more tables. This preserves fidelity of the data at the relational level. As a result, the hierarchical structure is preserved although order among elements is ignored. The schema cannot be recursive.

from MSDN

However I cannot find any documentation on how to do this - or even a good page about AXSD.

Anybody got any good AXSD information. it seems very appropriate to what I want to do (temporarily use XML until i can migrate to something like nHibernate, but still allow a column view of certain pertanent data fields.

最满意答案

看起来这是这样做的方式 ， 这也很有帮助 。

还有一本免费的书 ！

提示：搜索'annotated xsd schemass'而不是AXSD！

<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sql="urn:schemas-microsoft-com:mapping-schema"> <xsd:element name="Employee" sql:relation="Employees" > <xsd:complexType> <xsd:sequence> <xsd:element name="FName" sql:field="FirstName" type="xsd:string" /> <xsd:element name="LName" sql:field="LastName" type="xsd:string" /> </xsd:sequence> <xsd:attribute name="EmpID" sql:field="EmployeeID" type="xsd:integer" /> </xsd:complexType> </xsd:element> </xsd:schema>

Looks like this is the way to do it and this is helpful too.

And a free book too!

tip: search for 'annotated xsd schemass' and not AXSD!

<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sql="urn:schemas-microsoft-com:mapping-schema"> <xsd:element name="Employee" sql:relation="Employees" > <xsd:complexType> <xsd:sequence> <xsd:element name="FName" sql:field="FirstName" type="xsd:string" /> <xsd:element name="LName" sql:field="LastName" type="xsd:string" /> </xsd:sequence> <xsd:attribute name="EmpID" sql:field="EmployeeID" type="xsd:integer" /> </xsd:complexType> </xsd:element> </xsd:schema>