[dba-VB] Rapid Application Development: LightSwitch 2011

Hi Gustav --

The issue was with table name [OrderDetail] and relationship name
OrderDetails collision - with  [OrderDetail] table getting OrderDetails
entities collection name (or something like that) when MS Lightswitch did
got generated EF data model - I have chenaged relationship name to
OrderItems - and voila' - the MS Lightswitch project compiles well now.

I have also got "hacked" the issue described here:

http://social.msdn.microsoft.com/Forums/en-US/lightswitchgeneral/thread/de2e
7ee5-fc82-4614-9245-4f4a9ae7185f

and I have now MS Lightswitch/Northwind tiny sample app with five
search/view/edit forms/secreens running locally under Visual Studio:

http://smsconsulting.spb.ru/test/s1.png
http://smsconsulting.spb.ru/test/s2.png
http://smsconsulting.spb.ru/test/s3.png
http://smsconsulting.spb.ru/test/s4.png
http://smsconsulting.spb.ru/test/s5.png

I will try to write more on that "hacking" in coming days if time will allow
and I will also try to publish this app...

Still don't understand why that MS SQL "__IntrinsicData" MS SQLExpress
instance can't be swicthed-off/"hacked" via MS Lightswitch development
interface/properties - hope it will be possible to do that in the coming MS
Lightswitch updates...

Thank you.

--
Shamil
 
-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: 19 ???????? 2011 ?. 16:00
To: dba-vb at databaseadvisors.com
Subject: Re: [dba-VB] Rapid Application Development: LightSwitch 2011

Hi Shamil

No, I haven't got that far.

My first guess was that the table schemes of Northwind perhaps didn't
correlate 100% with that expected by LightSwitch.

But the link you provided tells that a separate instance of SQL Server
Express 2005/2008 (not any other version) is required to support LS itself
during development to not mix up "development data" with your application
data (user data). 

That I didn't know about, and it may cause trouble around where you use the
development version of SQL Server 2008 for your local work.

/gustav


>>> shamil at smsconsulting.spb.ru 19-09-2011 12:39 >>>
 
Hi All --

To avoid issues with ProductDetails table I have just checked it out from
external datasource while generating new MS Lightswitch project - and I have
got infamous:

http://social.msdn.microsoft.com/Forums/en-US/lightswitchgeneral/thread/de2e
7ee5-fc82-4614-9245-4f4a9ae7185f

I'm giving up now for about two-three weeks my MS Lightswitch
fighting/exercizing...

Thank you.

--
Shamil