SQL table vs Entity Framework MVC

Question

I know a little bit of MVC but I want to develop MVC with DataBase first. I want to know one thing. I saw in the internet a table like that:

CREATE TABLE dbo.Payroll 
    (
     ID int PRIMARY KEY, 
     PositionID INT, 
     Salary decimal(9,2),
     SalaryType nvarchar(10),  
     CHECK  (Salary > 10.00 and Salary < 150000.00) 
    );

I wanna know if the CHECK element will result in data-validation in my webSite .

thx in advance

You have to enforce the same constraint on the front-end. If you didn't, an unhandled error or exception would be thrown that you must explicitly catch. You're not likely to do so. — Lion
– Lion, Commented Jan 31, 2013 at 23:02

lahsrah · Accepted Answer · 2013-01-31 22:56:57Z

2

No, it won't automatically add validation on your website. It will enforce that constraint on the database and will "crash" if the user enters a value outside that range.

You should still add validation on the client side to prevent unhandled errors from the database.

answered Jan 31, 2013 at 22:56

lahsrah

9,2135 gold badges39 silver badges70 bronze badges

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

Comments

codingbiz · Accepted Answer · 2013-01-31 22:59:41Z

1

The validation won't be done in the web application/site but on the database. Just like a UNIQUE or FOREIGN KEY constraint, it would throw error/exception if that constraint is violated

See this fiddle: http://sqlfiddle.com/#!3/ede45 - remove the comment in the last line and see how it violates the constraints and throws error - which the user will see if not handled. You need to handle such entry before it gets to the database and the constraint would just be a double-check or cross-check

answered Jan 31, 2013 at 22:59

codingbiz

26.4k9 gold badges62 silver badges99 bronze badges

Collectives™ on Stack Overflow

SQL table vs Entity Framework MVC

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related