private static void WriteXmlValue(DataCommand command, XmlWriter xml, DataRow row, DataColumn col) { DataCommandColumn commandCol = command.Columns.Where(c => c.Name.ToLower() == col.ColumnName.ToLower()).SingleOrDefault(); if (commandCol != null) { object rawValue = row[col.ColumnName]; //commandCol.Type if (rawValue is DBNull) { } else { Type t = Type.GetType("System." + commandCol.Type); object v = Convert.ChangeType(rawValue, t); switch (commandCol.Type.ToLower()) { case "guid": xml.WriteValue(v.ToString()); break; default: xml.WriteValue(v); break; } } } else { xml.WriteValue(row[col].ToString()); } }
private static void WriteJsonValue(DataCommand command, JsonWriter json, DataRow row, DataColumn col) { DataCommandColumn commandCol = command.Columns.Where(c => c.Name.ToLower() == col.ColumnName.ToLower()).SingleOrDefault(); if (commandCol != null) { object rawValue = row[col.ColumnName]; //commandCol.Type if (rawValue is DBNull) { json.WriteNull(); } else { Type t = Type.GetType("System." + commandCol.Type); object v = Convert.ChangeType(rawValue, t); json.WriteValue(v); } } else { json.WriteValue(row[col].ToString()); } }