Thanks for the sample project, it was very enlightening. We have just run into one snag that we can't get around. In our application we deal with a sql express / sql local db table that has a schema that is unknown until run-time. Basically no solution that involves hard coding any kind of schema or model before compile time will work for us.
Thus, this notion of using the Entity Framework with a DbSet<tableSchemaClass> predefined will just not work for what we need.
I've looked around on this site and ran into this:
Run-time Schema Changes
Schema Change API of Telerik OpenAccess ORM allows you to make runtime
changes to the application's object model or database schema without
recompilation of the application.
This sounds similar to what we are interested in. I guess what I am asking is if you can think of any other way to make this happen without using the Entity Framework since it seems to require some sort of hard-coded model. Otherwise is there any way to make changes to an entity framework model at runtime? (I was extremely unsuccessful at finding any information on that front)
I know delving into the entity framework is outside the realm of Telerik controls, but any info would be highly appreciated.
After a lot of research and trying some strange things like creating a class at run-time via Reflection.Emit to use inside of DbSet I have realized that EF is simply not meant to work in this way. The things it does with the model make this next to impossible. I don't understand how such a simple concept as a database with a table with unknown columns can be such a huge hurdle.