Support for WCF Data Services?

01-27-2010, 4:55 AM
Will you support WCF Data Services?

I am right in assuming that currently I would have to convert the query result from a Data Service to a DataSet to be able to use Analysis?

Re: Support for WCF Data Services?

01-28-2010, 3:10 PM
Hello,

I am working on this and would reply you soon.

Regards,
Aashish

Re: Support for WCF Data Services?

02-02-2010, 10:14 AM
pmeinl,

It is possible to bind WCF Data Services to Analysis using the Unbound Data Source. However, the data source must be a flattened hierarchy as Analysis currently cannot follow the navigation properties of the entities. In my sample, I used the SQL Server 2000 pubs sample database to create a data service. I then added a view in the database (on the sql server side of things) and then added this view to my entity data model.

Once this is done, the schema will need to be manually created via the SchemaBuilder API. The attached sample should only need to have the query string modified in the DataServiceHost project's web.config if you already have pubs installed. If you don't have pubs, you can get it here: http://www.microsoft.com/downloads/details.aspx?FamilyId=06616212-0356-46A0-8DA2-EEBC53A68034&displaylang=en

Let me know if you have any questions.


-Jon

Re: Support for WCF Data Services?

02-02-2010, 10:28 AM
Additionally, here is the SQL for the View:

SELECT     dbo.titles.title_id, dbo.titles.title, dbo.titles.type, dbo.titles.pub_id, dbo.titles.price, dbo.titles.advance, dbo.titles.royalty, dbo.titles.ytd_sales, dbo.titles.notes,
                      dbo.titles.pubdate, dbo.authors.au_id, dbo.authors.au_lname, dbo.authors.au_fname
FROM         dbo.titles INNER JOIN
                      dbo.titleauthor ON dbo.titles.title_id = dbo.titleauthor.title_id INNER JOIN
                      dbo.authors ON dbo.titleauthor.au_id = dbo.authors.au_id