SQL Server Solutions - Maintain Local Data Integrity By Identifying Constraints In The DataTable
A well-designed database will enforce primary and foreign key constraints, but why waste network bandwith trying to perform inserts, updates, or deletes in the database that will fail? We'll show you how to enforce and handle constraints in .NET to avoid passing any bad data onto the server.
To keep your DataTable data as healthy as your database data, we'll:
- Discuss why constraints are as important in your DataTable as they are in your database
- Help you create primary, unique, and foreign key constraints in a DataTable
- Show you how to alter a constraint's behavior to better support the rules defined on your database server
Read More About This Tip Click Here > SQL Server Tips