Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> Incubation Technologies >> Project Codename: Astoria

Astoria Data Services

Hi,

Whether it is possible to create a data service with multiple databases and datasources?

Shaki

[122 byte] By [Shakky] at [2008-3-5]
«« Changing Color for Links
»» font substitution issue!!
# 1
The current prototype CTP supports creating an Astoria service over a single Entity Data Model. What are the scenarios you have in mind?
MikeFlasko at 2007-10-3 > top of Msdn Tech,Incubation Technologies,Project Codename: Astoria...
# 2

One scenario I'm trying to accomplish is having a base "Common" EDM for things such as accounts, addresses, countries, users, etc. and then having application-specific EDM that sits on top of that.

EF currently allows the csdl's to import other csdls, but does not support this functionality for msls and ssdls.

But it sure would be nice. Smile

MichaelD! at 2007-10-3 > top of Msdn Tech,Incubation Technologies,Project Codename: Astoria...
# 3

Thinking purely from a service-oriented point of view - why would you not simply expose the multiple models as multiple services?

You could expose a central "Contacts" service for manipulating and querying individual people, and then expose multiple application domain-specific services that have domain-specific data contained within. Again, this is just a quick thought without knowing any details about your architecture.

KevinHoffman at 2007-10-3 > top of Msdn Tech,Incubation Technologies,Project Codename: Astoria...
# 4

Kevin has a point in that trying to have a "grand schema of all the data" is something that experience has shown to be very challanging at best. Using targeted models for each of the subject areas that you want data from may be a more manageable solution.

Now, to answer your question specifically: the current CTP bits can only expose information from a single database (the database may in turn get data from multiple places, but that's beyond what Astoria knows). We're in the process of opening a bit more how you can plug data sources into Astoria (more details to come to the Astoria blog sometime next week). That will allow more flexibility, but from the Astoria perspective we'll still focus on a single data source per service. You could have a data source that is itself composite, but you have to build the support for it yourself.

Pablo Castro

Technical Lead

Microsoft Corporation

http://blogs.msdn.com/pablo

PabloCastro-MSFT at 2007-10-3 > top of Msdn Tech,Incubation Technologies,Project Codename: Astoria...
Incubation Technologies
Project Codename: Astoria

Incubation Technologies Hot Topic

Incubation Technologies New Topic

Incubation Technologies

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified