Convert Image to Stream

public Image GetImageById( int id )
{
// Initialize connection.
SqlConnection dbconn = new SqlConnection( "connectionstring" );

try
{
// Create command and fetch image.
using(SqlCommand command = dbconn.CreateCommand())
{
// Set select query and add Id parameter with value.
command.CommandText = "SELECT [ImageField] FROM [Table1] WHERE [Id] = @Id";
command.Parameters.Add("@Id", SqlDbType.Int, 4).Value = id;

// Open the connection.
dbconn.Open();

// Excecute the select query.
byte[] imageData = (byte[])command.ExecuteScalar();

// If we recieved an image, return it; otherwise
// just return a null reference value.
if( imageData != null && imageData.Lenght != 0 )
{
using(MemoryStream stream = new MemoryStream( imageData ))
{
return Image.FromStream( stream );
}
}
else
{
// Image not found.
return null;
}
}
}
finally
{
dbconn.Close();
}
}