[AccessD] LightSwitch - first impressions

Gustav Brock gustav at cactus.dk
Sun Sep 12 03:39:05 CDT 2010


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!

-- 
John W. Colby
www.ColbyConsulting.com 





More information about the AccessD mailing list