什么是在aspnet_Profiles表PropertyValuesString和PropertyValuesBinary字段？ [英] What are the PropertyValuesString and PropertyValuesBinary fields in the aspnet_Profiles table for?
问题描述
我想通了PropertyValuesString是什么通常是键 - 值对这些类型的对象的价值的一部分。但随后在什么地方PropertyValuesBinary里回来，如果你已经把价值成PropertyValuesString？
I figured the PropertyValuesString was for the value part of what is usually the Key-Value pair of these types of object. But then where does the PropertyValuesBinary field come in if you've already put the value into the PropertyValuesString?
两个字段都是非空的，所以我需要的东西摆在每一个。什么是这两个，我应该在它们被放在有何区别？
Both fields are non-nullable so I need something to put in each. What's the difference between the two and what should I be putting in them?
另外，我想知道为什么它是复数 - 为PropertyValue ** S ** - 并没有真正意义又与整个键值对的事情，我想一个属性应该有一个值
Also, I was wondering why it's plural -- PropertyValue**s** -- doesn't really make sense again with the whole key-value pair thing, I figured one property should have one value.
推荐答案
的SqlProfileProvider坚持的aspnet_Profile表的三个域配置文件属性：PropertyNames，PropertyValuesString和PropertyValuesBinary。下面是一个什么样的存储在每个领域的简介：
* PropertyNames持有其中包含有关PropertyValuesString和PropertyValuesBinary字段中的配置文件属性值present信息的字符串值。字符串持有项目的冒号分隔的列表;每个项目表示一个属性值，它是连接在下面的格式codeD：
名称：B | S：StartPos：长度
SqlProfileProvider persists profile properties in three fields of the aspnet_Profile table: PropertyNames, PropertyValuesString, and PropertyValuesBinary. The following is a synopsis of what's stored in each field: * PropertyNames holds a string value containing information about the profile property values present in the PropertyValuesString and PropertyValuesBinary fields. The string holds a colon-delimited list of items; each item denotes one property value, and it is encoded in the following format: Name:B|S:StartPos:Length
名称是属性值的名字。第二个参数，它可以是B（为二进制）或S（用于串），表示相应的属性值是否存储在 PropertyValuesString 字段（S），或在 PropertyValuesBinary 字段（B）。 StartPos和长度指示的开始位置（从0开始）在这些字段中的相应属性值的，并且该数据的长度，分别为。 -1长度表示该属性是一个引用类型，它的值为空。
* PropertyValuesString 商店配置文件属性值持续为字符串。这包括使用字符串类型转换器序列由.NET Framework的XML序列化序列化的属性值和属性值。在PropertyNames字段中的S值包含分解所需要的偏移量和长度 PropertyValuesString 成单独的属性值。
* PropertyValuesBinary店配置文件属性值坚持以二进制格式 - 这是被使用.NET Framework的二进制序列序列化，配置文件属性。在PropertyNames字段中的B值包含分解所需要的偏移量和长度 PropertyValuesBinary 成单独的属性值。
Name is the property value's name. The second parameter, which is either B (for "binary") or S (for "string"), indicates whether the corresponding property value is stored in the PropertyValuesString field (S) or the PropertyValuesBinary field (B). StartPos and Length indicate the starting position (0-based) of the corresponding property value within these fields, and the length of the data, respectively. A length of -1 indicates that the property is a reference type, and that its value is null. * PropertyValuesString stores profile property values persisted as strings. This includes property values serialized by the .NET Framework's XML serializer, and property values serialized using string type converters. The "S" values in the PropertyNames field contain the offsets and lengths needed to decompose PropertyValuesString into individual property values. * PropertyValuesBinary stores profile property values persisted in binary format—that is, profile properties that were serialized using the .NET Framework's binary serializer. The "B" values in the PropertyNames field contain the offsets and lengths needed to decompose PropertyValuesBinary into individual property values.
注意，个人资料提供者不需要以这种形式或任何其他形式留存数据。在其中信息数据被存储的格式是留给人或写入提供商的人的决定。
Note that profile providers are not required to persist data in this format or any other format. The format in which profile data is stored is left to the discretion of the person or persons writing the provider.
原来的链接了解更多信息：<一href=\"http://msdn.microsoft.com/en-us/library/aa478953.aspx\">http://msdn.microsoft.com/en-us/library/aa478953.aspx
希望这有助于。
original link for more info :http://msdn.microsoft.com/en-us/library/aa478953.aspx hope this helps.
这篇关于什么是在aspnet_Profiles表PropertyValuesString和PropertyValuesBinary字段？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
