In many LightSwitch applications, you will desire the ability to display aggregated data and percentages. While the article at this link explains a method that will work 100% of the time, with the best performance, it requires the creation of an additional project. The method described here, is easier to use, yet, it has limitations (for example it will not allow you to use GroupBy)....

NOTE: Please see Easy DotNetNuke LightSwitch Deployment, for an easier method to use LightSwitch in a DotNetNuke website

DotNetNuke has long been known as one of the easiest and most powerful web content management frameworks.

Combined with LightSwitch, the easiest way to create data driven applications, you have the ability to create and deploy “Line-Of-Business” applications quickly and easily.

An important thing to note, is that you can use your existing DotNetNuke users and roles with your LightSwitch applications.

This is really important if your already have accounts and roles.

You don’t want to require your users to learn a new username and password, and need to log into, each application.

Deploying your LightSwitch applications in DotNetNuke allows a seamless user experience.

What You Need:

DotNetNuke 5 (using ASP.NET 4.0) LightSwitch Beta 2...

LightSwitch is designed for “forms over data”, entering data into tables, and retrieving that data. Procedural code is required when you need to manipulate data in “batches”. Normally, you want to put all your custom code on the Entity (table) level, but for procedural code, you want to use custom code on the Screen level.

The Inventory Program To demonstrate procedural code in LightSwitch, we will consider a simple inventory management requirement. We want to specify sites and books, and we want to move those books, in batches, between the sites.



...