CodeSmith is another good tool from what I heard.
There is no such thing as the best DAL, only the best for the current solution.
For many years, we used an internal product that was not so bad, but ultimately did not give in to control of commercial products.
source share