Attaching to SQL Views

In Visual Studio 2013 Update 2  (as well as Office Developer Tools for Visual Studio 2013 – March 2014 Update) some enhancements are available in the area of attaching to SQL Views.  These enhancements were made based on the feedback we received from the community.  With this update, you can now model the primary key for attached SQL… Read more

Saving to Multiple Data Sources in the HTML Client (Stephen Provine)

One of the great features of Visual Studio LightSwitch and Cloud Business Apps (CBA) is its ability to perform what we call data mashup. You can connect to multiple data sources, configure virtual relationships between entities in different data sources, and then visualize all of the data at the same time. One interesting data mashup… Read more

Improvements in Working with Large Data Sources

Business apps typically need to connect to large data sources and schemas. That’s why in the Office Developer Tools for Visual Studio 2013 – March 2014 Update we’ve done a lot of work to improve the experience for working with large data models in both LightSwitch projects and Cloud Business Apps. In addition to improving… Read more

How to Build a Cloud Business App with SAP Data

For the Office Developer Tools – March 2014 Update, we’ve added several new features that enhance the experience for connecting to enterprise data sources. Whether you are building a LightSwitch app or a Cloud Business App, you can now create a line of business app that: Connects to SAP as a first-class data source. Allows… Read more

Tips and Tricks for Lync Integration (Nicole Haugen, Ravi Eda)

The Person Viewer and Person Picker controls were introduced in Visual Studio 2013 to support the Person data type which makes it easy to manage people-related data in your application. These controls depend on various components such as SharePoint, Lync, ActiveX and browser settings in order for them to display properly. Knowing a few simple… Read more

Automatic Row Tracking with Visual Studio 2013 (Amr Altahlawi)

As databases are used by many applications and many users within those applications, it’s a common practice to log when data was created or last modified. In addition to knowing when the data was changed, knowing who changed the data is a common requirement in business applications. LightSwitch in Visual Studio 2013 introduced a new… Read more

Using the Person Business Type (Karol Zadora-Przylecki, Ravi Eda)

The Person business type is a new LightSwitch feature introduced in Visual Studio 2013. Its goal is to make it easy to add and manage people-related data in your application. In this post we will show you how to use the Person type and what it can do for you. Getting Started Suppose you are… Read more

What Time Is It? Global Time (Steve Lasker)

You’re building apps that are hosted in the cloud. Your users can be anywhere across the globe. When you’re viewing a customer service call log, and you see a customer called at 4:30pm and was really upset their service was still down, how do you know how long ago they called? Was the time relevant… Read more

Intrinsic Database Management with Database Projects (Chris Rummel)

One of the new LightSwitch features in the Visual Studio 2013 Preview is enabling the use of SQL Server Data Tools projects (here’s the MSDN SSDT documentation and their blog).  When you add a database project to your LightSwitch project, the contents of the database project will be incorporated into the intrinsic database that LightSwitch… Read more

Dashboard Reports with LightSwitch, WebAPI and ServerApplicationContext– Part Deux (Steve Lasker)

Overview With a little homage to Hot Shots Part Deux we’ll drill in a bit deeper utilizing the ServerApplicationContext for creating Dashboard reports. Part 1 is here: Create Dashboard Reports with LightSwitch, WebAPI and ServerApplicationContext LightSwitch Productivity/Extendability disclaimer: As with Part 1, this isn’t the normal point & click RAD productivity you’ve likely become used… Read more