I'm starting a new ASP.NET project, and am looking into using the Entity Framework. It seems that MS is really pushing things in this direction, but coming from a SQL background, I have a bias towards the "Code - First" approach. I want the best of both worlds -- I want to have full control over my database schema, but also want the automation of the Entity Framework.
There's a way to design my SQL database myself, and then have EF take over all the CRUD operations. For anyone who tried this approach -- was it easy to maintain?
Also, wondering what all the database experts on Experts Exchange think about Entity Framework.