Views and Stored Procedures in lightswitch v2

Question

1º Until the final version will have the stored procedures run directly?
we have several complex routines that are performed through stored procedures

2º We will be able to create views without the lightswitch create primary keys automatically?

reports are developed through complex views. lightswitch hurts as we have repeated data on primary keys. because it creates them automatically. could have an option to create a primary key only in the application without compromising the outcome of view

Answer 1

Please someone help me? I need a tutorial in VB. Net that shows how to create a WCF RIA Service to execute the stored procedures in the database. so I can consume your data in an lightswitch application

Answer 2

A quick search using your favorite search engine will return plenty of tutorials on how to do this (even ones specifically for LightSwitch): http://www.bing.com/search?q=wcf+ria+services+stored+procedure

---

Justin Anderson, LightSwitch Development Team

Answer 3

several of these links I've looked, but none is specific of the lightswitch + stored procedure + Vb. net. C # has in droves

Answer 4

Eric posted a blog on how to do this just a few days ago: http://blogs.msdn.com/b/eric_erhardt/archive/2012/04/17/executing-a-simple-stored-procedure-in-lightswitch.aspx.

---

Justin Anderson, LightSwitch Development Team

Answer 5

Hi Justin,

thank you very much