Control the tables generated by SimpleMembershipProvider?

I found SimpleMembershipProvider to be pretty neat and productive.

I was wondering if there is a way to control the generate table/column names/datatypes.

  • Detach database programmatically
  • Aggregate function with where clause
  • Parsing XML content with absent elements in SQL Server 2012
  • Connect to a VIEW on an SQL database using SAS
  • Error in SQL Server query - inner join
  • How can I discriminates results of a query by which part of HAVING clause was satisfied?
  • Rows to columns SQL Server query
  • ddmmyyyy to sql datetime in SQL
  • Read value from a complex XML structure using SQL Server
  • convert date format from mmddyy to yyyy-mm-dd hh:mm:sec
  • Sum values from multiple rows into one row
  • How to reverse a field in SQL Server 2008
  • One Solution collect form web for “Control the tables generated by SimpleMembershipProvider?”

    You can control the table name for the user table and the column names for the user id and user name columns in it. You specify those in the InitializeDatabaseConnection method. The SimpleMembershipProvider expects the UserId column to be an IDENTITY column. It uses @@IDENTITY to obtain the ID of newly created records. Currently, the SimpleMembershipProvider only works with SQL Server (Express or Full) or SQL Compact 4.0 databases.

    You can’t change the schema of the membership or roles tables. The SQL for managing accounts and using those tables is hard-coded into the SimpleMemberhipProvider.

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.