Set Permissions For a Query Using LightSwitch Visual Studio 2012

Introduction

In this article I describe how to create permission and write code to set permission for a query using LightSwitch in Visual Studio 2012.

Here, we learn how to define a permission for our application. The permission can be assigned to a user or a group of users.

Permission in LightSwitch for Queries

1. Creating a permission in LightSwitch

Step 1

Open the Solution Explorer in LightSwitch Visual Studio 2012.

Image 1

solexp.jpg

Step 2

In the Solution Explorer double-click or right-click and select "Properties".

Image 2

propopen.jpg

Step 3

The Application Designer will appear.

Image 3

appdesign.jpg

Step 4

Choose the "Access control" option in the application designer.

Image 4

actrl.jpg

Step 5

Select the type of authentication to use and in this use form authentication.

Image 5

use.jpg

Step 6

In the "Define permissions or select permissions to use for debugging" node click on "<Add New Permission>" then type "Can_View_Employee" under "Name".

Image 6

name.jpg

Step 7

Similarly, under the "Display Name" column type "View Employee".

Image 7

Dname.jpg

Step 8

And in the same manner under the Description column type "Provide access to the employee screen".

Image 8

no permission.jpg

Step 9

Under the "Grant For Debug" column mark the checkbox as checked then the table will appear or if we mark the checkbox as unchecked then the table will not appear on the screen.

Image 9

permission.jpg

2. Writing code to set permissions for the query

Step 1

In the Solution Explorer we will right-click on the table ("Emp1Tables") and select "Add Query".

Image 1

query1.jpg

Step 2

The Query Designer for the query will appear.

Image 2

query designer.jpg

Step 3

In the Filter section, click "Add Filter" and apply the filter condition in the dropdown list and TextBox.

Image 3

filter.jpg

Step 4

In the "Sorting" section, click "Add Sort" and apply the sorting condition in the dropdown list.

Image 4

sort.jpg

Step 5

Similarly, in the "Parameters" section, click "Add Parameters" and apply the parameter condition in the dropdown list and TextBox.

Image 5

parameters.jpg

Step 6

There is a "Write Code" option at the top in which we write the code for the given query.

Image 6

writecode.jpg

Step 7

In the Write Code drop down list, select the "QueryName_CanExecute" method. Here the QueryName is "Query1".

Image 7

writecode1.jpg

Step 8

In the "Query1_CanExecute" method write the code that you want to enter, as in the following:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using Microsoft.LightSwitch;

using Microsoft.LightSwitch.Security.Server;

namespace LightSwitchApplication

{

    public partial class ApplicationDataService

    {

        partial void Query1_CanExecute(ref bool result)

        {

            // Enter the Code Here

        }

    }

}

 

Up Next
    Ebook Download
    View all
    Learn
    View all