Re: At its best, it is like magic
I've never used EF, but I did once take over maintenance for a mess of a project which used NHibernate in some parts and some third party code generation tool whose name I forget in others. And direct SqlCommand access to views which were 200 lines long and full of subqueries on the admin side. In some ways the third party tool was the best: sure, it was a pain in the arse to use, but it avoided the black box problem because when I really got fed up with some aspects of the code it was generating I could edit the templates. (Some kind of VBA, I think. I never found out exactly, but it's not the only time I've had to maintain code in a language I didn't know. Eventually I figured out how to make the tool use C#, and rewrote the templates from scratch).