dotConnect for Adobe Commerce Documentation
Devart.Common Namespace / DbLoaderColumn Class / Scale Property
Example

In This Topic
    Scale Property (DbLoaderColumn)
    In This Topic
    Gets or sets the number of decimal places to which column value is resolved.
    Syntax
    'Declaration
     
    Public Property Scale As Integer
    public int Scale {get; set;}

    Property Value

    The number of decimal places to which column value is resolved. The default value is 0.
    Remarks
    Use Scale property to set the scale of number columns.
    Example
    public void GetDataColumns(MagentoConnection adobe commerceConnection)
    {
      
      adobe commerceConnection.Open();
      MagentoLoader loader = new MagentoLoader();
      loader.Connection = adobe commerceConnection;
      loader.TableName = "load_table";
      MagentoLoaderColumn myColumn;
      try
      {
        loader.CreateColumns();
        for (int i = 0; i < loader.Columns.Count; i++)
        {
          myColumn = loader.Columns[i];
          Console.WriteLine(myColumn.Name);
          Console.WriteLine(myColumn.MagentoType.ToString());
          Console.WriteLine(myColumn.Size);
          Console.WriteLine(myColumn.Scale);
          Console.WriteLine(myColumn.Precision);
          Console.WriteLine();
        }
       }
      finally
      {
        adobe commerceConnection.Close();
      }
    }
    public void GetDataColumns(MagentoConnection adobe commerceConnection)
    {
      
      adobe commerceConnection.Open();
      MagentoLoader loader = new MagentoLoader();
      loader.Connection = adobe commerceConnection;
      loader.TableName = "load_table";
      MagentoLoaderColumn myColumn;
      try
      {
        loader.CreateColumns();
        for (int i = 0; i < loader.Columns.Count; i++)
        {
          myColumn = loader.Columns[i];
          Console.WriteLine(myColumn.Name);
          Console.WriteLine(myColumn.MagentoType.ToString());
          Console.WriteLine(myColumn.Size);
          Console.WriteLine(myColumn.Scale);
          Console.WriteLine(myColumn.Precision);
          Console.WriteLine();
        }
       }
      finally
      {
        adobe commerceConnection.Close();
      }
    }
    See Also