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?
Thanks.
Markus
