You are here:   Forum
Register   |  Login

Forum Notice

This Forum is ARCHIVE only
For LightSwitch questions,
please use the official forums at:


How-to: get the "Powered by Windows Azure" logo for your LightSwitch applications
Last Post 27 May 2011 12:44 PM by admin. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Michael WashingtonUser is Offline
Send Private Message

27 May 2011 12:44 PM
    A great new article by Alessandro Del Sole has just been published:

    Some time ago Microsoft launched the new Microsoft Platform Ready portal, where you can certify your applications based on a number of recent technologies from Microsoft, including Windows Azure.

    As you know, LightSwitch applications can be easily deployed to Windows Azure and in this scenario they use SQL Azure databases. The MPR program enables certifying applications relying on both technologies, so you can certify your LightSwitch applications running on the Cloud....
    Michael Washington
    You are not authorized to post a reply.

    Latest Microsoft Visual Studio LightSwitch Forum Threads That Have Answers

    LightSwitch Connection String
    8/31/2014 1:52 PM
    Hi all experts, I have a Lightswitch application with an Internal Database, I now need to publish the application on this pc and all other pcs on my network so that all can connection to the same database which designed internally. I have no idea about SQL connection strings... and I knew that my application when published it will generate the database for me, I just need all to connect to the same database on one selected pc on the network using the connection string "Data source=""; Initial ...." format. Thanks in advance Ehab, Egy.

    I'm rendering a custom control that will display it's own heading in a Browse Screen so I don't want anything to appear above it. What is the recommended way of meeting this requirement? Z A R D O Z

    Hi, Creating a foreign key in SSMS and updating the datasource in LS pulls in the relationship but hides the foreign key column? From what I think I am getting from reading forums is , it seems to come down to : 1 - Creating a foreign key on SSMS and pulling it in to LS will hide the foreign key column. BUT cascading delete will work. 2 - Creating a foreign key (relationship) in LS will show the associated column. BUT cascading has to be done in the LS code programmatically. I need the SSMS cascading AND to see all table fields for every table in LS. Is this not possible? If the foreign key column is even named something else, where and how do i get to it, and keep the cascade? thanks for your time. david

    I have an oracle table with an ID as PK. And the version I use for oracle doesn't have auto generated columns as in SQL Id is generated via a trigger.  I have attached this table to Lightswitch successfully , and it recognizes my ID as Primary Key.So far so good. However when I generate an Add Edit Screen for this table, despite of ID being primary key, the form asks it explicitly. If I do the same setup for sql server, this field is not generated for screen. What could be wrong ?

    My query returns all results no matter what I write in the PreProcess query. I tried using the query designer filter options and it works, however the functionality I need can only be provided in the PreProcess query method. Here is the setup I have This goes in the HTMLClient screen custom control's render method //Get the last contract myapp.activeDataWorkspace.ApplicationData.LastContractTest(empId) .expand("Craft") .execute() .then(function (result) { var lc = result.results[0]; ... }); This goes in the application data service class And again even if I write a case that is guaranteed to return 0 results, it just does not work. partial void LastContractTest_PreprocessQuery(int? pEmpId, ref IQueryable<Contract> query) { query.Where(c => c.Employee.Id == pEmpId).OrderByDescending(c => c.ContractStartDate).FirstOrDefault(); }  can confirm through the debug log that the executing


    Microsoft Visual Studio is a registered trademark of Microsoft Corporation / LightSwitch is a registered trademark of Microsoft Corporation