Workshop
This workshop will help reinforce the concepts covered in today's lesson.
Quiz
| 1: | What is the significance of SqlClient formulating TDS packets? |
| A1: | The SqlClient provider creates TDS packets and hands them off to the Net-Library responsible for building network packets and sending them to the server. The significance of this is that SqlClient is directly using the application protocol that SQL Server listens for and so is much faster than first going through an OLE DB provider or ODBC driver. In fact, SqlClient is the fastest way to access SQL Server. |
| 2: | What are some of the benefits of normalization? |
| A2: | A normalized database eliminates redundant data and therefore reduces the storage required. It also makes the data more maintainable ... |
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.
