实体框架实体中的枚举类型属性？

发布于 2024-09-11 22:29:30 字数 276 浏览 1 评论 0原文

有没有办法可以将生成的实体映射到枚举？

我的意思很简单：

class Person
{
    RelationshipStaus RelationshipStatus { get; set; }
}

enum RelationshipStatus : byte
{
    Single,
    Married,
    Divorced
}

数据库中的属性RelationshipStatus是一个简单的字节，我希望在我的项目中它应该是一个枚举。

原文

Is there a way I can map generated entities to enum?

And what I mean is simple:

class Person
{
    RelationshipStaus RelationshipStatus { get; set; }
}

enum RelationshipStatus : byte
{
    Single,
    Married,
    Divorced
}

The property RelationshipStatus in the DB is a simple byte, I want that in my project it should be an enum.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

看海 2024-09-18 22:29:30

不幸的是，你不能，至少不能直接这样做。为了方便起见，您可以创建一个访问器来将值与枚举类型相互转换：

public int RelationshipStatusInt { get; set; }

public RelationshipStatus RelationshipStatus
{
    get { return (RelationshipStatus)RelationshipStatusInt; }
    set { RelationshipStatusInt = (int)value; }
}

但是，您将无法在 Linq to EF 查询中使用该属性，因为它不会映射到 DB 列（但您可以可以在 Linq to Objects 查询中使用它）。

描述了另一个解决方案这里，不过感觉有点别扭……

Unfortunately, you can't, at least not directly. For convenience, you can create an accessor that converts the value to and from the enum type:

public int RelationshipStatusInt { get; set; }

public RelationshipStatus RelationshipStatus
{
    get { return (RelationshipStatus)RelationshipStatusInt; }
    set { RelationshipStatusInt = (int)value; }
}

However you won't be able to use that properties in Linq to EF queries, because it won't be mapped to a DB column (but you can use it in Linq to Objects queries).

Another solution is described here, but it feels a bit awkward...

回复收藏 0 原文