You dont mock the db layer, i dont do that at least, hell no. Let the db be hit, check that the records it returns make sense. Thats how I roll at least.
Didn't want to aim at you with the reply, just remembered the collective delusion of 100% coverage unit testing zealots and how this would ironically fail to catch this.
You'd be surprised how far people go to shoot themselves in the foot.
You'd be surprised how far people go to shoot themselves in the foot.