Print Page | Close Window

one edmx multiple data sources?

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce 2009
Forum Discription: For .NET 3.5
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=1018
Printed Date: 28-Apr-2026 at 12:13am


Topic: one edmx multiple data sources?
Posted By: lucence
Subject: one edmx multiple data sources?
Date Posted: 06-Dec-2008 at 12:06am
currently for ADO.NET EF, we could make it support for multiple databases by adding respective edmx files.
 
but for DevForce EF, does it support 1 edmx and shift to different databases at anytime?
 
 


Replies:
Posted By: kimj
Date Posted: 06-Dec-2008 at 2:21pm
DevForce EF is built "on top" of ADO.NET EF.  The limitation of 1 EDMX = 1 database still holds.  In DevForce, though, you can include multiple entity data models in a single DevForce "domain" model, as is shown in several of the tutorials. 
 
On the latter part of your question about shifting to a different database - I assume you mean having a single CSDL (conceptual model) with different SSDL (storage model) definitions?  That is doable, and one of the reasons why the EDMX at runtime actually consists of 3 separate resources (conceptual, storage and mapping).  DevForce doesn't do anything to help or hinder this support, and I'd recommend the ADO.NET EF forum ( http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=533&SiteID=1 - http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=533&SiteID=1 ) or other MS resources for help on the mechanics of separating the models.


Print Page | Close Window