Examining ASP.NET 2.0"s Membership, Roles, and Profile - Part 9

ASP.NET 2.0"s Membership, Roles, and Profile systems were designed using the provider model, which enables these systems to seamlessly use different implementations. ASP.NET ships with a provider for managing members and roles through SQL Server and another for using Active Directory. It is also possible to plug in other implementations that have been built from the ground up or downloaded from other sources. For example, you can download alternative providers from Microsoft that store membership and role information in a Microsoft Access database (see Part 8 of this article series). Most of the articles in this series, however, have focused on using the SQL Server provider (SqlMembershipProvider, SqlRoleProvider, and SqlProfileProvider). The SQL Server providers are typically the provider of choice for Internet-based web applications, whereas the Active Directory providers are more commonly used in intranet scenarios.

The SQL Server providers create a number of tables, views, and stored procedures in the specified SQL Server database. Therefore when using these providers it is possible to add, modify, or delete membership or roles or profile-related data through T-SQL statements. In this article we"ll look at a common membership need - deleting users. While users can certainly be deleted through the .NET Membership API, there are scenarios where it may be much easier to use a T-SQL script. However, bypassing the managed APIs and working directly with the database is not without its own host of challenges. By the end of this article we"ll have addressed these issues, discussed the pros and cons of using T-SQL in lieu of the managed APIs, and have examined both the managed API methods and T-SQL commands for deleting a single user and deleting all users. Read on to learn more!
Read More >

>>Source Link
>>Blog: 4GuysFromRolla.com Headlines
>>Publish Date: 10/8/2007 10:20:25 PM
>>Keywords: sql membership

Related Posts
>>A Multipart Series on ASP.NET 2.0"s Membership, Roles, and Profile #
Interessante Serie über ASP.NET 2.0"s Membership, Roles, and Profile auf http://www.4guysfromrolla.com/. Part 1 - learn about how the membership features make providing user accounts on your website
>>Examining ASP.NET 2.0"s Membership, Roles, and Profile - Part 8 #
A Multipart Series on ASP.NET 2.0"s Membership, Roles, and Profile This article is one in a series of articles on ASP.NET 2.0"s membership, roles, and profile functionality. Part 1 - learn about how t
>>Using ASP.NET Forms Authentication with all types of content on IIS7 (Video) #
One of my favorite ASP.NET features is forms authentication, supported by the powerful membership system in ASP.NET 2.0. Back when I built Web applications for a living, I remember agonizing over the
>>SharePoint 2007 Custom Authentication using the Asp.Net Membership Database #
This article provides step-by-step instructions for configuring SharePoint 2007 to use the Asp.Net Membership database to authenticate users. I highly recommend reading Andrew Connell"s blog first, s
>>Porting data into the ASP.NET Membership system through the APIs #
Over the past couple of days, I have been working on porting some user data into the ASP.NET Membership system. I started off by writing some sql scripts, however, when I hit the password, I ran into
>>Utility to Automatically Provision Sql Server Forms Based Authentication (FBA) Sites in SharePoint #
Within the next few days, we"ll be releasing a free utility that allows you to easily and automatically provision Sql Server forms-based authentication sites in SharePoint. Specifically, this menu-dr
>>WSS 3.0 for Hosters Solution Kit now available on CodePlex #
At the Microsoft Hosting Summit about a month ago, the Windows SharePoint Services 3.0 for Hosters Solution Kit was announced. This kit would include the following custom components: Forms-based aut
>>Provider, Strategy, Adapter pattern discussion #
Some of my coworkers and I were having a discussion today regarding the aforementioned patterns. First we debated the validity of the Provider pattern actually being considered a pattern, or if it wa
>>Tip/Trick: Integrating ASP.NET Security with Classic ASP and Non-ASP.NET URLs #
One of the questions I am often asked is "How can I integrate ASP.NET security with Classic ASP other non-ASP.NET URLs?". Specifically, people want to know if they can integrate ASP.NET"s Forms Auth
>>Released: Free Utility Quickly and Easily Configures Forms Based Authentication for SharePoint #
Configuring forms based authentication (FBA) for SharePoint can be tedious for experts and a little bit challenging for everyone else. The idea of using a Sql Server aspnetdb database as your SharePoi