The Four Deadly Sins of LINQ Data Access: Part 3–Insufficiently Chatty Queries

added by Paul Wheeler
3/21/2014 2:28:45 PM

2 Kicks, 101 Views

Last time in this series, I showed how a common and easy-to-use method of Entity Framework would result in more columns than necessary being returned from the database, and before that, I described the cause and solution for Overly Chatty Queries. At the end of the last post, I said that yes, there is such a thing as an "Underly" chatty query, and I suspect that statement might have sounded odd to some. After all, the first post was all about how bad it is to have a chatty query because issuing new connections and queries to the database is expensive. However, it really is possible not to be chatty enough, for at least two reasons that I can think of.