ASP.Net MVC3天青 - 我需要成员资格提供存储过程？ [英] ASP.Net MVC3 Azure - Do I Need Membership Provider Stored Procedures?

问题描述

我创建的Azure使用DB作为存储我的第一个ASP.Net MVC3应用。有一些伟大的教程，但我目前使用这一个：的演练：在托管ASP.NET Web应用程序的Windows Azure

I am creating my first ASP.Net MVC3 Application using Azure as DB Storage. There are a number of great tutorials but I'm currently using this one: Walkthrough: Hosting an ASP.NET Web Application on Windows Azure

我有我的连接字符串迷上Azure和它的工作的罚款。我运行在调试模式，并通过成员资格提供应用程序注册我的第一个用户。据演练，创建帐户导致ASP.NET创建会员数据库。成功！我现在看到的表（用户，角色，...）已经在我的Azure数据库中创建。太棒了！

I've got my connection string hooked to Azure and its working fine. I run the application in Debug mode and "Register" my first user via the Membership Provider. According to the walkthrough, "Creating an account causes ASP.NET to create the membership database." Success! I now see the tables (Users, Roles,...) have been created in my Azure database. Great!

为什么我很困惑：很多年前，当我使用的成员资格提供做一个ASP.Net 2.0，我用aspnet_regsql.exe的运行所需成员资格提供的所有脚本。我知道他们有一个更新的集合脚本天青的。这些脚本创建所有的表，但也创造了大量的存储过程（例如aspnet_Membership_CreateUser）

Why I'm Confused: Many years ago, when I did an ASP.Net 2.0 using the Membership Provider, I used the aspnet_regsql.exe to run all the scripts needed for the Membership Provider. I know they have an updated set of scripts for Azure. These scripts create all the tables but also create a large number of Stored Procedures (ex. aspnet_Membership_CreateUser)

我的提问：我是否需要运行这些更新Azure的脚本来获得的SP？我看不到我的数据库中创建的任何存储过程还了所有的会员提供的功能似乎没有他们的工作就好了。有什么用全部的存储过程？我需要他们在我MVC3 Azure应用程序？

My question: Do I need to run these updated Azure scripts to get the SPs? I don't see any Stored Procedures created in my database yet all the Membership Provider functionality seems to work just fine without them. What were all those Stored Procedures used for? Do I need them in my MVC3 Azure application?

谢谢！

推荐答案

。在本教程中的一个步骤将通用的供应商作为的NuGet包。您可以参考 HTTP：//nuget.$c$cplex.com/ 有关的更多信息的NuGet。
一包的NuGet基本上是一些pre-书面code，从而简化您的开发。例如，通用提供商自动创建基于您的连接字符串的会员数据库表。当然你也可以继续手动创建数据库表，然后使用内置的ASP.NET成员资格人员。

Since you’re following that tutorial, you’re already using the ASP.NET Universal Providers. One step in the tutorial adds the universal providers as a NuGet package. You can refer to http://nuget.codeplex.com/ for more information about NuGet. A Nuget package is essentially some pre-written code, which simplifies your development. For example, the universal providers automatically create the membership database tables based on your connection string. You can of course, continue to manually create the database tables, and then use the built-in ASP.NET membership provider.

这篇关于ASP.Net MVC3天青 - 我需要成员资格提供存储过程？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！