I generally don’t use a lot of stored procedures unless I have bulk data operations or crazy grid scenarios that I’m trying to forget. If you need to use stored procedures with code first, you’re in luck—EF6 supports mapping an entity to a stored procedure and handles complicated mapping scenarios. I haven’t personally used it, but it looks really useful.