Hello,
I have modified the CodeSmith templates to generate code using the Enterprise Library data access application block instead of the being tied to using the SQL-specific types.
It's not perfect yet, but it has really helped me. Also I only modified the C# templates because I don't use VB.NET.
I hope no one minds me linking to my blog directly, but I discussed much more in depth about the changes made and also has the download link.
I plan to make further modifications, such as using the exception handling application block for better error handling, but I hope you find the existing templates of use.
Copyright (c) Marimer LLC