[dba-VB] Rapid Application Development: LightSwitch 2011

 > 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.

Can you say "virtual machine"?  ;)

John W. Colby
www.ColbyConsulting.com

On 9/19/2011 8:00 AM, Gustav Brock wrote:
> 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/de2e7ee5-fc82-4614-9245-4f4a9ae7185f
>
> I'm giving up now for about two-three weeks my MS Lightswitch fighting/exercizing...
>
> Thank you.
>
> --
> Shamil
>
> -----Original Message-----
> From: dba-vb-bounces at databaseadvisors.com
> [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Shamil
> Salakhetdinov
> Sent: 19 ???????? 2011 ?. 13:51
> To: 'Discussion concerning Visual Basic and related programming issues.'
> Subject: Re: [dba-VB] Rapid Application Development: LightSwitch
> 2011((nobeta)
>
>
> Hi Gustav at all --
>
> I have got MS LightSwitch 2011 installed, and I have tried to create
> LightSwitch project using NorthwindNet database from our
> northwind.codeplex.com project - it didn't work resulting in a set of
> (cryptic for me) error messages:
>
> Error 5 Application definition contains critical errors. Common Error 6
> Application definition contains critical errors. Client Error 7 Application
> definition contains critical errors. ClientGenerated Error 8 Application
> definition contains critical errors. Server Error 9 Application definition
> contains critical errors. ServerGenerated
>
> Error 1 The EntitySet property of the AssociationSetEnd 'OrderDetail' in the
> AssociationSet 'OrderDetails' in the Domain Source 'NorthwindNETData' cannot
> be resolved:
> The item referenced by Id 'OrderDetails' does not match the type of the
> property 'Microsoft.LightSwitch.EditableModel.IEditableEntitySetDefinition'.
>
> E:\ZZZ\LS_Test_Application\LS_Test_Application\Data\ApplicationDefinition.ls
> ml 892 7
>
> Error 2 The EntitySet property of the AssociationSetEnd 'OrderDetail' in the
> AssociationSet 'ProductOrders' in the Domain Source 'NorthwindNETData'
> cannot be resolved:
>
> The item referenced by Id 'OrderDetails' does not match the type of the
> property 'Microsoft.LightSwitch.EditableModel.IEditableEntitySetDefinition'.
>
> E:\ZZZ\LS_Test_Application\LS_Test_Application\Data\ApplicationDefinition.ls
> ml 900 7
> Error 3 The EntitySet property of the EntitySetMapping in the DataService
> 'NorthwindNETDataDataService' cannot be resolved:
> The item referenced by Id 'OrderDetails' does not match the type of the
> property 'Microsoft.LightSwitch.EditableModel.IEditableEntitySetDefinition'.
>
> E:\ZZZ\LS_Test_Application\LS_Test_Application\Data\ApplicationDefinition.ls
> ml 1837 5
>
> Error 4 Unable to copy file
> "E:\ZZZ\LS_Test_Application\LS_Test_Application\ServerGenerated\obj\Debug\Ap
> plication.ServerGenerated.dll" to
> "Bin\Debug\bin\Application.ServerGenerated.dll".
> Could not find file
> 'E:\ZZZ\LS_Test_Application\LS_Test_Application\ServerGenerated\obj\Debug\Ap
> plication.ServerGenerated.dll'.
> C:\Program
> Files\MSBuild\Microsoft\VisualStudio\LightSwitch\v1.0\Microsoft.LightSwitch.
> targets 149 10 LS_Test_Application
>
> When I have got removed one non-unique indexes from ProductDetails table
> supposing that it was the cause of the above errors I have got VS going
> down/restarting and presenting me a message:
>
> +++
> There are critical errors in the application definition metadata.
> These errors must be fixed before the project can be loaded in the designer.
> Check the errors in the errors window, and fix them in the text editor.
> When you finish it, please use the "Reload" button to reload it into the
> designer.
> ----
>
> Sorry for my English but what they mean in the last sensence by "finish it"?
> - I got it as to finish ASAP my first Lightswitch "fighting session", and so
> I finsihed it :)
>
> If anybody here have any idea how to fix the above issue that would be very
> helpful here.
>
> Thank you.
>
> --
> Shamil
>
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
>
>