In my last post we discussed about the concepts of WCF Ria services , this post is continuation of my earlier post.Here we will create a Silverlight 4 based application with WCF RIA services and Entity Framework.Before going through the article make sure you have downloaded the latest SDKs from Microsoft as mention in my last post.
Well we will develop a simple database centric user management system where the admistrator is going to view and edit user detail.For this app we will use remote sqlserver with following tables.
Create the Project
Generate Data Model through EF at Server Project
- Add Ado.Net Entity model to server side Project.
- Here i am using remote sql server from shared hosting , so select connection and proceed.
- More detailed description of adding EF can be found from this blog post.
Add Domain Service to Server Project
- Add a new Item to server side project name "UM_Server_DomainService.cs".Before adding make sure that you have compiled the project.
- This domain service class will expose the data entities and operations of server side project to the client side project
This will add up 2 classes as shown in figure besides.The
- Compile the project , next we will move on the client side project for data binding.
Load controls, using the Data Context at Client side project (Data Binding Through Code)
- If you check the hidden folder "Generated_Code" you will find auto generated DataContext code for the client.
- From DomainClient we can communicate to the domain service at server.From client side we can perform 3 fundamental kind of operations.such as Query ,Invoke and Submit .(Details regarding it ,is out of scope of this post ,still you can Refer Here)
- So to bind the data Go to Home Page and add a Drag and Drop a combo box.
- Next steps will be -:
Creating a Query Based Operation ,
Assigning Item data source to the control
- private void Page_Loaded(object sender, System.Windows.RoutedEventArgs e)
- UserManagementSystem.Web.UM_Server_DomainContext context =
- new UserManagementSystem.Web.UM_Server_DomainContext();
- LoadOperation<IT_USER> usersQueryOperation = context.Load(context.GetIT_USERQuery());
- cmbUsers.ItemsSource = usersQueryOperation.Entities;
- cmbUsers.DisplayMemberPath = "UserName";
So the code as above will fetch the data and load the users.
Alternatively we can also use the Drag and Drop feature of VS 2010 to create binding .Simply go to Home page and open the Data Source Navigation pane .
That's it , is not it cool.For my goodness the whole lots of work suddenly looks so simple, hats off to Microsoft .
Your comments are welcome and more details i will try to post in future.