Shalex wrote:We will investigate the possibility of creating Lightswitch sample.
It would be really great if some basic example is available.
I have done some more tests, but have some questions.
Currently, I created an before-insert trigger on my oracle DB-table, which fetches a new ID-value from the sequence.
When i now use the standard lightswitch "create new" screen, and pus the save button, my record is indeed created in DB and has the sequence value as ID.
But, now the problem
After creating the record in LS --> de details windows is shown, but this is empty in my case.
Further investigation, shows that Lightswitch never "knows" the value of that ID --> so it can nog get the details back from DB to show them.
This can be verified in the ...._Inserted(... entity) method, which is executed after the entity is created in DB. There I see that my ID value is still 0 (and does nos have the value from the sequence fetched in the trigger)
Is there any workaround or way, to overcome this problem ? so that in some way I know what the value of my ID is when record is created.
As far i know, there is also no (easy) way to fetch first manually the sequence value, because executing simple SQL-statements is not possible....