public System.IO.Stream GetBinaryStreamByUrl(string url) { SqlReaderStream stream = null; using (SqlConnection cn = new SqlConnection(ConnectionString)) { SqlCommand cmd = new SqlCommand(SqlQuery, cn); cmd.Parameters.Add("@url", SqlDbType.VarChar, 255); // note: the length of the URL parameter must equal the length of the BINARY_VARIANT.PATH column in the broker database cmd.Parameters["@url"].Value = url; cn.Open(); //CommandBehavior.SequentialAccess avoids loading the entire BLOB in-memory. SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.SequentialAccess); if (false == reader.Read()) { reader.Dispose(); return(null); } stream = new SqlReaderStream(reader, 0); } return(stream); }
public System.IO.Stream GetBinaryStreamByUrl(string url) { SqlReaderStream stream = null; using (SqlConnection cn = new SqlConnection(ConnectionString)) { SqlCommand cmd = new SqlCommand(SqlQuery, cn); cmd.Parameters.Add("@url", SqlDbType.VarChar, 255); // note: the length of the URL parameter must equal the length of the BINARY_VARIANT.PATH column in the broker database cmd.Parameters["@url"].Value = url; cn.Open(); //CommandBehavior.SequentialAccess avoids loading the entire BLOB in-memory. SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.SequentialAccess); if (false == reader.Read()) { reader.Dispose(); return null; } stream = new SqlReaderStream(reader, 0); } return stream; }