SalesforceType Property (SalesforceLoaderColumn)

In This Topic

Gets or sets the SalesforceType of the column.

Syntax

Visual Basic
C#

'Declaration
 
Public Property SalesforceType As SalesforceType

public SalesforceType SalesforceType {get; set;}

Property Value

A SalesforceType value of the column. The default value is SalesforceType.VarChar.

Remarks

Use SalesforceType property to specify Salesforce.com or Database.com data type for the column.

Example

csharp

public void GetDataColumns(SalesforceConnection salesforceConnection)
{
  salesforceConnection.Open();
  SalesforceLoader loader = new SalesforceLoader();
  loader.Connection = salesforceConnection;
  loader.TableName = "load_table";
  SalesforceLoaderColumn myColumn;
  try
  {
    loader.CreateColumns();
    for (int i = 0; i < loader.Columns.Count; i++)
    {
      myColumn = loader.Columns[i];
      Console.WriteLine(myColumn.Name);
      Console.WriteLine(myColumn.SalesforceType.ToString());
      Console.WriteLine(myColumn.Size);
      Console.WriteLine(myColumn.Scale);
      Console.WriteLine(myColumn.Precision);
      Console.WriteLine();
    }
   }
  finally
  {
    salesforceConnection.Close();
  }
}

Visual Basic

Public Sub GetDataColumns(ByVal salesforceConnection As SalesforceConnection)
  salesforceConnection.Open()
  Dim loader As SalesforceLoader
  loader = New SalesforceLoader
  loader.Connection = salesforceConnection
  loader.TableName = "load_table"
  Dim myColumn As SalesforceLoaderColumn
  Try
    loader.CreateColumns()
    Dim i As Integer
    For i = 0 To loader.Columns.Count - 1
      myColumn = loader.Columns(i)
      Console.WriteLine(myColumn.Name)
      Console.WriteLine(myColumn.SalesforceType.ToString())
      Console.WriteLine(myColumn.Size)
      Console.WriteLine(myColumn.Scale)
      Console.WriteLine(myColumn.Precision)
      Console.WriteLine()
    Next i
  Finally
    salesforceConnection.Close()
  End Try
End Sub

Reference

SalesforceLoaderColumn Class
SalesforceLoaderColumn Members
CreateColumns Method

Send Feedback