ASP.NET通用提供程序有哪些功能使默认SQL提供程序没有提供功能? [英] What do the ASP.NET Universal Providers enable that the default sql providers don't?

问题描述

在ASP.NET通用提供程序 NuGet程序包的自述文件中是这句话

Inside the readme file of the ASP.NET Universal providers NuGet package is this quote

通过版本4在ASP.NET中提供的SqlMembershipProvider，SqlRoleProvider，SqlProfileProvider类仅支持Microsoft SQL Server和Microsoft SQL Server Express.它们不支持Microsoft SQL Azure和Microsoft SQL Server Compact等较新的产品.

The SqlMembershipProvider, SqlRoleProvider, SqlProfileProvider classes that shipped in ASP.NET through version 4 support only Microsoft SQL Server and Microsoft SQL Server Express. They do not support newer offerings such as Microsoft SQL Azure and Microsoft SQL Server Compact.

但是，当我运行Sql Azure的自定义aspnet_regsql脚本时 http://support.microsoft.com/kb/2006191 ，然后将我的web.config指向SQL Azure数据库，ASP.NET成员身份似乎可以正常工作.

However, when I run the custom aspnet_regsql scripts for Sql Azure http://support.microsoft.com/kb/2006191 and then point my web.config to the SQL Azure database, ASP.NET membership seems to work correctly.

有人能告诉我通用提供程序启用的SQL Azure到底不起作用吗?

Can anyone tell me what exactly doesn't work with SQL Azure, that the universal providers enable?

推荐答案

主要区别在于，当您连接到Sql Azure时，您需要实现

The main difference, as far as I can tell, is that when you connect to Sql Azure you need to implement retry logic. The original providers won't retry when a connection error occurs and this will happen from time to time with SQL Azure.

此外，原始提供程序不会引发包含完整SQL错误代码的异常，因此，如果数据库受到限制，则您将不知道要应用哪个限制规则.至少这是SQL Azure支持团队告诉我的-为此，我目前正在升级中.

Also, the original providers don't raise exceptions containing the full SQL error codes so if your database is being throttled you won't know which throttling rule is being applied. At least this is what the SQL Azure support team tell me - I'm currently in the process of upgrading for this reason.

注意事项:通用提供程序似乎使用了与原始提供程序不同的数据库架构，因此您将需要迁移成员资格数据.如果您要开始一个新项目，那么在与真实用户一起使用之前，更改这些提供程序会容易得多！

A note of caution: the Universal Providers seem to use a different database schema to the original providers, so you will need to migrate membership data. If you are starting a new project it will be much easier to change these providers before you go live with real users!

这篇关于ASP.NET通用提供程序有哪些功能使默认SQL提供程序没有提供功能?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！