Test your knowledge and understanding by answering some questions, getting some hands-on practice, and exploring this chapter's topics with deeper research.
Answer the following questions:
Which .NET data provider would you use to work with Microsoft Access
.MDB
database files?Which .NET data provider would you use to work with Microsoft SQL Server 2012 Express Edition?
What must you do with
DbConnection
variable before executing aDbCommand
variable?When would you use
CommandBehavior.SequentialAccess
?When would you use classic ADO.NET instead of Entity Framework?
When defining a
DbContext
class, what type would you use for the property that represents a table, for example, theProducts
property of aNorthwind
context?What are the EF conventions for primary keys?
When would you use an annotation attribute in an entity class?
Why might you choose the Fluent API in preference to annotation attributes?
What is the difference between Database...