Has anyone considered the using Entity Framework for Sitecore Content Tree access?
Problem: Access the content tree without having to use "magic strings" or a "constants file" and via data container (entity) objects that are based on our custom templates from the Sitecore Content Tree.
Possible Solution: Use the .Net Entity Framework to spin up (generate) strongly typed objects based on our templates.
Benefits: This would allow the use of...
1. Linq to CRUD the content tree
1.1 Allowing simple access to developer who know Linq, as long as a experience Sitecore dude setup the .edmx and T4 and Content Tree
2. Allow vast control over the generated classed via the EF designer and T4
3. Allow very simple strongly typed Content Tree access
4. Allow problems to be caught by the compiler and not by running and testing the code
4.1 Without a server class dev box (which all of us should have but...) it takes a long time to debug changes to Sitecore code. If the compiler can catch problems this is a huge win!
I've been trying to become the worlds most productive Sitecore Dude (it's good to have a goal). I have been researching the Entity Framework, T4, Linq and all that jazz. I have the idea that between Linq to Entities and Web Controls even the problem of Web User Controls being full of strings that aren't tested at compile time can be overcome.
Please note that something similar to this was tried with ClassySC but it wasn't complete enough to provide the required benefits (useful but not complete).
Please note that magic strings are still used but they are in a common abstraction (the edmx file) that the developer does not have to care about.
Has anyone ever done this? Does anyone have a working .edmx file and code example that allows this?