Need Help of RIA Services

Question

I need to display  child table value  in grid of the parent table. In  Silverligth 4  Application ans MS SQL 2008\R2 Server .and RIA Services + EF.

For Example :  Table - TypesOfStreet (FK,PK IdTypeOfStreet [ uniqueidentifier] , TypeOfStreet  [nvarchar(50)] , ShortName [nvarchar[10] )

and Table - Streets (PK IdStreet [uniqueidentifier ], StreetName [nvarchar (50) ], IdTypeOfStreet [uniqueidentiffier] , DisplayName ([nvarchar (100))

DisplayName need to Display    the retrieved value ShortName  from TypesOfStreet (by Id TypeOfStreet )   plus  the Value StreetName  from  the table - Streets .Also I need to display in grid a value of retrieveing TypeOfStreet of Table Types Of Street . How it will better  to Do?   To Customize it in EF creating a new Complex Type  and  imoprt store proced  from MS SQL and then generate by Domain Service (RIA Services )

Or what?

  Actually this value is that User  enter on form.  How me to better to do ?   On my solution I have like this things in Example with like this entities 45 pcs.

Need I create for each  Such  entitity  a seperate service and then use a service   including all those services ?

Answer 1

I would create a DTO. Then you can have whatever fields you want. What you do is create the object and the write a select new query:

 

from street in entities.street
from tos in entities.TypesOfStreet
where street.IdStreet = passedInID

select new StreetDTO
{

Title = tos.ShortName
...

}

RIA will see you have a query for StreetDTO and will project it into the client. If you want to save with this object then just break it up when you pass it back to the server and create the two objects. 

Answer 2

 

"Dalex83" wrote in message news:3ca7227f-4ec3-45af-bbc3-c08095d90ebc...

I need to display  child table value  in grid of the parent table. In  Silverligth 4  Application ans MS SQL 2008\R2 Server .and RIA Services + EF.

For Example :  Table - TypesOfStreet (FK,PK IdTypeOfStreet [ uniqueidentifier] , TypeOfStreet  [nvarchar(50)] , ShortName [nvarchar[10] )

and Table - Streets (PK IdStreet [uniqueidentifier ], StreetName [nvarchar (50) ], IdTypeOfStreet [uniqueidentiffier] , DisplayName ([nvarchar (100))

DisplayName need to Display    the retrieved value ShortName  from TypesOfStreet (by Id TypeOfStreet )   plus  the Value StreetName  from  the table - Streets ..Also I need to display in grid a value of retrieveing TypeOfStreet of Table Types Of Street . How it will better  to Do?   To Customize it in EF creating a new Complex Type  and  imoprt store proced  from MS SQL and then generate by Domain Service (RIA Services )

Or what?

  Actually this value is that User  enter on form.  How me to better to do ?   On my solution I have like this things in Example with like this entities 45 pcs.

Need I create for each  Such  entitity  a seperate service and then use a service   including all those services ?

 

my response -------------------------------------------------------------------

You can post to this forum and get help.

http://forums.silverlight.net/forums/53.aspx

 

Answer 3

Dto is good staff, but wiil it be better then that CUSTOMIZing EF or RIA Service? Actually will it be better RIA Services + Open DAta?

Answer 4

On 9/18/2010 12:24 AM, Dalex83 wrote:

> Dto is good staff, but wiil it be better then that CUSTOMIZing EF or RIA

> Service? Actually will it be better RIA Services + Open DAta?

 

WCF RIA is designed to work with Linq-2-SQL or ADO.NET Entity Framework

directly and not DTO(s).

 

Here is an example of the technology in action where you bind the entity

or entities in a collection to a control. The middle tier is built for

you regarding WCF and the Model, and the middle tier takes care of the

CRUD operations triggered by a control's functionality, which the middle

tier is customizable by the developer.

 

<http://geekswithblogs.net/ranganh/archive/2009/12/14/using-wcf-ria-services-without-silverlight-in-visual-studio-2010.aspx>

 

I even went to a n-tier architecture using WCF RIA with a UI/BLL/WCF

RIA/DAL solution just playing with it and the model created in the DAL.

In this type of architecture, one can use DTO(s) at the BLL where you

map the entity to a DTO and a DTO to a entity to/from the DAL and with

DTO(s) being used at the UI.

 

Answer 5

Actually  I am looking for something like that but i need mostly to do cashes .

Answer 6

http://www.primaryobjects.com/CMS/Article116.aspx

http://www.silverlightshow.net/items/Building-N-Tier-business-applications-with-WCF-RIA-Services-Part-II.aspx

http://www.silverlightshow.net/items/Building-N-Tier-business-applications-with-WCF-RIA-Services-Part-I.aspx

The Usefuls URLS .