public static string Dump(this SqlDataRecord record) { var sb = new StringBuilder(); sb.Append("{"); for (var i = 0; i < record.FieldCount; i++) { if (i != 0) { sb.Append(","); } var name = record.GetName(i); var value = record.GetValue(i); var fieldType = record.GetFieldType(i); if (fieldType == typeof(string)) { sb.Append($"{name}:'{value}'"); } else { sb.Append($"{name}:{value}"); } } sb.Append("}"); return(sb.ToString()); }
public void GetFieldType_ReturnMetaTypeClassType() { SqlMetaData[] metaData = new SqlMetaData[] { new SqlMetaData("col1", SqlDbType.NVarChar, 50) }; SqlDataRecord record = new SqlDataRecord(metaData); Assert.Equal(typeof(string), record.GetFieldType(0)); }
private SqlDataRecord SetDbRecord(SqlDataRecord record, object value, int index) { if (value.IsPrimitive()) { var cValue = Convert.ChangeType(value, record.GetFieldType(index)); record.SetValue(index, cValue); } else { record.SetValue(index, value.ToString()); } return(record); }