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))); }