entity-framework - 如何向 ADO.NET 实体添加约束？

Question

我知道如何在 ADO.NET 实体中将一组字段标记为主键，但我还没有找到声明唯一约束或检查约束的方法。

设计器或框架上是否缺少此功能？

Answer 1

v4.0 中的 ADO.NET 实体中不存在对唯一键/约束的支持，请参阅“one-to-one association on a foreign key with unique constraint”的答案，Diego B Vega 说:

I know for sure we haven't added support for unique keys other than primary keys in 4.0.

但是，他确实提供了一种可能的解决方法/hack(附带所有正常警告):

As you are probably aware of, it is often possible to “lie” to Entity Framework and tell it in the SSDL, for instance, that some unique key is the primary key. I reckon this would work very well if the actual primary key is an surrogate key (i.e. an IDENTITY column that was added for this purpose) and you don’t even have to map it in the model.