OracleDataContextOptions.InitialLongFetchSize Property

.NET Standard 2.x

Specifies the initial amount of LONG and LONG RAW data that is immediately fetched.

Namespace: SnapObjects.Data.Oracle

Assembly: SnapObjects.Data.Oracle.dll

Syntax

public int InitialLongFetchSize { get; set; }

Property Value

System.Int32

An int specifying the number of characters or bytes to fetch initially.

Remarks

This property specifies the number of characters to fetch for the LONG column data and the number of bytes to fetch for the LONG RAW column data.

It defaults to 0, which fetches the full length of the LONG and LONG RAW column data.

Setting this property to -1 defers the retrieval of LONG and LONG RAW column data entirely.

Examples

The following code example uses the InitialLongFetchSize property to specify the number of characters to fetch for the Oracle LONG column data.

using Appeon.ApiDoc.Models;
using SnapObjects.Data;
using SnapObjects.Data.Oracle;
using System;

namespace Appeon.ApiDoc.OracleDataContextOptionsExamples
{
    public class InitialLongFetchSizeExample
    {
        public void Example()
        {
            var options = new OracleDataContextOptions(CONNECTION_STRING);

            // specifies the number of characters to fetch for the LONG column data and the 
            // number of bytes to fetch for the LONG RAW column data.
            options.InitialLongFetchSize = 20;

            var dataContext = new OracleDataContext(options);

            Console.WriteLine((dataContext.ContextOptions as OracleDataContextOptions).InitialLongFetchSize);

            /*This code produces the following output:

            20
            */
        }
    }
}

Applies to

.NET Standard

2.x