About a month or so ago I showed on this blog how to connect to MySQL using Telerik's new LINQ implementation.  Today I will show you how to take it one step further and build an OData service automatically using the Telerik Data Services Wizard. Just for fun, we will also automatically add a full CRUD Silverlight application that consumes the OData service. We’ll do this all in 30 seconds!

To get started, you have to download MySQL 5.x and the MySQL Workbench and also, as my colleague Alexander Filipov at Telerik reminded me, make sure you install the MySQL .NET Connector, which is available here.  I like to use Northwind, ok it gives me the warm and fuzzies, so I ran a script to produce Northwind on my MySQL server. There are many ways you can get Northwind on your MySQL database, here is a helpful blog to get your started.

Let’s get started! First we will just build our model with Telerik’s new LINQ implementation. I will repeat the steps I showed off in this blog post. Start up the Domain Model wizard by right clicking on the project in Visual Studio (I have a Web project) and select Add|New Item and choose “Telerik OpenAccess Domain Model” from the new item list.

image

When the wizard comes up, choose MySQL as your back end and enter in the name of your saved MySQL connection.

image

If you don’t have a saved MySQL connection set up in Visual Studio, click on “New Connection” and enter in the proper connection information. *Note, this is where you need to have the MySQL .NET connector installed.

image

After you set your connection to the MySQL database server, you have to choose which tables to include in your model. Just for fun, I will choose all of them.

image

Give your model a name, like “NorthwindEntities” and click finish. Now you have a new Telerik Domain Model named NorthwindModel.rlinq.

image

Now we are going to use the Telerik Data Services Wizard to build our OData service endpoint via WCF Data Services (Astoria) and also automatically build a Silverlight client that will consume this service. The service has full CRUD capability and the Silverlight application is pretty basic, but wires up the application to the service and gives you the hooks to extend on.

We are going to use the “express” version of the Data Service Wizard and build the service and Silverlight client in less than 30 seconds! (Note: I showed how to do this using SQL Server here.) To do this, right click on the NorthwindModel.RLINQ file in the solution explorer and choose from the context menu: Data Services Wizard|Data Services for .NET 3.51 Sp1 Version 2 (Astoria)|Add to Project with new SL Client|WebApplication13.

(Note depending on which version of Visual Studio and what versions of WCF Data Services you have installed on your machine, the choices may vary.)

image

You will have to click OK to the standard “Add Silverlight Project” screen that Visual Studio gives you, but the wizard does all the work for you. When you run the application, the results are an OData service and a simple Silverlight CRUD application:

image

Enjoy!


About the Author

Steve Forte

 sits on the board of several start-ups including Triton Works. Stephen is also the Microsoft Regional Director for the NY Metro region and speaks regularly at industry conferences around the world. He has written several books on application and database development including Programming SQL Server 2008 (MS Press).

Comments

Comments are disabled in preview mode.