In the first place there are not many such generators available on the market. The few I tried did not give me much satisfaction until I found OxyGen Code. It is available at
TechIS - Products. OxyGen Code is a very versatile tool that allows modeling the data relationships, generates stored procedures (including data paging), data entities and many others. It is also worth mentioning the advanced query capabilities and well as the caching mechanism. I wish you good luck and Happy Holidays!