Access data code

    application tasks

        ActiveScreens

        object properties and methods

        ShowDefaultScreen method

    change sets

        discarding items

        retrieve original values

    concurrency

        data-conflict screen

        handling conflicts

    general events

        access control methods

        collection methods

        handling events

        InitializeDataWorkspace method

        screen property methods

    managing transactions (LightSwitch)

        apply transactions

        creation

    record creation

        add button dialog

        data sources

        new record

    save pipeline

        phases

        server-side code

        writing code

    screen data

        events

        member list

    user-related details

        IntelliSense options

        logged-on user

    working process

        data access objects

        delete record

        find single records

        properties and Nullable data types

        record creation

        record updates

Adobe PDF documents

    draw methods

    PDF output

    silverPDF

Application deployment. See LightSwitch application deployment

Architecture, LightSwitch application

    data tier

    logic tier

        data-retrieval process

        data-saving process

    parts

    presentation tier

        cosmopolitan and standard shell

        HTML client

        LightSwitch shell

        Silverlight client

        understanding Silverlight screen

ASP.NET configuration

ASP.NET web site

    add web pages

        data source and parameters

        grid and view page

        intrinsic database

        SQL Server data source

    chart control

        pie chart

        SELECT statement

    deploy, IIS web application

    project creation

    secure reports

        access

        web.config file

Asynchronous JavaScript and XML (AJAX)

Authentication method

    application type

    disable

    enable Windows authentication

        radio button

        runtime

    forms authentication

        change password

        window

    stores

        aspnet_Roles table

        aspnet_Users table

        encryption-password

        logout button

        password complexity rules

        share forms

        table relationships

        web application

    use of

Authorization See also Permissions

    application administrator

    bypass validation

    logged-in engineer

        row-level access to data

        Startup_CanRun method

        steps

    logins association

        login names

        modal window (login name drop-down list)

        username ComboBox

        window screen

    manage roles

    screen control properties

Azure platform

    database creation

    publishing process completion

    service type selection

    Visual Studio connection

Business type extension

    creation

    custom controls

    custom editor window

        MaxIntegerEditor

        new window

        popup window

        UI code

        WPF user control

        XAML code

    DurationType

    enforcing validation

        apply validation logic

        metadata

        sheet attributes

        validation logic

    overview

    runtime

    slider control (properties sheet)

    UnderlyingType

Cloud computing. See Azure platform

Concurrency

    data-conflict screen

        autogeneration

        dialog box

    handling conflicts

        EntityConflict object

        re-create

Control extensions See also Group control extensions

    command

        custom button code

        design view (custom button)

        LSML file

        steps

    computer-develop extensions

        library project

        LSPKG project

        web sites

    custom control types

    custom property editors

        runtime designer

        text box

        Visual Studio’s property editor

    detail control (ComboBox)

        control metadata

        design time

        helper class

        overview

        summary properties

    running and deployment

        duration editor control

        product/installation attributes

    value controls (see also Control icon)

        data types

        Duration Editor

        FindControl method

        function

        XAML markup

Control icon, extension

    data-grid control

        display mode control

        display mode template

        duration editor control

        read-only display mode template

        value converter

    default green icon

    retrieve height, size and properties

Culture names

    code and description

    currency symbols

Custom controls

    binding data

        binding path

        data-binding values

        dependency property

        SetBinding method

        value data-binding path references

    binding data collections

        ComboBox control

        screen design

    calling screen code

        custom button

        design view

        SaveControl XAML

        SaveData

        steps

    converting values

        screen layout

        slider control

        tasks

        value converter code

    custom Silverlight control

        custom control methods via dependency properties

        data context

        dependency properties

        duration control

        dynamic value resolution

        local value

        new control and dependency properties

    EditorVisibility values

    first node

    investigate

    opt-in properties

    PasswordBox control

    property names

    screen designer

    sheet

    type PasswordBox

    UI elements

    Visual Studio’s property sheet

Custom screen template

    autocomplete box

    collection controls

    command controls

    details controls

    details picker controls

    group controls

    HTML client

    screen controls

    value and picker controls

    value picker controls

    ViewID

Custom shell extension. See also Data and presentation extensions

    application logo

    ApressShell

    binding data

        command bar section

        shell view models

    custom shell

        add code

        ScreenWrapper object

    managing screens

        executing commands

        methods

        navigation process

    name and description

    overview

    project preparation

    shell definition

    user settings service, save user preferences

Custom theme extension

    different font

    process

    setting different colors

        CommandPanel section

        contents

        gradient background

        theme colors

Custom validation

    child collections

    comparison

    exercise

    file size validation

    identification

    mandatory

        condition

        navigation properties

    regular expressions

    rules and warnings

        AddPropertyError/AddEntityError methods

        creation

        EntityValidationResultsBuilder methods

        validation warning

    uniqueness and duplicates

Data and presentation extensions See also Business type extension

    custom theme extension

        different font

        process

        setting different colors

    data source

        attach data file

        data service class

        entity class

        steps

    screen template extension

        add/edit screen template

        data source type

        new screen dialog

        process

        screen code generation

        screen controls

        template properties

Data Grid control

    add-new row properties

    command bar buttons

    details screen

    header buttons

    hiding existing records

    paging, sorting and searching options

    properties

Data, LightSwitch

    business types

        Email addresses

        meaning

        Money values

        phone numbers

        web addresses and percentage values

    choice lists

        vs. related tables

        reorder items

    computed properties

        calculate dates

        child records

        images

        meaning

        sort and filter

        summary properties

    entities and properties

    existing data source

        attachment

        connect to MySQL data source

        DataTime offset

        delete

        missing tables

        refresh data sources

        SharePoint data

    fields creation (properties)

        changing data types

        ensuring unique values

        formatting numeric fields

        image type

        storing number (double and decimal types)

        string data types

    relationships

        child records deletion

        many-to-many relationships

        one-to-many relationships

        self-referencing/recursive relationships

        SQL server

    SQL Server database

    storing data

    table creation (entities)

Data List control

    configuration

    details screen

Data-picker controls

Data type identifiers

Data validation. See also Custom validation

    access validation results

    client validation works

    database validation

        check constraint

        constraint violation error

        unique index

    deletions

        DeleteIssue_Execute and Issue_Validate code

        server

        tasks

    errors

    HelpDesk application

    predefined validation

    rules declaration

        data types

        properties

    screen validation

        creation

        and entity validation

        screen-level validation

    storage layer

    table designer

    type

    validation summary control

    workflow

Dependency properties, Custom controls

    data context

    dynamic value resolution

    local value

    new control and dependency properties

        behavior

        code-behind

        creation

        DurationEditorInternal.XAML contents

        parts

        steps

Detail control (ComboBox)

    control metadata

        code file

        ComboBox control

        LSML setting

        property attributes

    design time

    helper methods

        class

        ComboBox control code

        CustomEditorHelper

        links

    overview

    summary properties

Documents, HTML interfaces

    download files

        button code

        custom control rendering option

        download links

        file downloader code

        generic handler

        server application context API

    file download

    upload files

        custom file-upload control

        non-HTML5 browsers

        non-HTML5 file-upload process

        process

        screen attach

Dynamic-link libraries (DLLs)

FindControl method

    check boxes read-only

    hiding and showing controls

    IContentItemProxy methods and properties

    IContentItemProxy’s Focus method

Group control extensions

    code

    label visibility

        left aligned

        LSML changes

        toggle layout control

    main parts

    steps

    ToggleControl control

HelpDesk tables

    database diagram

    external tables

    intrinsic databases

HTML client application

HTML interfaces

    add new records

    add screens

    appearance

        apply themes

        icon and title

        ThemeRoller

    custom controls

        access navigation properties

        data

        data changes

        formatting dates

        properties and entities

        replace default controls

    custom HTML-screens

        AddEditIssue screen

        content

    designing screens

        data controls

        data list controls

        data-picker controls

        properties sheet

        top-level screen layout

    dialogs

        child records

        edit child records

    documents

        custom file-upload control

        download files

        non-HTML5 browsers

        screen attach

        upload files

    HTML client

        add client option

        architecture

    JavaScript

        access data

        access screen data collections

        code

        custom command icon

        custom entities

        data validation

        default screen values

        delete records

        hiding controls

        LightSwitch

        screen title

    list control

        EngineerPicker dialog

        open

        query

        screen

        steps

    navigation structure

        different screen

        startup screen

    popups

        compact margins

        design

        steps

        view

    query execution

        code

        custom control

        summary issues

    search screen

    security and access control

        CanExecute methods

        login screen

    Visual Studio 2012 Update 2

Internet Information Services (IIS)

JavaScript, HTML interfaces

    access data

    access screen data collections

        AddEditIssue screen

        methods

        pagination setting

    code

    custom command icon

    custom entities

    data validation

    default screen values

    delete records

        button and confirmation

        option

        steps

    hiding controls

    LightSwitch

        application (myapp) object

        myapp object

    screen title

        object methods and properties

        setting

LightSwitch application

    architecture

        data tier

        logic tier

        parts

        presentation tier

    browser window

        grid opens

        open report

        steps

    build process

    details screen

        reports

        steps

        WebBrowser control

        web page

    HTML client application

    list screen

        steps

        web page

    LSML model

    model-centric architecture

    MVVM

    principles

    print reports

        list and details screen template

        steps

    project

        file view

        HTML client

        solution structure

    reducing project sizes

    steps

LightSwitch application deployment

    application updation

    to Azure platform

        database creation

        publishing process completion

        service type selection

        Visual Studio connection

    data deployment

    errors troubleshooting

        application tracing

    packages installation (see Packages installation)

    publishing to SharePoint

        application uploading

        enable SharePoint button

        Office 365 web site

        publish wizard

        SharePoint client object model (CSOM)

    Publish Wizard

        application service hosting

        application type selection

        Data Connections Page

        Digital Signature/Certificate Page

        prerequisites page

        security page

    steps

        application topology selection

        publishing vs. packaging

        SQL Server set-up

        workstation set-up

    three-tier manual deployment

    web server set-up

        application pools set-up

        ASP.NET configuration

        Secure Sockets Layer (SSL) configuration

        server components installation

        SQL Server Windows authentication configuration

        on Windows Server 2008/2012

        on Windows 2003

        on Windows or Vista

LightSwitch data types

LightSwitch extensions. See also Control extensions

    data types

    installation

        enable

        updates dialog

    many-to-many data control

List control

    EngineerPicker dialog

    open

    query

    screen

    steps

Mail merge word

    template

    writing code

        code creation

        constants

        MailMergeTemplate.docx file

        screen design

Managing transactions (LightSwitch)

    apply transactions

        SaveChanges operation

        screen sections

    save pipeline

        AuditDetail table

        external database and table

        transaction scope

Microsoft SQL Server reporting services

    installation

    RDL

    report creation

        BIDS-server

        deploy

        designer

        drill-through reports

        host report

        import

        issues

        manage and add data source

        report design surface

        writing code

Microsoft Web Deploy Tool

Microsoft Web Platform Installer (Web PI)

Microsoft Word. See also Mail merge Word

    simple automation

    template distribution

        build action-content

        save documents

        template distribution techniques

    Word documents

        generate and show onscreen

        late binding

        send documents-to-printer

    Word template

        bookmark

        enable

Model-centric architecture

Model-View-ViewModel (MVVM)

OData

    consume LightSwitch data

        add data from ASP.NET

        connection to use, various platforms

        from Excel

        issues

        IssueDescription

        IssueSubject

        from .NET

        read data from ASP.NET

        service reference

        web form code

        web page with issues

    define

    external data sources

        connecting to, data sources

        connection settings

        default options

        entity selection

        identifying third party

        screen of

        travel advisory service

        Windows Azure Marketplace credentials

    LightSwitch data, expose

        end point URLs

        querying OData

        raw feed

        securing feeds

Packages installation

    three-tier browser and desktop application installation

        Import Application Package—database connection strings

        Import Application Package dialog—first page

        out-of-browser application install page

    two-tier desktop application installation

        SQL database connection string setting

        SQL database installation

Permissions

    access control tab

    administrators

    debug

    query-level access control

        CanExecute method

    roles

    screen-level access control

        clicking links/buttons

        opening screen

        users

    table-level access control

        editing data

        entity set

        property edit

        reading data

        saving data

    users and roles

Predefined validation. See Data validation

Presentation extension. See Data and presentation extension

PropertyChanged event

    details screen

    new data screen

    SecurityVetted property

Publishing vs. packaging

Publish Wizard

    application service hosting

    application type selection

    data connections page

    Digital Signature/Certificate Page

    prerequisites page

    security page

Queries

    data retrieval

        query operation

        query operations return entities

    data service queries

    default queries

    filter operations

        data elements

        exists/in type query

        not exists, not in

        related child items

        top N records

    global values creation

        class

        LSML file

        parameters

        task

        upgraded projects

    modify screen queries

    pipeline

        business types

        phases

    query creation

    sort and filter data

        apply filters

        comparison (fields/properties)

        display name

        entities

        global values

        literal values

        parts

        passing arguments

        properties

    sorting data

        graphical query designer

        grids

        user setting files

    writing custom code

        Any and All methods

        data locally

        data remote

        Engineer Dashboard page

        ForEach extension method

        LINQ syntax

        method (Lambda) syntax code

        operator and lambda expression

        SQL Profiler result

        standard query operators

Report Definition Language Client-side (RDLC)

Report Definition Language (RDL) files

Reports. See also ASP.NET web site; Microsoft SQL Server reporting services

    Adobe PDF documents

        draw methods

        PDF output

        silverPDF

    LightSwitch application

        browser window

        details screen

        HTML client application

        list screen

        print dialog

        steps

    Microsoft Word

        automation

        mail merges

        template distribution

    techniques

    thrid-party solution

Rich Internet Application (RIA) services

    consume

        attach

        entities

    exercise

    project creation

        domain service class

        enable client access check box

        engineers management screen

        entity class creation

        steps

    retrieve data, domain service code

    SQL stored procedures

        cascade-delete issues

        delete method

        T-SQL definition

    updating data

    web.config

Screen design. See also Threads

    controls

        event handling Silverlight control

        Silverlight control

    controls (see FindControl method)

    control values and default values

        grid and list values

        properties

    custom

        add/edit screen design

        assign and unassign self-joined data

        bulk updating records (Multiselect Grid)

        data grid control

        nested autocomplete boxes

        single row tables

    files

        download and save files

        open files

        uploading files

    managing screens

        continuous new data screen

        MessageBox and InputBox

        open screens (buttons/links)

        passing arguments

        refresh screen

    react to data changes, security clearance (see also PropertyChanged event)

    search screen

        advanced search screen

        control values and default values

        custom text and information

        data controls

        engineer dashboard screen

        exercise

        parameter values

        screen title

Screen template extension

    add/edit screen template

    data source type

    new screen dialog

    process

    screen code generation, template

    screen controls

        corresponding task

        creation

        requirements

    template properties

Secure Sockets Layer (SSL) configuration

Send E-mail

    calling external resource. See also Web services

        AJAX

    COM automation

        outlook message

        screen code (outlook message)

        window screen

    default mail program

        HTML client

        mailto parameters

        Silverlight client

        syntax

    mail pickup folder

    server-side code. See also Trigger server e-mail

        code reusable

        configuration setting-save credentials

        data changes

        file attachments

        MailMessage object properties

        save pipeline

        trigger server e-mail

    techniques

Service type selection

    Cloud service

    Web Site service

SharePoint

    application uploading

    Enable SharePoint button

    Office 365 web site

    publish wizard

    SharePoint client object model (CSOM)

Sharing forms authentication

    connection string

    files

    identical key value

    machine key dialog

    modify

Silverlight screen design

    application properties

        general tab

        localization task

        localized application

        primary language and culture

    control appearances

        positioning control labels

        read-only controls

        sizing options

        styling labels and static text controls

    data-selection controls

        auto complete box control

        modal window picker control

    launch child screens

        EngineerIssues screen

        run time

        target screen options

    record collections

        configuring data grid and data list settings

        data grid and data list controls

        setting data grid header button

    related data items

        design-time view

        details screen

        exercise

        runtime view

    run time (design screens)

    screen

        content tree

        data item containers

        demonstrates, search

        designer toolbar

        detail screen creation

        editable data controls

        grouping and laying out

        mulitiline text

        navigation menu

        properties

        rows, columns and table layout

        search exercise

        static text and images

        tab and group box layout

        template

    single record

sqlcmd.exe arguments

SQL database installation

SQL Server database

SQL Server database validation

SQL Server Data Tools (SSDT)

SQL Server set-up

    Windows authentication configuration

Threads

    code executing on

    execute code

    key points

    LightSwitch application

    syntax

    UI and worker threads

Thrid-party solution

Tracing, LightSwitch application

Trigger server e-mail

    client method

    EmailOperation table

    HTML client

        screen design view

        SendEmail method

        steps

        window screen

    layout

    Silverlight client

        button code

        E-mail composition screen

        screen layout

Troubleshooting errors, LightSwitch application tracing

Two-tier desktop application installation

    SQL database connection string setting

    SQL database installation

Visual Studio’s property editor

    ComboBox control

    custom control editor

        control code

        editor control XAML

        value converter code

    link custom editor

        code editor

        editor list

    project preparation

    properties sheet

    window management system

Web Server set-up

    application pools set-up

    ASP.NET configuration

    Secure Sockets Layer (SSL) configuration

    server components installation, Microsoft Web Deploy Tool

    SQL Server Windows authentication configuration

    on Windows Server 2008/2012

    on Windows 2003

    on Windows or Vista

Web services

    LightSwitch client

        add web service reference

        screen code

    LightSwitch server

        add window

        configuring development server

        implementation code

        interface

        WCF

        web browser

        web.config file

Window management system