在代码首次应用XML列

问题描述

我想在代码中创建第一个XML列。我很清楚实体框架不完全支持XML列，它读取它们作为一个字符串。没关系。我仍想列类型是XML，虽然。这里是我的类：

I'm trying to create an XML column in Code First. I'm well aware Entity Framework doesn't fully support XML columns, and that it reads them as a string. That's fine. I would still like the column type to be XML, though. Here's my class:

class Content
{
    public int ContentId { get; set; }

    [Column(TypeName="xml")]
    public string XmlString { get; set; }

    [NotMapped]
    public XElement Xml { get { ... } set { ... } }
 }

但问题是，该代码首先迁移完全忽略列属性和创建域作为一个为nvarchar（最大）。我试着用 [数据类型（XML）] ，但是，也没有工作。

Problem is, that Code First Migrations completely ignores the Column attribute and creates the field as an nvarchar(max) . I tried using [DataType("xml")], but that, too, didn't work.

？这是迁移错误

推荐答案

你试过：

public String XmlContent { get; set; }

public XElement XmlValueWrapper
{
    get { return XElement.Parse(XmlContent); }
    set { XmlContent = value.ToString(); }
}

public partial class XmlEntityMap : EntityTypeConfiguration<XmlEntity>
{
    public FilterMap()
    {
        // ...
        this.Property(c => c.XmlContent).HasColumnType("xml");

        this.Ignore(c => c.XmlValueWrapper);
    }
}

这篇关于在代码首次应用XML列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！