Summary
Understanding the components of ADO.NET is only part of the picture when designing and implementing applications for SQL Server. It's also important to use good design techniques when building your schema and deciding how your ADO.NET application will communicate with SQL Server.
Today you learned how SqlClient communicates with SQL Server, how to apply some basic relational modeling techniques to your schema, and how SQL Server objects such as constraints can be used to increase data integrity. In addition, you should keep in mind the short discussion about alternatives because they might be more applicable than SqlClient for certain scenarios.
Tomorrow we'll finish the week by looking briefly at the ODBC .NET Data Provider as well as ...
Get Sams Teach Yourself ADO.NET in 21 Days now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
