Size Property (DbLoaderColumn)
Gets or sets the maximum size, in bytes, of the data within the column.
public virtual int Size {get; set;}
'Declaration
Public Overridable Property Size As Integer
Property Value
The maximum size, in bytes, of the data within the column.
public void GetDataColumns(SQLiteConnection sqConnection)
{
sqConnection.Open();
SQLiteLoader loader = new SQLiteLoader();
loader.Connection = sqConnection;
loader.TableName = "load_table";
SQLiteLoaderColumn myColumn;
try
{
loader.CreateColumns();
for (int i = 0; i < loader.Columns.Count; i++)
{
myColumn = loader.Columns[i];
Console.WriteLine(myColumn.Name);
Console.WriteLine(myColumn.SQLiteType.ToString());
Console.WriteLine(myColumn.Size);
Console.WriteLine(myColumn.Scale);
Console.WriteLine(myColumn.Precision);
Console.WriteLine();
}
}
finally
{
sqConnection.Close();
}
}
public void GetDataColumns(SQLiteConnection sqConnection)
{
sqConnection.Open();
SQLiteLoader loader = new SQLiteLoader();
loader.Connection = sqConnection;
loader.TableName = "load_table";
SQLiteLoaderColumn myColumn;
try
{
loader.CreateColumns();
for (int i = 0; i < loader.Columns.Count; i++)
{
myColumn = loader.Columns[i];
Console.WriteLine(myColumn.Name);
Console.WriteLine(myColumn.SQLiteType.ToString());
Console.WriteLine(myColumn.Size);
Console.WriteLine(myColumn.Scale);
Console.WriteLine(myColumn.Precision);
Console.WriteLine();
}
}
finally
{
sqConnection.Close();
}
}