Connecting to External Datasource in Lightswitch 2011 RRS feed

  • Question

  • I am trying to connect a new Lightswitch 2011 project to an external SQLExpress datasource, and at the end of the process, Lightswitch is telling me that there are no tables or views in the instance, even though there are.  I can browse the tables and see the data using SQL Server Object Explorer in Lightswitch, so I know the tables are there.  Any ideas would be appreciated. 
    Saturday, February 18, 2012 8:37 AM


  • Hi

    Tables and views from external data source (in your case SQL Server Express) must have primary keys.

    Hope this help

    Spaso Lazarevic

    Saturday, February 18, 2012 8:41 AM