how to add min length check constraint in database side through EF code first?

Question

I am trying to add check constraint in database side through Entity Framework code first approach,

ALTER TABLE [dbo].[YOUR_TABLE]
ADD CONSTRAINT [MinLengthConstraint] CHECK (DATALENGTH([your_column]) > 2)

I am decorating entity property with String Length & Min Length, but the check constraint is not applied to database table. Please suggest!

    [StringLength(100), MinLength(2)]
    public string StudentName { get; set; }

Ppp · Accepted Answer · 2015-10-08 08:56:19Z

2

How about this? Change StringLength to Maxlength.

[MaxLength(100), MinLength(2)]
public string StudentName { get; set; }

Quite sure that it works with linq-to-entity but not sure if it will apply the constraint to DB level. Not working on DB level.

If you are using initializer, you can execute SqlCommand to create the constraint. A workaround for it. Not tested but should work.

protected override void Seed(MyContext context)
{
  context.Database.ExecuteSqlCommand("ALTER TABLE [dbo].[YOUR_TABLE]
  ADD CONSTRAINT [MinLengthConstraint] CHECK (DATALENGTH([your_column]) > 2)");
}

edited Oct 8, 2015 at 8:56

answered Oct 8, 2015 at 3:01

Ppp

1,0159 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

jeancallisti Over a year ago

Then if it's not working how was it marked as correct answer?

Collectives™ on Stack Overflow

how to add min length check constraint in database side through EF code first?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related