Gustav Brock
gustav at cactus.dk
Sun Sep 12 13:14:23 CDT 2010
Hi John I think the mdf gets attached on-the-fly and detached when the client app closes. Just guessing ... But you can easily attach to an "external" database. The tutorial uses good old Northwind installed on your local SQL Express instance. /gustav >>> jwcolby at colbyconsulting.com 12-09-2010 19:34 >>> 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