c# - 在Entity Framework Core上为属性允许的值添加约束(Add constraint on the values allowed for a property with Entity Framework Core)

Question

With EntityFramework Core how can I limit a property to some values with the modelBuilder ?

(使用EntityFramework Core，如何使用modelBuilder将属性限制为某些值？)

In SQL it's :

(在SQL中是：)

CONSTRAINT chk_Frequency CHECK (Frequency IN ('Daily', 'Weekly', 'Monthly', 'Yearly'))

Thanks,

(谢谢，)

  ask by Kris-I translate from so

Answer 1

List<string> str = new List<string>(){"Daily", "Weekly", "Monthly", "Yearly'}

在实体框架中使用Where

.Where(x=> str.Contains(x.Frequency ))