Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
When you choose to enable authentication, LightSwitch uses the ASP.NET membership provider to manage your users. By default, the users that you create are added to a table called aspnet_Users in the intrinsic database. Figure 13-7 shows a screenshot of this table. The primary-key field is called UserId and is of data type GUID. The usernames that you specify are stored in a field called UserName.
Figure 13-7. aspnet_Users table
Any roles that you create are saved in a table called aspnet_Roles. This table is shown in Figure 13-8.
Figure 13-8. aspnet_Roles table
The user-to-role settings are saved in a table called aspnet_UsersInRoles. The user password details are stored in a table called aspnet_Membership, and details that relate to your application are stored in a table called aspnet_Applications.