Don't be fooled with the EDM designer in SP1 beta for VS.NET 2008. Apparently there was no need "yet" for in depth customizability of the store model schema. For my class table inheritance example I'm using table prefixes since I'm running many examples on the same database. The prefix I'm using for this example is cti_ as you might have guessed. Everything works as you would expect until you try to write a linq to entities query. Instead of writing:
var query = (from f in ctx.Players
where f.Name == "Roger"
select f).First();
I have to write, in order to have a happy compiler, something like this:
var query = (from f in ctx.cti_Players
where f.Name == "Roger"
select f).First();
In order to fix this you need to hack your way into the schema files. Not really a problem as long as you don't need to do this for many entities. Designer support would be very useful though.
I encountered this weird bug that when you copy paste a project containing an EDM file to a different directory other than it was created in, it doesn't open anymore in VS.NET.
I must be overlooking something.
The ID field in my SQL Server database is configured to autoincrement through setting the Identity seed and Identity increment properties. For some reason the generated code allows the end user of the conceptual EDM model to set the ID property since it’s public. I would expect the setter to be at least private.