OData or Entity Framework for windows forms with sql azure RRS feed

  • Question

  • Hi,

    now I am using MS Lightswitch to build my applications, but I would like to build an application with winforms to create more complex screens etc.

    I would like to use sql azure to store my data, because I do not want to have a server in my local network, because I do not want to administrate the hardware. But I do not know what the best way is to load the data from the sql server.

    An easy way would be the odata feed, because lightswitch creates it for me automaticly. With Odata I also have the security integrated and I can use the existing users and profiles. I also can use the server side code I already wrote in lightswitch.

    But I do not know if the performance of odata is good enough for a more complex screen in a windows forms application?

    I already tested the performance of entity framework vs odata and it seems that loading data with entity framework is a lot faster. But I do not have many experience with entity framework. Is it possible to use aps.net profiles and users created with lightswitch? what is with server side code and conncurency issues with entity framework?

    Or maybe I should use something else with sql azure?



    Saturday, December 1, 2012 7:50 PM


  • First of, you I think you can create any screen (complex or not) using Lightswitch. So you might want to dig into that a little deeper.

    If you want though you can use winforms to manipulate your odata by using WCF.

    You might want to checkout this project: http://odata.codeplex.com/

    • Proposed as answer by Chester Hong Tuesday, December 18, 2012 10:08 PM
    • Marked as answer by Chester Hong Monday, December 24, 2012 10:07 AM
    Monday, December 3, 2012 10:57 AM