I wrote my own T4 templates to point to a SQL Server Database and generate
- View Models (with Model Metadata info like [Required], [StringLength] based on SQL Schema)
- Repository classes
- Service classes
Cuts down a lot of tedious code for me and lets me focus on writing the important business logic code.
Microsoft MVP Dane Morgridge open sourced his T4 templates for generating Repository classes also.
If you Google for it, you'll see lots of blogs posts on T4 also.