public MySqlISColumns(Alias alias = default)
: base("INFORMATION_SCHEMA", "", "COLUMNS", alias)
{
this.TableCatalog = this.CreateStringColumn("TABLE_CATALOG", null);
this.TableSchema = this.CreateStringColumn("TABLE_SCHEMA", null);
this.TableName = this.CreateStringColumn("TABLE_NAME", null);
this.ColumnName = this.CreateStringColumn("COLUMN_NAME", null);
this.OrdinalPosition = this.CreateInt32Column("ORDINAL_POSITION");
this.ColumnDefault = this.CreateNullableStringColumn("COLUMN_DEFAULT", null);
this.IsNullable = this.CreateStringColumn("IS_NULLABLE", null);
this.DataType = this.CreateNullableStringColumn("DATA_TYPE", null);
this.CharacterMaximumLength = this.CreateNullableInt64Column("CHARACTER_MAXIMUM_LENGTH");
this.CharacterOctetLength = this.CreateNullableInt64Column("CHARACTER_OCTET_LENGTH");
this.NumericPrecision = this.CreateNullableInt64Column("NUMERIC_PRECISION");
this.DatetimePrecision = this.CreateNullableInt64Column("DATETIME_PRECISION");
this.CharacterSetName = this.CreateNullableStringColumn("CHARACTER_SET_NAME", null);
}
public Organization(Alias alias) : base("dbo", nameof(Organization), alias)
{
this.OrganizationId = this.CreateInt32Column(nameof(this.OrganizationId), ColumnMeta.PrimaryKey());
this.OrganizationName = this.CreateStringColumn(nameof(this.OrganizationName), 250);
}
public CustomerOrder(Alias alias = default) : base("dbo", "CustomerOrder", alias)
{
this.CustomerId = this.CreateInt32Column("CustomerId");
this.OrderId = this.CreateInt32Column("OrderId");
}
public TmpStr(Alias alias = default) : base("TmpStr", alias)
{
this.Index = this.CreateInt32Column("Index", ColumnMeta.PrimaryKey());
this.Text = this.CreateStringColumn("Text", 255, true);
}
public TNext Set(Int32TableColumn column, int value)
{
return(this.SetGeneric(column, SqQueryBuilder.Literal(value)));
}
