How to handle complex (no CRUD) SP with RIA Services?
I would like to use .NET RIA Services to access my database from Silverlight but I have one problem – all post I have read are abut CRUD access to tables – using direct access to tables or SP and with support of Entity Framework or LinqToSql. Everything is nice but 90% of my solutions use SP to get a view of data with some joins (not one table like in most of the samples). When I try to use this kind of SP with LinqToSql this SP was not visible on client (Silverlight side) and no business object is generated – I only see tables mapped from database. I’m not good in Entity Framework but I can’t figure out how to use sp that return data from many tables – I have couple of problems (for instance all primary keys from source tables must be in entity, there is some concurrency with Entities when I try to use same source table for couple Entities and so on). My needs are very simple – I would like to generate SP proxy for SP that returns data from many tables and auto generate business object returned from this SP (precisely list of this objects) and as far as RIA Services are concern I would like to handle it form Silverlight with RIA Services – it is possible?
