1, .net 将字典数据转换成xml 字符串

Dictionary<string, DateTime> dicUserLocked = new Dictionary<string, DateTime>();    

      if (!dicUserLocked.ContainsKey(model.UserName))
     {
            dicUserLocked.Add(model.UserName, System.DateTime.Now);
     }
     // ....
    dicLockedUsers.ToXml<string, System.DateTime>().ToString()



2,  传参至存储过程后如何取值

var tmpList =
                    this.GenerateSqlSpParameter(column_LockedUsers, (dicLockedUsers == null) ? null : dicLockedUsers.ToXml<string, System.DateTime>().ToString());
                 tmpList.SqlDbType = System.Data.SqlDbType.Xml;
                 parameters.Add(tmpList);
declare @X xml
  set @X=convert(xml,N'<Dictionary><Item><Key><string>jones.zhang</string></Key><Value><dateTime>2015-04-16T10:24:36.4149457+08:00</dateTime></Value></Item></Dictionary>')
  SELECT @X
 
  declare @XmlHandle int
  EXEC sp_xml_preparedocument @XmlHandle OUTPUT, @x;
    select * from OPENXML (@XmlHandle, '/Dictionary/Item',2)
    WITH (
      [A] [varchar](200) 'Key/string',
      [B] [DateTime] 'Value/dateTime'
    );
 
         EXEC sp_xml_removedocument @XmlHandle;


  截图：

 

.net 将字典数据转换成xml 字符串， 以及传参至存储过程后如何取值_xml