[AccessD] LightSwitch - first impressions

What confuses me is that I cannot see the database with SSMS.  If it is on my machine, where do I go 
to see it in SMSS?  The server should exist in the list of servers I can attach to, and once 
attached, my database should be in the db list.

John W. Colby
www.ColbyConsulting.com

On 9/12/2010 4:39 AM, Gustav Brock wrote:
> Hi John
>
> Well, as one remarks here:
> http://ayende.com/Blog/archive/2010/08/25/analyzing-lightswitch-data-access-behavior.aspx
>
> what is "slow" and what is "acceptable"? Besides, this is a beta and as you can read from the comment from Eric Erhardt of the LightSwitch Team they are working on it.
>
> Did you enjoy the "LightSwitch Guided Tour" here:
> http://msdn.microsoft.com/en-us/library/ff852838.aspx
>
> It covers publishing too.
>
> Here is what I've located about the default data storage:
> http://www.dougseven.com/blog/2010/08/data-storage-in-visual-studio-lightswitch.html
>
> Seems to be a local mdf run by your local SQL Server Express:
> ..\Projects\YourApplication\YourApplication\Bin\Data\ApplicationDatabase.mdf
>
> Though I haven't played with this, as for any "custom" code outside the LS scope, I guess you create that the normal way in VS and right-click your LS solution and select Add Item ...
>
> /gustav
>
>
>>>> jwcolby at colbyconsulting.com 12-09-2010 04:16>>>
> 1) Slow!
>
> I am doing development in VS2008 / C#.  Compiles on my dual core laptop are net speedy, but much
> faster than this.  Compiles on my quad core server are MUCH faster, but I don't have LightSwitch
> installed there yet..
>
> I have not installed and used VS 2010 on my laptop yet so I don't really have an apples to apples
> comparison, but it (LightSwitch) is slow compiling, and slow loading the initial screen.  Very slow!
>    "Hope this ain't the reality" slow.
>
> 2) Ugly
>
> The default is definitely not going to win any design awards.  But it does work.
>
> 3) Easy so far
>
> I defined about 8 tables so far, and two forms for data entry of "type" lists.  To build a data
> entry form I just clicked the button and selected the table.  Form done, and in the menu.
>
> Now these are just single field list type forms.  Nothing too difficult.  I have to build out the
> forms to populate these list tables so that I can move on to the next level, a form that uses combos
> to select items from these lists for FK fields in that table.  That is where the rubber meets the road.
>
> We'll see.
>
> Questions:
>
> 1) Where is the data?  AFAICT it uses SQL Server Express, but there is no new instance of SQl Server
> Express in my SSMS and the one that is there does not show a new database for this project.  So
> where is it putting the data.  Please tell me it isn't doing something stupid like storing to XML.
>
> 2) How do I publish this thing.
>
> 3) How do you add classes, forms etc.  There is nothing in the right click menu like there is in VS.
>    This is obviously a shell over VS.  Hmmm...
>
> Fun so far!
>