开发者

loweredrolename in aspnet_users table (SQL Server 2005)

开发者 https://www.devze.com 2023-01-10 16:46 出处:网络
For my existing data, both RoleName and LoweredRoleName are same, 开发者_如何学运维but some are lower case and some are in same case too.

For my existing data, both RoleName and LoweredRoleName are same, 开发者_如何学运维but some are lower case and some are in same case too.

Anyone knows what is the use of column LoweredRoleName in aspnet_users table?


They are the same. I think used internally by .net. Maybe LoweredRoleName is used to avoid using SQL's LOWER() function.


I'm sure there is a reason for it, on the cusp it seems redundant and a design smell.

0

精彩评论

暂无评论...
验证码 换一张
取 消