Visual Basic® 2010 Unleashed

Custom Validations

Validating data is one of the most important activities in every data access system, so LINQ to SQL provides its own methodologies, too. To accomplish data validation, you can take advantage of partial methods. You may remember that in Chapter 21, “Advanced Language Features,” you got a practical example of partial methods when discussing LINQ to SQL. Validation rules are useful in LINQ to SQL for two main reasons: The first one is that they enable you to understand if supplied data is compliant to your requirements; the second one is that they allow checking if supplied data has a SQL Server type counterpart. The following code example demonstrates both examples. Imagine you want to add a new product to the object model and ...