Publish Your Database as Silverlight in 15 Minutes

• Download Silverlight application - 804 KB
• Download complete server source and binaries - 4.49 MB

Introduction

The purpose of this article is to introduce you to a tool that will jump start your Silverlight development by converting any database schema you have into a Silverlight application. You can quickly check the live demo here: http://sphinx4.webhop.net/Silver, to see if this article is worth reading.

The tool is free, and available for download from http://www.z-software.com.

The tool will not only generate the code, but will also compile it so when you download your project it is ready to be used, and that’s where we will start our journey here.

The tool works by you submitting the database schema to the Z-Software server, and after a few minutes, you download a completed project which includes the SOAP service, the WCF service, and several clients. The download will also include the compiled binaries for the two services needed to connect the Silverlight application to the database server.

The tool you download from Z-Software includes a utility to generate the Silverlight code we are about to discuss here.

Using the code

1. Unzip the contents into a folder. We will refer to this folder as ZProjectFolder from now on.
2. Navigate to ZProjectFolder\Bin and double-click on WebAppMakerServiceConfig.exe.



Service Configurations Utility
3. Enter the correct parameters, and click OK.
4. Navigate to ZProjectFolder\dotNET\Service\<Your-Project>Site and double click ZProjectFolder.



WCF Service Site Configuration Utility
5. Enter the site name and press OK.
6. You should now have a web site called http://localhost/ZSampleService hosting the WCF service, and you can test it by typing http://localhost/ZSampleService/service.svc in a web browser.
7. Start Visual Studio 2008 (SP1 is required).
8. Select New Project from the File menu.



New Silverlight Project
9. Enter the project name and press OK.



Project options
10. Press OK to create the project skeleton.
11. Right-click on the project node and select Add Service Reference...



Add Service Reference
12. The following dialog will appear:



Add Service Reference dialog
13. Type the URL that points to the WCF service and press Go.
14. The service name should appear in the Services list box on the left.
15. Type the name of the service reference, and press OK.
16. Start the Z-Silverlight Gold utility, and select the database that was used to create the WCF service from the drop-down list.



Z-Silverlight Gold
17. Select the desired layout, and "Click to configure".



Configure table columns
18. Repeat the process for other tables needed for the layout.
19. The Relations button will be enabled.



The Relations button enabled
20. Click the Relations button and configure the (one to many) relations.



One to Many relations
21. Press OK and then press the Parameters button.



Code options
22. Make sure you enter the same namespace you have in your C# project and press OK.
23. The XAML and C# tabs will appear.



Generated XAML and C# code
24. Copy the XAML code and replace the entire Page.XAML code.
25. Drag a Grid and GridSplitter from the Visual Studio Toolbox inside the first <Grid> tag.



26. Drag the Grid and GridSplitter to Add Namespace Reference to XAML Code.
27. Make sure that the basics and data namespaces are added without messing up the XAML page.



XAML rendered OK
28. Right-click on the project and select Add Class...

    

    Add Class
29. Enter class name and press OK.



New Class dialog
30. Copy the generated C# from the Z-Silverlight Gold tool, and replace the entire class with the generated code.
31. Add a call to zInit(); in the main Page.xaml.cs code.



Call zInit();
32. Make sure you have the clientaccesspolicy.xml file in the root folder of your website. If you don't have one, download one from here: http://z-software.com/download/clientaccesspolicy.zip.
33. Compile and run the project.

The browser should display the following:



Published database

Points of interest

Make sure that when you drag the Grid or GridSplitter to the XAML code, the reference to the basics and data namespaces are added correctly.