Data-Centric Silverlight Applications with Visual Studio LightSwitch
BindingNavigator for WPF (Part 1 - Creating)

Visual Studio LightSwitch–Another Level of Abstraction?

Visual Studio LightSwich is a new tool to create data-centric Silverlight applications as I’ve already written about in a previous blog post.

Currently there’s a lot of discussion going on about this tool, in regard to “non-programmers”, “non-thinkers”, “Microsoft doesn’t get it”…

For myself I love writing code, but “the best code is the one you don’t write”.

I’ve written and loved writing Assembler code. I’ve done C when C was discussed as too much “high-level”. Then C++ had too much overhead for many contrary to C, reasoning object-orientation is not needed. Nowadays trusting the garbage collector from .NET has become normal. We write XAML and C# code. Of course there are still scenarios where Assembler and C has its places.

It was really fun to teach a one-week ATL course where after the week major issues to discuss have been templates, dual, dispatch, custom interfaces, different apartment models like STA, MTA, TNA, and the best we could get after a week probably was calling very simple components across the network. Nowadays in a course week it’s possible to create fancy UIs calling services across a network, using complex databases… I wouldn’t want to write this with C or pure assembler code.

Abstraction goes on and on and on.

Visual Studio LightSwitch allows doing fancy UIs calling services across the network, using complex databases… without a single line of code. Probably in reality several lines of code are still required as there’s a C# and a Visual Basic template for LightSwitch inside Visual Studio, but the code lines will be reduced.

Visual Studio LightSwitch is not the first tool to offer such functionality. Several others failed doing so. What’s different now?

Reason other tools failed were e.g. scalability. Some tools could be used in a single-user scenario but failed as soon as multiple users were accessing the same database.

Visual Studio LightSwitch is based on .NET technologies, probably uses stateless services, well-known patterns to reach scalability. Deploying to Windows Azure just by changing configuration values the number of systems answering the client requests can be simple increased. Probably manual code can be written much more efficient in that half of the number of systems could get the same overall performance compared to the code that is generated, but it might be cheaper to not write the code. In regard to scalability with Visual Studio LightSwitch I’m seeing more issues in defining scalable databases.

As Visual Studio LightSwitch is based on .NET technologies, I expect enough extension possibilities where the extensions are done by “real developers” to have this technology for a broad range of scenarios.

Of course every tool can and will be misused. For example, when a city changes the postal code which means changing thousands of customers, would it be a good way to use a DataReader to read every one of these customers, and to an UPDATE statement for each one? Or using the ADO.NET Entity Framework to read all the customers into the data context, changing the postal code, and doing a SaveChanges to the database? Or just do a single SQL UPDATE statement instead? Every tool can and will be used in scenarios it isn’t meant to do. I’m not expecting Visual Studio LightSwitch as the tool to do every data-centric application.

One big issue I’ve seen many times with tools that allows much of the functionality by a designer is versioning. If creating a big solution with this tool, how can it be migrated to the next version? Will this be seamless by just opening the solution with a new version? Does it require to redo a lot again? What if many third-party components are used? Does it require to wait until the 3rd party components are moved forward to the next version before migrating?

This needs to be seen how it works out with Visual Studio LightSwitch. Probably it’s best not starting with a big solution but with smaller scenarios. What extensions are required, what’s already in the box?



Feed You can follow this conversation by subscribing to the comment feed for this post.


The problem here is not abstraction IMO. The problem here is that Microsoft can't figure it out with database acces layers. In 2000 I was critiqued when I stood on stage and said that Microsoft has a habit of developing a new database technology ever year or two. I still stand by that.

IMO microsoft needs less new technologies and more refined old technologies. For example apple still uses objective c and it appears to be fine for them. Not saying that I want to code in objective c. I prefer my c#, but I think you get my drift.


I hope it's not using a new database access layer, also not a new service layer. It should be built on EF, WCF....

You're right that there have been too many database access layers. DMO, RDO, ADO, then ADO.NET with DataSets, LINQ to SQL, EF.....

ffxiv gil

Nowadays in a course week it’s possible to create fancy UIs calling services across a network, using complex databases… I wouldn’t want to write this with C or pure assembler code.

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment

Your Information

(Name and email address are required. Email address will not be displayed with the comment.)