How to: Add validation to entity classes

Validating entity classes is the process of confirming that the values entered into data objects comply with the constraints in an object's schema, and also to the rules established for the application. Validating data before you send updates to the underlying database is a good practice that reduces errors. It also reduces the potential number of round trips between an application and the database.

The LINQ to SQL Tools in Visual Studio provides partial methods that enable users to extend the designer-generated code that runs during Inserts, Updates, and Deletes of complete entities, and also during and after individual column changes.

Adding Validation for Changes to the Value in a Specific Column

This procedure shows how to validate data when the value in a column changes. Because the validation is performed inside the class definition (instead of in the user interface) an exception is thrown if the value causes validation to fail. Implement error handling for the code in your application that attempts to change the column values.

To validate data during a column's value change

1. Open or create a new LINQ to SQL Classes file (.dbml file) in the O/R Designer. (Double-click the .dbml file in Solution Explorer.)

2. In the O/R Designer, right-click the class for which you want to add validation and then click View Code.

   The Code Editor opens with a partial class for the selected entity class.

3. Place the cursor in the partial class.

4. For Visual Basic projects:

   1. Expand the Method Name list.

   2. Locate the OnCOLUMNNAMEChanging method for the column you want to add validation to.

   3. An OnCOLUMNNAMEChanging method is added to the partial class.

   4. Add the following code to first verify that a value has been entered and then to ensure that the value entered for the column is acceptable for your application. The value argument contains the proposed value, so add logic to confirm that it is a valid value:

      If value.HasValue Then
          ' Add code to ensure that the value is acceptable.
          ' If value < 1 Then
          '    Throw New Exception("Invalid data!")
          ' End If
      End If
      

      For C# projects:

   5. Because C# projects do not automatically generate the event handlers, you can use IntelliSense to create the column-changing partial methods.

      Type partial and then a space to access the list of available partial methods. Click the column-changing method for the column you want to add validation for. The following code resembles code that is generated when you select a column-changing partial method:

      partial void OnCOLUMNNAMEChanging(COLUMNDATATYPE value)
          {
             throw new System.NotImplementedException();
          }
      
      

Adding Validation for Updates to an Entity Class

In addition to checking values during changes, you can also validate data when an attempt is made to update a complete entity class. Validation during an attempted update enables you to compare values in multiple columns if business rules require this. The following procedure shows how to validate when an attempt is made to update a complete entity class.

To validate data during an update to an entity class

1. Open or create a new LINQ to SQL Classes file (.dbml file) in the O/R Designer. (Double-click the .dbml file in Solution Explorer.)

2. Right-click an empty area on the O/R Designer and click View Code.

   The Code Editor opens with a partial class for the DataContext.

3. Place the cursor in the partial class for the DataContext.

4. For Visual Basic projects:

   1. Expand the Method Name list.

   2. Click UpdateENTITYCLASSNAME.

   3. An UpdateENTITYCLASSNAME method is added to the partial class.

   4. Access individual column values by using the instance argument, as shown in the following code:

      If (instance.COLUMNNAME = x) And (instance.COLUMNNAME = y) Then
          Dim ErrorMessage As String = "Invalid data!"
          Throw New Exception(ErrorMessage)
      End If
      

      For C# projects:

   5. Because C# projects do not automatically generate the event handlers, you can use IntelliSense to create the partial UpdateCLASSNAME method.

   6. Type partial and then a space to access the list of available partial methods. Click the update method for the class you want to add validation for. The following code resembles code that is generated when you select an UpdateCLASSNAME partial method:

      partial void UpdateCLASSNAME(CLASSNAME instance)
      {
          if ((instance.COLUMNNAME == x) && (instance.COLUMNNAME = y))
          {
              string ErrorMessage = "Invalid data!";
              throw new System.Exception(ErrorMessage);
          }
      }
      

See Also

LINQ to SQL Tools in Visual Studio LINQ to SQL Validating Data