LightSwitch Beta 1 projects are not compatible with Beta 2

    General discussion

  • Hello LightSwitch early-adopters,

    Please note that due to the many improvements in Beta 2, projects created in Beta 1 cannot be opened or upgraded. You will need to recreate your projects and copy over any user code that you have added. You can get to the user code files by switching to File View in the Solution Explorer. Please note that some APIs have changed so you may need to update some of your code appropriately. Sorry for the inconvenience. At this point we do not plan to introduce breaking changes post-Beta 2 that will cause you to need to recreate your Beta 2 projects.

    Also please be aware that you need to un-install Beta 1 before installing Beta 2. Please see this post and the Beta 2 readme for important installation notes.

    If you are having trouble porting your user code into Beta 2 please let us know and we can help!

    Senior Program Manager, Visual Studio Community http://msdn.com/lightswitch http://msdn.com/vbasic http://msdn.com/vsto http://www.bethmassi.com

    Tuesday, March 15, 2011 9:17 PM

All replies

  • Please clarify if we must redo our screens.  I understand the answer is yes, correct?

    Tuesday, March 15, 2011 10:47 PM
  • Hi Garth,

    Yes you will need to recreate your project including the screens.


    Senior Program Manager, Visual Studio Community http://msdn.com/lightswitch http://msdn.com/vbasic http://msdn.com/vsto http://www.bethmassi.com
    Tuesday, March 15, 2011 10:49 PM
  • Is there any way to save our tables?  I discovered LS a few months ago and created a project with about 40 tables.  It wasn't until the last few weeks that I saw talk here that B2 might break B1, so I quit working on my project to see what we could port.  Isn't there any way to export the tables so they don't have to be recreated?  That's a *lot* of work to start that from scratch.



    Wednesday, March 16, 2011 2:23 AM
  • Hello Beth, Should I be a subscriber in order to download the Beta2 today? Thanks in advance...
    Wednesday, March 16, 2011 2:35 AM
  • Hi Manuel,

    Beta 2 is only available for MSDN Subscribers today. It will be available to everyone at 10 AM Pacific Daylight Time on Thursday, March 17.

    Hope this helps,

    Steve Hoag Microsoft aka the V-Bee
    Wednesday, March 16, 2011 3:01 AM
  • Steve, thanks for your answer,  one more question? does LightSwitch will include something for reporting based on the SQL queries, for example generate and print a list of products or customers, besides of exporting to excel?  Thanks again...

    Wednesday, March 16, 2011 4:13 AM
  • LightSwitch does not have reporting built-in. If you search the forum on "reporting" or "printing" you will see that several people have already developed solutions, and there will be more reporting solutions available from third-parties soon.


    Steve Hoag Microsoft aka the V-Bee
    Wednesday, March 16, 2011 4:26 AM
  • Hello, same question as skarden.

    Can we reuse our tables and relationships from beta1? Please....

    We have a  lot of "work" in our tables and relationships.



    Wednesday, March 16, 2011 2:40 PM
  • Can we reuse our tables and relationships from beta1? Please....

    I guess you created the tables from within LS. In that case, deploy the solution, and then attach LS Beta2 to external DataSource - the db created from the LS Beta1 app. Then copy over all the custom code.


    Wednesday, March 16, 2011 4:45 PM
  • I was going to suggest that but be aware that will have to maintain the database schema outside of LightSwitch from then on. After you make a change to the schema outside of LightSwitch, you can right-click on the datasource and select "refresh" to update the data model.



    Senior Program Manager, Visual Studio Community http://msdn.com/lightswitch http://msdn.com/vbasic http://msdn.com/vsto http://www.bethmassi.com
    Wednesday, March 16, 2011 5:47 PM
  • Hello,

    are there any disadvantage when we maintain the db schema outside of lightswitch?
    Maybe functions in visual studio gui?


    Wednesday, March 16, 2011 9:19 PM
  • Hi Beth,

    It would have been a wonderful thing to be able to "import" an external database schema INTO LS (as a one-off, non-updatable, non-repeatable operation), not just "attach" to it.

    I was hoping B2 might have provided this option.


    Wednesday, March 16, 2011 10:40 PM
  • I had a feeling this might happen well pays to be a bit of a procrastinator I guess. That answers my question I had today about how to move my tables out of one project to anouther. As I am not ready to deploy and I might as well re-set up the project in Beta two lots of work and all.


    A. Can we still open and work with our beta 1 projects once we install beta two because I would liek to be able to look back at my old screens and data base tables and stuff or do I need to do a bit of alt_PrtSc open paint Ctrl_V so I can remember without writting this all down.

    B. They did fix the issue with large projects lagging right? Because I need to have several large projects source in the same database so I can write relationships, queries and set up XML output only select tables output properties.

    C. I noticed you guys removed the Deploy Video I mean I saved it to my computer already but... We are going to still be able to test the deploy option right? Beth you said more videos not less lol ;-)

    Thursday, March 17, 2011 5:36 PM
  • Hiya Marc,

    I think there are many advantages to managing the db schema using SQL Server Management Studio over the LS Entity Designer.

    The Database Diagrams are worth their weight in gold.

    As LS v1 is not scalable to ERP development, we are splitting up development into small application "modules" based on functionality.  Therefore each module has its own perspective on what data tables are to be included in a modular LS app.

    The LS Entity Designer only shows the detail of one Entity at a time, a data diagram shows all the Entities.

    The LS Entity Designer cannot be displayed at the same time as the Screen Designer.   Having a Data Diagram open in a separate monitor while programming with the Screen Designer and event code files is the fastest way to program LS apps.

    The development speed increase and reduced memory overhead in Beta 2 is awesome.

    Thursday, March 17, 2011 6:11 PM
  • Hi Garth,

    so i can use my database/tables from LS beta1 and will recreate my screens in LS beta 2.
    The existing database is than an external data source for the LS application.


    Thursday, March 17, 2011 7:50 PM
  • @Marc:   Yes. 

    Note that the Refresh of a Data Source in B1 is now called an Update in B2.   Same function, just a different name.

    Thursday, March 17, 2011 8:58 PM
  • By "deploy" the solution, do you mean we should go into LS1 and then "publish" it?


    Friday, March 18, 2011 2:17 AM
  • Annoyingly, the way I had devised to be able to view the screens in my B1 app (albeit in runtime, not design mode) doesn't seem to be working.

    I delpoyed my B1 app to my dev machine, knowing that I had to uninstall B1 before I could install B2, thinking that the deployed app would still run.

    But it doesn't! (I've tried it with TWO apps now)

    Even if I reinstall it from the publish folder!!! Why would this not work, surely the setup has evenrything it needs to set the app up?

    Not happy Jan! (If you don't get the reference, it's from a Aussie TV ad).


    Sunday, March 20, 2011 9:55 PM
  • As no one had answered by question from Friday I installed B2, thinking B1 would still be there like how Visual Express 2008 was still there after I installed VE 2010.  However, that doesn't seem to be the case.  While I expected the screens and code to be gone, I expected the tables themselves would still be there (after all, they are just typical database tables, so why, I thought, would going from 1 version to the other harm the underlying tables).  It seems some of the code is still there, but not the tables,  and B1 is gone.

    Can I uninstall B2, reinstall B1 and somehow save my tables?  Where did the tables go?


    Monday, March 21, 2011 12:02 AM
  • Yes - You will have to publish the application from LS. 

    While you try to publish, you would see a page for SQL DB connections. On the LightSwitch Application Data – SQL Database Connection page of the wizard, verify that the connection strings are valid for the computer where you will deploy the database. You can change the strings to specify a different database server and different user credentials if necessary.

    1. To change the connection strings

      1. Select the connection string that you want to change and click the browse (…) button.

      The Connection Properties dialog box appears

    1. In the Connection Properties dialog box, select the Server name field and enter the name of the database server where you want to publish the application database.

      The database server must be pre-configured to have SQL Server 2005 or a later version, or SQL Server 2005 Express or a later version. It does not have to be located on the same server where you are publishing the application.

    2. In the Log on to the server section, select Use SQL Authentication and enter a valid User name and Password for the server.

    3. In the Select or enter a database name, enter the name of your application, and then click OK.

      This must be the same name that you entered for the Application Name property in the Application Designer

    Please let me know if you have issues publishing.



    Friday, March 25, 2011 10:47 PM
  • Did you try to open the project in B2?

    Uninstalling B2 and then re-installing B1 does not give you a gaurentee to save your tables.

    One thing you could try is to go to the debug folder of your project, copy over the .mdf file present in there to desktop or some other location and try opening that to verify if your tables and relationships are still present.

    Friday, March 25, 2011 11:04 PM
  • I saved my mdf to the desktop and created a new application in B2, but I can't figure out how to connect it as the data source.  Every option fails.



    Sunday, April 03, 2011 2:11 AM
  • if your tables are created in SQL they will remain

    if your tables are still only in the tool, you should deploy them to a server or save the MDF files if any... 

    Monday, April 04, 2011 8:51 AM
  • I have been trying to get a simple project up and running now (on Beta 2) for more hours than I care to mention. I have tried every authentication method possible and I am getting nowhere fast. I cannot connect to the Database - This was after battling the login screen error for a few hours - I have also followed the "workarounds" listed here, none of which work :


    Now I am just getting an arbitary message saying that data cannot be loaded. Many months ago I tested Beta 1 with no problems and was waiting for the project to mature ... seems things have gone backwards? 

    Would appreciate someone knowledgeable with Beta2 to help solve the issues I am having or at least some indication from the team as to wether these issues are being addressed, and if so, when a fix might be expected. 

    Friday, April 15, 2011 3:19 PM