What Developers Should Know About Microsoft Visual Studio LightSwitch

The first mention of Microsoft Visual Studio LightSwitch was at the VSLive! event in August of 2010. It's gone through two beta releases with an announced availability for version 1.0 to MSDN subscribers on July 26. LightSwitch is an intriguing product focused on building lightweight applications that access a data source and present results through a variety of different screens. You can build fully functional applications without writing any code, although if you need any customization you'll need to use either Visual Basic or C#.

Business developers are a prime target for LightSwitch. From an application perspective, LightSwitch is aimed at minimally complex applications with straightforward requirements. In many situations the basic need is to grab some data and throw it up on the screen. You might need some simple filter or query capability, but that's just about it. You might call LightSwitch the ad hoc developer's tool, although that's probably not what Microsoft had in mind.

Data is the Key

Accessing multiple kinds of data is, without a doubt, the single common thread amongst most business developers. The data might be stored in a SQL server or even an Access database. Another common task is converting data from one format to another and then storing it in a database. The obvious data sources for a Microsoft shop are SQL Server and Microsoft Access. Other possibilities include SharePoint, SQL Azure and a Windows Communication Foundation (WCF) Rich Internet Application (RIA) Service.

That last one (WCF RIA) is essentially the glue between the presentation tier and data access layer. Creating one of these things is way beyond casual programmer knowledge and would be a potential opportunity for enterprising ISVs. It also highlights the fact that you will need some additional tools if the data you wish to access is stored in something other than a Microsoft product.

Presentation Layer Magic

Creating quick-and-dirty applications is another stated goal of LightSwitch. Visual Basic has filled this role for many years but doesn't really meet the needs of the casual developer. The biggest issue for creating "custom" business applications is almost always how the information is presented to the user. While Visual Basic does make it possible to build simple applications, it does require a certain amount of coding using the language to add the necessary functionality.

LightSwitch takes care of many of the rudimentary tasks for which you have traditionally had to write code, such as querying a database and filling a grid with the results. It provides a nice visual designer to create your forms and reports. LightSwitch also adds a number of new capabilities for data validation, such as recognizing an e-mail or telephone number field and validating it for you. Be aware that LightSwitch refers to unique data input or output forms as screens.

Opportunities

Independent Software Vendors (ISVs) should take a hard look at LightSwitch from the perspective of potential add-on features. LightSwitch has basic database connectivity capabilities out of the box but doesn't even begin to address all of the data sources businesses need to service. It's also somewhat limited in terms of the customized screen components although the usual vendors here have already announced support.

The good news for programmers already familiar with Visual Basic or C# is you don't have to learn anything new. In fact, you can take your VB or C# skills and put them to work right away with LightSwitch. If you want to get started now, you'll find an Extensions Cookbook and sample project available on the MSDN site.



Related Articles

Comments

  • There are no comments yet. Be the first to comment!

Leave a Comment
  • Your email address will not be published. All fields are required.

Top White Papers and Webcasts

  • Live Event Date: October 29, 2014 @ 11:00 a.m. ET / 8:00 a.m. PT Are you interested in building a cognitive application using the power of IBM Watson? Need a platform that provides speed and ease for rapidly deploying this application? Join Chris Madison, Watson Solution Architect, as he walks through the process of building a Watson powered application on IBM Bluemix. Chris will talk about the new Watson Services just released on IBM bluemix, but more importantly he will do a step by step cognitive …

  • Live Event Date: October 29, 2014 @ 1:00 p.m. ET / 10:00 a.m. PT It's well understood how critical version control is for code. However, its importance to DevOps isn't always recognized. The 2014 DevOps Survey of Practice shows that one of the key predictors of DevOps success is putting all production environment artifacts into version control. In this eSeminar, Gene Kim will discuss these survey findings and will share woeful tales of artifact management gone wrong! Gene will also share examples of how …

Most Popular Programming Stories

More for Developers

Latest Developer Headlines

RSS Feeds