locked
The best way to connect silverlight 4 with SQL in Blend 4 without WCF RIA RRS feed

  • Question

  • Hi, all.. :)

    I have Silverlight 4 application, designed in Ms. Expression Blend 4. I need to use SQL database, since it needs many queries to complete this application. How to do this? Because some suggest, that i have to use WCF RIA Services, But I cant, because i have only VS 2008, and i dont use it. I just fully use Ms. Blend 4. Do you have any idea?

    Thanks for your help.

    Regards, Alicia. 

    Tuesday, January 18, 2011 8:55 AM

Answers

  • Silverlight can't connect directly to an SQL database. You need some sort of web service in front of the database. This can take many forms, WCF service, REST web service, etc...

     

    This page seems to give a decent overview of one possible technique:

    http://www.codeproject.com/KB/silverlight/CntDbSlght.aspx

    • Marked as answer by Alicia_91 Tuesday, January 18, 2011 2:51 PM
    Tuesday, January 18, 2011 1:53 PM
    Moderator

All replies

  • Silverlight can't connect directly to an SQL database. You need some sort of web service in front of the database. This can take many forms, WCF service, REST web service, etc...

     

    This page seems to give a decent overview of one possible technique:

    http://www.codeproject.com/KB/silverlight/CntDbSlght.aspx

    • Marked as answer by Alicia_91 Tuesday, January 18, 2011 2:51 PM
    Tuesday, January 18, 2011 1:53 PM
    Moderator
  • Thanks Chuck, :)

    The tutorial from  http://www.codeproject.com/KB/silverlight/CntDbSlght.aspx  uses WCF as the service. 

    Can i done it in Blend 4 & Visual Studio 2008? 


    Galatians 5:22
    Tuesday, January 18, 2011 2:49 PM
  • The WCF service part should be fine in VS 2008. SL 4 can't be done in VS 2008, but you can always use the VS express 2010 free versions if needed.
    • Edited by Chuck HaysModerator Wednesday, January 19, 2011 5:10 PM Corrected VS Expression -> VS Express
    Tuesday, January 18, 2011 2:55 PM
    Moderator
  • Okay,, so to sum up,, all i need are :

    1. Visual Studio 2008
    2. Microsoft Expression Blend 4
    3. And Silverlight 4

    Is that correct? :) Thanks again.

    regards.

     


    Galatians 5:22
    Wednesday, January 19, 2011 5:58 AM
  • I think that should be sufficient. If you want to edit your SL4 project in Visual Studio you will need VS2010, but the express editions are fine.
    Wednesday, January 19, 2011 5:09 PM
    Moderator