OracleBFile Class
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Represents a managed OracleBFile object designed to work with the Oracle BFILE
data type. This class cannot be inherited.
public ref class OracleBFile sealed : System::IO::Stream, ICloneable, System::Data::SqlTypes::INullable
public sealed class OracleBFile : System.IO.Stream, ICloneable, System.Data.SqlTypes.INullable
type OracleBFile = class
inherit Stream
interface ICloneable
interface IDisposable
interface INullable
type OracleBFile = class
inherit Stream
interface ICloneable
interface INullable
interface IDisposable
Public NotInheritable Class OracleBFile
Inherits Stream
Implements ICloneable, INullable
- Inheritance
- Implements
The Oracle BFILE
data type is an Oracle LOB
data type that contains a reference to binary data with a maximum size of 4 gigabytes. An Oracle BFILE
differs from other Oracle LOB
data types in that its data is stored in a physical file in the operating system instead of on the server. Note that the BFILE
data type provides read-only access to data. Therefore, write-oriented methods inherited from the Stream class are not supported.
Other characteristics of a BFILE
data type that distinguish it from a LOB
data type are that it:
Contains unstructured data.
Supports server-side chunking.
Uses reference copy semantics. For example, if you perform a copy operation on a
BFILE
, only theBFILE
locator (which is a reference to the file) is copied. The data in the file is not copied.
The BFILE
data type should be used for referencing LOB
s that are large in size, and therefore, not practical to store in the database. There is client, server, and communication overhead for using a BFILE
data type compared to the LOB
data type. It is more efficient to access a BFILE
if you only need to obtain a small amount of data. It is more efficient to access database-resident LOB
s if you need to obtain the entire object.
Each non-NULL OracleBFile object is associated with two entities that define the location of the underlying physical file:
An Oracle DIRECTORY object, which is a database alias for a directory in the file system, and
The file name of the underlying physical file, which is located in the directory associated with the DIRECTORY object.
After a BFILE
is created, you can retrieve its locator in the form of an OracleBFile object using the ExecuteReader or ExecuteScalar methods.
To obtain an OracleBFile object, call the GetOracleBFile method.
The physical file that an OracleBFile object is associated with does not need to exist until you attempt to access it. An application can bind an OracleBFile to a nonexistent file, create the physical file in the expected location, and then call Read.
Any attempt to access a closed OracleBFile using the Read or Seek methods reopens an OracleBFile stream automatically.
The following C# example demonstrates how you can create a BFILE
in an Oracle table, and then retrieve it in the form of an OracleBFile object. The example demonstrates the use of the OracleDataReader object and the OracleBFileSeek and Read methods.
private void GetOracleBFile(string connectionString)
{
//Create and open the connection.
using (OracleConnection connection = new OracleConnection(connectionString))
{
connection.Open();
//Create and execute the commands.
OracleCommand command = connection.CreateCommand();
command.CommandText = "CREATE OR REPLACE DIRECTORY TestDir AS 'c:\\bfiles'";
command.ExecuteNonQuery();
command.CommandText = "CREATE TABLE TestTable(col1 number, col2 BFILE)";
command.ExecuteNonQuery();
command.CommandText = "INSERT INTO TestTable VALUES ('2', BFILENAME('TESTDIR', 'File.jpg'))";
command.ExecuteNonQuery();
command.CommandText = "SELECT * FROM TestTable";
//Read the BFile data.
byte[] buffer = new byte[100];
OracleDataReader dataReader = command.ExecuteReader();
using (dataReader)
{
if (dataReader.Read())
{
OracleBFile BFile = dataReader.GetOracleBFile(1);
using (BFile)
{
BFile.Seek(0, SeekOrigin.Begin);
BFile.Read(buffer, 0, 100);
}
}
}
}
return;
}
For more information about creating and using an Oracle BFILE
, see the appropriate topic in your Oracle documentation.
Märkus
The BeginWrite
, EndWrite
, and WriteByte
methods, which are inherited from the System.IO.Stream
class, are not supported because the BFILE
data type is read-only.
Null |
Represents a null OracleBFile object that is not bound to a physical file. |
Can |
Gets a value indicating whether the |
Can |
Gets a value indicating whether forward-seek and backward-seek operations can be performed. |
Can |
Gets a value that determines whether the current stream can time out. (Inherited from Stream) |
Can |
Gets a value indicating whether the object supports writing. |
Connection |
Gets the OracleConnection used by this instance of the OracleBFile. |
Directory |
Gets the name of the DIRECTORY object, with which an OracleBFile object is associated. |
File |
Gets a value indicating whether a physical file containing |
File |
Gets the name of the |
Is |
Gets a value that indicates whether the OracleBFile is a Null stream. |
Length |
Gets a value that returns the length in bytes of the physical file with which the OracleBFile object is associated. |
Position |
Gets the current read position in the OracleBFile stream. |
Read |
Gets or sets a value, in milliseconds, that determines how long the stream will attempt to read before timing out. (Inherited from Stream) |
Value |
Gets an Array of type Byte that contains the OracleBFile data. |
Write |
Gets or sets a value, in milliseconds, that determines how long the stream will attempt to write before timing out. (Inherited from Stream) |
Begin |
Begins an asynchronous read operation. (Consider using ReadAsync(Byte[], Int32, Int32) instead.) (Inherited from Stream) |
Begin |
Begins an asynchronous write operation. (Consider using WriteAsync(Byte[], Int32, Int32) instead.) (Inherited from Stream) |
Clone() |
Creates a copy of this OracleBFile object associated with the same physical file as the original. |
Close() |
Closes the current stream and releases any resources (such as sockets and file handles) associated with the current stream. Instead of calling this method, ensure that the stream is properly disposed. (Inherited from Stream) |
Copy |
Copies from this OracleBFile to a destination OracleLob with the specified amount of data, the source offset, and the destination offset. |
Copy |
Copies the entire contents of this OracleBFile to a destination OracleLob at the specified offset. |
Copy |
Copies the entire contents of this OracleBFile to the beginning of a destination OracleLob. |
Copy |
Reads the bytes from the current stream and writes them to another stream, using a specified buffer size. Both streams positions are advanced by the number of bytes copied. (Inherited from Stream) |
Copy |
Reads the bytes from the current stream and writes them to another stream. Both streams positions are advanced by the number of bytes copied. (Inherited from Stream) |
Copy |
Asynchronously reads the bytes from the current stream and writes them to another stream, using a specified cancellation token. Both streams positions are advanced by the number of bytes copied. (Inherited from Stream) |
Copy |
Asynchronously reads the bytes from the current stream and writes them to another stream, using a specified buffer size and cancellation token. Both streams positions are advanced by the number of bytes copied. (Inherited from Stream) |
Copy |
Asynchronously reads the bytes from the current stream and writes them to another stream, using a specified buffer size. Both streams positions are advanced by the number of bytes copied. (Inherited from Stream) |
Copy |
Asynchronously reads the bytes from the current stream and writes them to another stream. Both streams positions are advanced by the number of bytes copied. (Inherited from Stream) |
Create |
Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. (Inherited from MarshalByRefObject) |
Create |
Obsolete.
Obsolete.
Obsolete.
Allocates a WaitHandle object. (Inherited from Stream) |
Dispose() |
Releases all the resources that are used by this object. |
Dispose() |
Releases all resources used by the Stream. (Inherited from Stream) |
Dispose(Boolean) |
Releases the unmanaged resources used by the Stream and optionally releases the managed resources. (Inherited from Stream) |
Dispose |
Asynchronously releases the unmanaged resources used by the Stream. (Inherited from Stream) |
End |
Waits for the pending asynchronous read to complete. (Consider using ReadAsync(Byte[], Int32, Int32) instead.) (Inherited from Stream) |
End |
Ends an asynchronous write operation. (Consider using WriteAsync(Byte[], Int32, Int32) instead.) (Inherited from Stream) |
Equals(Object) |
Determines whether the specified object is equal to the current object. (Inherited from Object) |
Flush() |
Not currently supported. |
Flush |
Asynchronously clears all buffers for this stream and causes any buffered data to be written to the underlying device. (Inherited from Stream) |
Flush |
Asynchronously clears all buffers for this stream, causes any buffered data to be written to the underlying device, and monitors cancellation requests. (Inherited from Stream) |
Get |
Serves as the default hash function. (Inherited from Object) |
Get |
Obsolete.
Retrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from MarshalByRefObject) |
Get |
Gets the Type of the current instance. (Inherited from Object) |
Initialize |
Obsolete.
Obtains a lifetime service object to control the lifetime policy for this instance. (Inherited from MarshalByRefObject) |
Memberwise |
Creates a shallow copy of the current Object. (Inherited from Object) |
Memberwise |
Creates a shallow copy of the current MarshalByRefObject object. (Inherited from MarshalByRefObject) |
Object |
Obsolete.
Provides support for a Contract. (Inherited from Stream) |
Read(Byte[], Int32, Int32) |
Reads a sequence of bytes from the current OracleBFile stream and advances the position within the stream by the number of bytes read. |
Read(Span<Byte>) |
When overridden in a derived class, reads a sequence of bytes from the current stream and advances the position within the stream by the number of bytes read. (Inherited from Stream) |
Read |
Asynchronously reads a sequence of bytes from the current stream, advances the position within the stream by the number of bytes read, and monitors cancellation requests. (Inherited from Stream) |
Read |
Asynchronously reads a sequence of bytes from the current stream and advances the position within the stream by the number of bytes read. (Inherited from Stream) |
Read |
Asynchronously reads a sequence of bytes from the current stream, advances the position within the stream by the number of bytes read, and monitors cancellation requests. (Inherited from Stream) |
Read |
Reads at least a minimum number of bytes from the current stream and advances the position within the stream by the number of bytes read. (Inherited from Stream) |
Read |
Asynchronously reads at least a minimum number of bytes from the current stream, advances the position within the stream by the number of bytes read, and monitors cancellation requests. (Inherited from Stream) |
Read |
Reads a byte from the stream and advances the position within the stream by one byte, or returns -1 if at the end of the stream. (Inherited from Stream) |
Read |
Reads |
Read |
Reads bytes from the current stream and advances the position within the stream until the |
Read |
Asynchronously reads |
Read |
Asynchronously reads bytes from the current stream, advances the position within the stream until the |
Seek(Int64, Seek |
Sets the position on the current OracleBFile stream. |
Set |
Binds the OracleBFile object to a different file in the operating system. |
Set |
Not currently supported. |
To |
Returns a string that represents the current object. (Inherited from Object) |
Write(Byte[], Int32, Int32) |
Not currently supported. |
Write(Read |
When overridden in a derived class, writes a sequence of bytes to the current stream and advances the current position within this stream by the number of bytes written. (Inherited from Stream) |
Write |
Asynchronously writes a sequence of bytes to the current stream, advances the current position within this stream by the number of bytes written, and monitors cancellation requests. (Inherited from Stream) |
Write |
Asynchronously writes a sequence of bytes to the current stream and advances the current position within this stream by the number of bytes written. (Inherited from Stream) |
Write |
Asynchronously writes a sequence of bytes to the current stream, advances the current position within this stream by the number of bytes written, and monitors cancellation requests. (Inherited from Stream) |
Write |
Writes a byte to the current position in the stream and advances the position within the stream by one byte. (Inherited from Stream) |
IDisposable. |
Releases all resources used by the Stream. (Inherited from Stream) |
Toode | Versioonid |
---|---|
.NET Framework | 1.1, 2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1 |
Toote „.NET“ tagasiside
.NET on avatud lähtekoodiga projekt. Tagasiside andmiseks valige link: