Audience
Developers, analysts and power users who need to create simple database-based applications without in-depth programming or technology skills will benefit from attending this course. This course is delivered with Visual Studio 2015, but previous versions are available on request.
Prerequisites
A fundamental understanding of programming in any programming language, especially .NET languages would be advantageous.
Duration
2 days. Hands on.
This course is available on site only. Please call for details.
Course Objectives
Visual Studio LightSwitch is a special edition of Visual Studio, designed to speed up the development of database applications rapidly. These applications can be deployed at any time without any other changes as a desktop, web, cloud and mobile applications simultaneously. Delegates will learn how to create a stable, 3-tier application, in a few minutes. Application development is fast, saves lots of time and allows for deploying the application into production several times faster.
Upon successful completion of this course, delegates will be able to:
- Create database-based applications rapidly.
- Validate user input.
- Change the look of application.
- Create applications from application templates.
- Set application security.
- Deploy applications into production.
Course Content
Overview of Visual Studio LightSwitch
Creating a LightSwitch project.
Definition of data.
Creating screens.
Validation of user input.
Publishing the application.
Data Sources
Connecting to an external database.
Working with entities and their fields.
Displaying choice lists.
Adding calculated fields.
Linking data using relationships.
Filtering, sorting and grouping data with graphical queries.
Custom validation methods.
Screens
The screens showing data.
Adjusting screens and controls.
Adjusting the appearance of the application at runtime.
Using images together with data.
Creating menus and screen commands.
Linking screens together.
Screen templates and visual themes.
Extending LightSwitch
Extending user controls.
Extensions for data sources.
Integration with C# and VB.NET applications.
Application Security
Setting up authentication.
Creating authorizations.
Restricting access to screens.
Using Debug Permissions to test code.
Architecture of LightSwitch Applications
Overview of architecture.
Presentation layer.
Application layer.
Data layer.
Extending LightSwitch applications.
Deploying applications.