.NET (Core and Framework)

public static void SendDataSet( DataSet ds )<br />
{<br />
    foreach( DataTable dt in ds.Tables )<br />
    {<br />
	SendDataTable( dt );<br />
    }<br />
}<br />
<br />
<br />
public static void SendDataTable( DataTable dt )<br />
    {<br />
    bool[] coerceToString;  // Do we need to coerce this column to string?<br />
    SqlMetaData[] metaData = ExtractDataTableColumnMetaData( dt, out coerceToString );<br />
<br />
    SqlDataRecord record = new SqlDataRecord( metaData );<br />
    SqlPipe pipe = SqlContext.Pipe;<br />
    pipe.SendResultsStart( record );<br />
    try {<br />
	foreach( DataRow row in dt.Rows )<br />
	    {<br />
	    for( int index=0; index<record.FieldCount; index++ )<br />
		{<br />
		object value = row[ index ];<br />
		if ( null != value &&  coerceToString[ index ] )<br />
		    value = value.ToString( );<br />
		record.SetValue( index, value );<br />
		}<br />
<br />
	    pipe.SendResultsRow( record );<br />
	    }<br />
	}<br />
    finally<br />
	{<br />
	pipe.SendResultsEnd( );<br />
	}<br />
    }<br />
<br />
private static SqlMetaData[] ExtractDataTableColumnMetaData( DataTable dt, out bool[] coerceToString )<br />
    {<br />
    SqlMetaData[] metaDataResult = new SqlMetaData[ dt.Columns.Count ];<br />
    coerceToString = new bool[ dt.Columns.Count ];<br />
    for( int index = 0; index < dt.Columns.Count; index++ )<br />
	{<br />
	DataColumn column = dt.Columns[ index ];<br />
	metaDataResult[ index ] = SqlMetaDataFromColumn( column, out coerceToString[ index ] );<br />
	}<br />
<br />
    return metaDataResult;<br />
    }<br />
<br />
private static Exception InvalidDataTypeCode( TypeCode code )<br />
    {<br />
    return new ArgumentException( "Invalid type: " + code );<br />
    }<br />
<br />
private static Exception UnknownDataType( Type clrType )<br />
    {<br />
    return new ArgumentException( "Unknown type: " + clrType );<br />
    }<br />
<br />
private static SqlMetaData SqlMetaDataFromColumn( DataColumn column, out bool coerceToString )<br />
    {<br />
    coerceToString = false;<br />
    SqlMetaData smd = null;<br />
    Type clrType = column.DataType;<br />
    string name = column.ColumnName;<br />
    switch ( Type.GetTypeCode( clrType ) )<br />
	{<br />
	case TypeCode.Boolean:    smd = new SqlMetaData( name, SqlDbType.Bit ); break;<br />
	case TypeCode.Byte:        smd = new SqlMetaData( name, SqlDbType.TinyInt ); break;<br />
	case TypeCode.Char:        smd = new SqlMetaData( name, SqlDbType.NVarChar, 1 ); break;<br />
	case TypeCode.DateTime:    smd = new SqlMetaData( name, SqlDbType.DateTime ); break;<br />
	case TypeCode.DBNull:        throw InvalidDataTypeCode( TypeCode.DBNull );<br />
	case TypeCode.Decimal:     smd = new SqlMetaData( name, SqlDbType.Decimal, 18, 0 ); break;<br />
	case TypeCode.Double:        smd = new SqlMetaData( name, SqlDbType.Float ); break;<br />
	case TypeCode.Empty:        throw InvalidDataTypeCode( TypeCode.Empty );<br />
	case TypeCode.Int16:        smd = new SqlMetaData( name, SqlDbType.SmallInt ); break;<br />
	case TypeCode.Int32:        smd = new SqlMetaData( name, SqlDbType.Int ); break;<br />
	case TypeCode.Int64:        smd = new SqlMetaData( name, SqlDbType.BigInt ); break;<br />
	case TypeCode.SByte:        throw InvalidDataTypeCode( TypeCode.SByte );<br />
	case TypeCode.Single:        smd = new SqlMetaData( name, SqlDbType.Real ); break;<br />
	case TypeCode.String:       smd = new SqlMetaData( name, SqlDbType.NVarChar, column.MaxLength );<br />
	    break;<br />
	case TypeCode.UInt16:    throw InvalidDataTypeCode( TypeCode.UInt16 );<br />
	case TypeCode.UInt32:    throw InvalidDataTypeCode( TypeCode.UInt32 );<br />
	case TypeCode.UInt64:    throw InvalidDataTypeCode( TypeCode.UInt64 );<br />
	case TypeCode.Object:<br />
	    if ( clrType == typeof( System.Byte[] ) || clrType == typeof( SqlBinary ) || clrType == typeof( SqlBytes ) ||<br />
		    clrType == typeof( System.Char[] ) || clrType == typeof( SqlString ) || clrType == typeof( SqlChars ) )<br />
		smd = new SqlMetaData( name, SqlDbType.VarBinary, column.MaxLength );<br />
	    else if ( clrType == typeof( System.Guid ) )<br />
		smd = new SqlMetaData( name, SqlDbType.UniqueIdentifier );<br />
	    else if ( clrType == typeof( System.Object ) )<br />
		smd = new SqlMetaData( name, SqlDbType.Variant );<br />
	    else if ( clrType == typeof( SqlBoolean ) )<br />
		smd = new SqlMetaData( name, SqlDbType.Bit );<br />
	    else if ( clrType == typeof( SqlByte ) )<br />
		smd = new SqlMetaData( name, SqlDbType.TinyInt );<br />
	    else if ( clrType == typeof( SqlDateTime ) )<br />
		smd = new SqlMetaData( name, SqlDbType.DateTime );<br />
	    else if ( clrType == typeof( SqlDouble ) )<br />
		smd = new SqlMetaData( name, SqlDbType.Float );<br />
	    else if ( clrType == typeof( SqlGuid ) )<br />
		smd = new SqlMetaData( name, SqlDbType.UniqueIdentifier );<br />
	    else if ( clrType == typeof( SqlInt16 ) )<br />
		smd = new SqlMetaData( name, SqlDbType.SmallInt );<br />
	    else if ( clrType == typeof( SqlInt32 ) )<br />
		smd = new SqlMetaData( name, SqlDbType.Int );<br />
	    else if ( clrType == typeof( SqlInt64 ) )<br />
		smd = new SqlMetaData( name, SqlDbType.BigInt );<br />
	    else if ( clrType == typeof( SqlMoney ) )<br />
		smd = new SqlMetaData( name, SqlDbType.Money );<br />
	    else if ( clrType == typeof( SqlDecimal ) )<br />
		smd = new SqlMetaData( name, SqlDbType.Decimal, SqlDecimal.MaxPrecision, 0 );<br />
	    else if ( clrType == typeof( SqlSingle ) )<br />
		smd = new SqlMetaData( name, SqlDbType.Real );<br />
	    else if ( clrType == typeof( SqlXml ) )<br />
		smd = new SqlMetaData( name, SqlDbType.Xml );<br />
	    else<br />
		{<br />
		// Unknown type, try to treat it as string;<br />
		smd = new SqlMetaData( name, SqlDbType.NVarChar, column.MaxLength );<br />
		coerceToString = true;<br />
		}<br />
	    break;<br />
<br />
<br />
	default:        throw UnknownDataType( clrType );<br />
	}<br />
<br />
    return smd;<br />
    }<br />
<br />