/// <summary> /// Writes the media object to a stream. /// </summary> /// <param name="mediaId">The media id.</param> /// <param name="output">The output.</param> private void WriteMedia(int mediaId, Stream output) { using (NpgsqlConnection conn = FileHandlerHelpers.GetPgConnection()) { int noid = 0; using (NpgsqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = "SELECT data FROM \"MediaContent\" WHERE id=:id;"; cmd.Parameters.Add("id", mediaId); noid = Convert.ToInt32(cmd.ExecuteScalar()); } NpgsqlTransaction tran = conn.BeginTransaction(); LargeObjectManager lbm = new LargeObjectManager(conn); LargeObject largeObject = lbm.Open(noid, LargeObjectManager.READWRITE); largeObject.Seek(0); int size = largeObject.Size(); byte[] buffer = new byte[size]; int read = 0; int offset = 0; while (offset < size) { read = largeObject.Read(buffer, offset, Math.Min(102400, size - offset)); output.Write(buffer, offset, read); offset += 102400; } largeObject.Close(); tran.Commit(); } }
public int GetLargeObjectSize(int oid) { using (IDbTransaction transaction = BeginTransaction()) { int result; LargeObject obj = Manager.Open(oid); result = obj.Size(); obj.Close(); return(result); } }
/// <summary> /// Gets the contents of a LargeObject into a buffer. /// </summary> /// <param name="largeObject">The large object.</param> /// <returns></returns> /// <remarks>Documented by Dev02, 2008-08-08</remarks> private byte[] LargeObjectToBuffer(LargeObject largeObject) { largeObject.Seek(0); int size = largeObject.Size(); byte[] buffer = new byte[size]; int offset = 0; while (offset < size) { largeObject.Read(buffer, offset, Math.Min(chunkSize, size - offset)); offset += chunkSize; } return(buffer); }