Let's talk about database interaction testing approaches

Let's talk about different approaches to database interaction testing in .NET, mainly when working through Entity Framework. We'll look at the pros and cons of different solutions, as well as different situations in which one approach is preferable to the other.