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.
精彩评论