Group items tagged

The ASP.NET team implemented the profile management features using a provider model. A base ProfileProvider class defines the interface, or contract, that all profile providers must implement. ASP.NET 2.0 ships with an implementation of the ProfileProvider that uses SQL Server - the SqlProfileProvider class. SqlProfileProvider implements the ProfileProvider methods (like FindProfilesByUserName) by executing stored procedures in SQL Server.

在使用ADO.NET时，如果SqlParameter的Type是nvarchar，并且没有指定Size属性，则可能就会因为具体参数的尺寸不同而造成查询计划无法复用的结果。这一点，很多人都忽视了。