SQL Anywhere ASP.NET Providers

The SQL Anywhere ASP.NET providers replace the standard ASP.NET providers for SQL Server, and allow you to run your website on a SQL Anywhere database. There are five providers:

  • Membership Provider   The membership provider provides authentication and authorization services. Use the membership provider to create new users and passwords, and validate the identity of users.

  • Roles Provider   The roles provider provides methods for creating roles, adding users to roles, and deleting roles. Use the roles provider to assign users to groups and manage permissions.

  • Profiles Provider   The profiles provider provides methods for reading, storing, and retrieving user information. Use the profiles provider to save user preferences.

  • Web Parts Personalization Provider   The web parts personalization provider provides methods for loading and storing the personalized content and layout of web pages. Use the web parts personalization provider to allow users to create personalized views of your website.

  • Health Monitoring Provider   The health monitoring provider provides methods for monitoring the status of deployed web applications. Use the health monitoring provider to monitor application performance, identify failing applications or systems, and log and review significant events.

The SQL Anywhere database server schema used by the SQL Anywhere ASP.NET providers is identical to the schema used by the standard ASP.NET providers. The methodology used to manipulate and store data are identical.

When you have finished setting up the SQL Anywhere ASP.NET providers, you can use the Visual Studio ASP.NET Web Site Administration Tool to create and manage users and roles. You can also use the Visual Studio Login, LoginView, and PasswordRecovery tools to add security your web site. Use the static wrapper classes to access more advanced provider functions, or to make your own login controls.

Note

A whitepaper called Tutorial: Creating an ASP.NET Web Page using SQL Anywhere is available to demonstrate how to use SQL Anywhere and Visual Studio 2010 to build a database-driven ASP.NET web site. See [external link] www.sybase.com/detail?id=1080238.


Adding the SQL Anywhere ASP.NET provider schema to the database
Registering the connection string
Registering the SQL Anywhere ASP.NET providers
Membership provider XML attributes
Roles provider table schema
Profile provider table schema
Web Part Personalization provider table schema
Health Monitoring provider table schema