Chapter 8 – Working with Relational Data Using the Entity Framework

1. Which .NET data provider would you use to work with Microsoft Access .MDB database files?

   .NET Framework Data Provider for OLE DB.

2. Which .NET data provider would you use to work with Microsoft SQL Server 2012 Express Edition?

   .NET Framework Data Provider for SQL Server.

3. What must you do with a DbConnection variable before executing a DbCommand?

   Ensure that its state is open by calling the Open() method.

4. When would you use the CommandBehavior.SequentialAccess property?

   This option provides a way for a DbDataReader class to handle rows that contain columns with BLOBs (binary large objects), such as videos and images, by not loading the entire row at once and instead loading one column at a time, allowing skipping of columns, and reading the BLOB data as a stream.

5. ADO.NET instead of Entity Framework?

   You would use classic ADO.NET instead of Entity Framework when you need the best performance, when most data access must use stored...