Performing CRUD on Relational Data (Multiple table) using RIA in SL4

Introduction

Lots of article demos are available for RIA services but most of them are based on one table without any relational constraint. However, most of the real-time application revolves around data from multiple table and CRUD operations against them.Let’s check one of the queries I received from a reader.

“My issue is. like i have sales Invoice On save button I want to Update Sales master detail table which i can do from ria & after saving i want to update inventory table too . Is there any option i can call update inventory table using this entity.”

Basically the above query seems to be involve RIA service operation with multiple table .Well this post I am going to discuss about Relational/Hierarchical data and CRUD operation against them using RIA.So its time to add some more functionality to the SOI application .

Converting XML data to CLR object using XmlSerializer

My last Post (Consuming Webservice from Silverlight) was all about accessing a web service/api from Silverlight , there i described how to consume an external api ,with a sample from GeoName web services .As i had concluded there ,this post is the continuation of previous .Here i am going to demonstrate How to convert the result output , which is in XML, to CLR object and of course using it as datasource in SL app.

Source Code and Links

GeoSearch Live Link – : GeoSearch

Download SourceCode -: GeoSearch

Consuming External WebService from Silverlight Application

While exploring Map api integration with SOI application, i felt that a separate post on consuming external web services from SL application worth a write.As we know services can be SOAP based (WCF bases)or can be REST (Simple HTTP ) based on the implementation technology.As you goggle you will find a lots of services from different providers , here (webservice directory) .May be some are useful saving lots of time some may look fancy.

Silverlight can access some services directly for e.g HTTP/REST type and some using proxy for SOAP .Well before  describing the process lets have a look at web service in Silverlight.Services hosted by various host comes with various security policies .For e.g yahoo allows access to the services to authenticated request only and authentication can be achieved using OpenID,Oauth and Hybrid (Yahoo API Auth.) , similarly Google services .These external service administrator  creates policy files to restrict the request from other domain with out proper authentication.

Data Binding in Silverlight with RIA and Entity Framework – Part 3 (Validating Input Data)

Validation is a integral part of software development.In Silverlight validation approach has been changed or you can say evolved from version 2.So this post will highlight the options available for validation with continuation of StatesOfIndia application

Article Series

• Data Binding in Silverlight with RIA and Entity Framework – Part 1 (Displaying Data)
• Data Binding in Silverlight with RIA and Entity Framework – Part 2 (Editing / Updating Data)
• Data Binding in Silverlight with RIA and Entity Framework – Part 3 (Validating Input Data)

Source Code and Demo Link

Hosted Application : Live Sample

Source Code : StatesOfIndia_WithValidation