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());
}
}
