.NET classes from EDM schema and entity relationships

Does the generation of .NET classes from EDM schema and entity relationships uses the actual relational database? Also when you create EDM schema and entity sets and relationships, does the database really has to exist?
[219 byte] By [SJ0775] at [2008-2-4]
# 1

Moving the thread to ADO.NET CTP.

To the first question - when you generate classes from EDM schema, the database is not accessed.

To the second question - you can create EDM files manually in which case no database is accessed. But you may use a tool (EntityModelGeneration.exe?) that needs a database to generate all the files for you.

ZlatkoMichailov-MSFT at 2007-8-30 > top of Msdn Tech,Visual Studio Orcas,ADO.NET Orcas...
# 2

Assuming that EDM files are created manually, is it posssible to create a relational database schema based on the information in those files? Is there a tool to do that or are you planning to have something like that in upcoming releases?

SJ0775 at 2007-8-30 > top of Msdn Tech,Visual Studio Orcas,ADO.NET Orcas...
# 3

Yes, we have plans for upcoming releases.

The entity mapping tool (internal prototype I mentioned in another thread) has a schema translation feature that allows generating a relational schema (.ssdl file) from an EDM schema (.csdl file) and exporting SQL DDL to create the necessary tables in the database. It supports 3 standard inheritance mapping strategies (TPH, TPC, TPT).

Again, the release schedule and feature scope are pending.

- Sergey

SergeyMelnik-MSFT at 2007-8-30 > top of Msdn Tech,Visual Studio Orcas,ADO.NET Orcas...

Visual Studio Orcas

Site Classified