I have very little experience using MM .NET and MS SQL Server. I hope someone can give me experienced advice and suggestions. I am creating a new SQL database and table. I will be creating a Windows forms application using MM .NET v2.4. One of the columns in the table will be a decimal column and I want to be sure the value in that column is always positive. The value will be entered by the user on a Windows form.

The question is where to make sure the value is positive. I could do it as an SQL constraint on the column. Or I could use MM .NET rules to validate the value. Or maybe I could set properties on the textbox control to validate it. Or perhaps some combination of these or other ideas. It seems like a lot of development work to test the value in all three places, but if that is the best practice please tell me so.

Sam Tenney