For Structure and Attractiveness, how do you analyze it? which framework do you use?

For most CRUD operations entity framework does an excellent job but when it comes to heavy queries involving more than3 or4 joins, Stored Procedures and Views does the magic.