An Encrypted String Data Type for Visual Studio LightSwitch

On VB

An Encrypted String Data Type for Visual Studio LightSwitch

Learn how to extend support for Microsoft C#-only BlankExtension/BizType projects to Visual Basic.

By Joe Kunk 07/02/2011

In my recent article, " Is Visual Studio LightSwitch the New Access? ", I looked at the suitability of LightSwitch as a replacement tool for departmental applications developed in Microsoft Access. LightSwitch is being positioned as a tool for the power user to develop Microsoft .NET Framework applications without having to face the substantial learning curve of the full .NET technology stack. I described each of the six extension types available to add the functionality to LightSwitch that an experienced .NET developer might want to use to make development in LightSwitch easier, or that a designer may want to use to build a visually appealing application.

This article demonstrates the usefulness of LightSwitch extension points by showing how to build a custom business data type to provide automatic encryption to a database string field. Once installed, the "Encrypted String" field data type can be available for use in any table in a LightSwitch project with the extension enabled. When a field of the Encrypted String data type is used in a LightSwitch screen, the field automatically decrypts itself when the cursor enters the field and automatically encrypts itself whenever the cursor leaves the field. The LightSwitch developer can store sensitive information in the database in encrypted form with no more effort than selecting the "Encrypted String" data type when designing the table.

Figure 1 shows an example of a LightSwitch grid with two rows of data, each row having User Name and Password as the Encrypted String data type. The cursor is in the Password field of the first row, so it's shown and editable as plain text -- which is automatically encrypted when the cursor leaves the field. The Comments column shows the decrypted value of each field. The database sees and saves the field value in its encrypted form; be sure to allow sufficient length in the database field for the encrypted string value.

Installing and Using the Encrypted String Business Type
In order to run LightSwitch, you must be using Visual Studio Professional or higher with Service Pack 1 installed, and also the Visual Studio LightSwitch beta 2 (available for download here ). Beta 1 must be uninstalled before installing beta 2.

Visual Studio Download - News


An Encrypted String Data Type for Visual Studio LightSwitch

In order to run LightSwitch, you must be using Visual Studio Professional or higher with Service Pack 1 installed, and also the Visual Studio LightSwitch beta 2 (available for download here). Beta 1 must be uninstalled before installing beta 2.



Levels of TFS Build Automation

The rock star/superhero level of TFS Builds is when you incorporate two other great new TFS 2010 and Visual Studio 2010 features: Lab Management and coded UI tests. Both of these features are aimed at eliminating the headaches and repetitive,



PVS-Studio has learned to watch over your programming

The feature is currently available only for Visual Studio 2010 users. I wrote many times that the sooner an error is detected, the lower is the price of fixing it. Well, I'm certainly not the first one to say it and authors of numerous books and



Microsoft Updates HTML5 Support for Visual Studio

Microsoft today released its Web Standards Update for Microsoft Visual Studio 2010 SP1. The update works on both commercial versions of Visual Studio, as well as the free Visual Web Developer Express 2010 SP1. The download, hosted on the Visual Studio



Microsoft versus Microsoft: IE9 busts MSDN for a security gaffe

Today, a self-described “rogue faction” at Microsoft released an add-in for Visual Studio 2010 that improves HTML5 and JavaScript support. (Read Mary Jo Foley's writeup for more details.) But a funny thing happens if you use Internet Explorer 9 to




Download MS Visual Studio 2010 Ultimate Activated 100% fast and ...

[center]

MS Visual Studio 2010 Ultimate Activated 100%

The Visual Studio development system is a comprehensive suite of tools designed to help software developers create innovative, next-generation applications. It’s the perfect work environment for application developers. Microsoft Visual Studio 2010 and the .NET Framework 4.0 are the next generation development tools and platform for Windows Vista, the 2007 Office System, and the Web. Visual Studio 2010 and the .NET Framework 4.0 mark the next generation of developer tools from Microsoft

. Designed to address the latest needs of developers, Visual Studio delivers key innovations in the following pillars: The Microsoft Visual Studio delivers on the Microsoft vision of smart client applications by enabling developers to rapidly create connected applications that deliver the highest quality, rich user experiences.


Twitter

Antonio J. Casanova Visual Studio: Kineck SDK for PC: VB Samples - Download Kinect for Windows SDK beta and start coding using the avail...


Owen Rumney RT : Visual Studio: Kineck SDK for PC: VB Samples - Download Kinect for Windows SDK beta and start coding (cont)


Du Ru Kang RT : Visual Studio: Kineck SDK for PC: VB Samples - Download Kinect for Windows SDK beta and start coding using the avail...


아크몬드 Archmond.com RT : Visual Studio: Kineck SDK for PC: VB Samples - Download Kinect for Windows SDK beta and start coding using the avail...


Joon Hong / 홍준모 RT : Visual Studio: Kineck SDK for PC: VB Samples - Download Kinect for Windows SDK beta and start coding using the avail...


Visual Studio Download - Bookshelf

Microsoft Visual Studio 2010, A Beginner's Guide

Microsoft Visual Studio 2010, A Beginner's Guide

In a series that includes illustrations, each volume explains an aspect of computing in easy-to-understand terms, so that even beginners will be able to grasp ...

Professional Visual Studio 2010

Professional Visual Studio 2010


Introducing .Net 4.0, With Visual Studio 2010

Introducing .Net 4.0, With Visual Studio 2010

Provides information on the features of .NET 4.0 and Visual Studio 2010 along with their supporting technologies.

Visual Studio 2010 All-in-One For Dummies

Visual Studio 2010 All-in-One For Dummies

It's new and better than ever! Learn to use Visual Studio 2010 with this book Developers, listen up!

Stephens' C# Programming with Visual Studio 2010 24-Hour Trainer

Stephens' C# Programming with Visual Studio 2010 24-Hour Trainer

Each lesson begins with a discussion of a concept or technique and proceeds through step-by-step directions for using the technique Visual C# has surpassed ...

Day-to-day Note Directory


Visual Studio 2010 Trial Downloads | Microsoft Visual Studio
Download a Visual Studio 2010 trial version and take 30 days to test drive the version of Visual Studio you're most interested in, Professional, Premium, Ultimate or Team.

Visual Studio Downloads | MSDN
Download and install Microsoft Visual Studio2010 software, trial software, beta releases, service packs, updates, code, and more.

Microsoft Visual Studio 2005 – Update to Support Web ...


Silverlight 3 Beta Tools for Visual Studio


Visual Studio Download
quickly and easily download visual studio ... Posted by admin in visual studio on 11. Jun, 2011 | Comments Off. Version : 4.0 Latest Update : October 18, 2006 Publisher : ...