public InformationSchemaTables(string?database = null, Alias alias = default)
: base(database, "INFORMATION_SCHEMA", "TABLES", alias)
{
this.TableCatalog = this.CreateStringColumn("TABLE_CATALOG", null);
this.TableSchema = this.CreateStringColumn("TABLE_SCHEMA", null);
this.TableName = this.CreateStringColumn("TABLE_NAME", null);
this.TableType = this.CreateStringColumn("TABLE_TYPE", null);
}
public MySqlIsTables(Alias alias = default)
: base("INFORMATION_SCHEMA", "", "TABLES", alias)
{
this.TableCatalog = this.CreateStringColumn("TABLE_CATALOG", null);
this.TableSchema = this.CreateStringColumn("TABLE_SCHEMA", null);
this.TableName = this.CreateStringColumn("TABLE_NAME", null);
this.TableType = this.CreateStringColumn("TABLE_TYPE", null);
}
public MsSqlTableConstraints(Alias alias = default)
: base("INFORMATION_SCHEMA", "TABLE_CONSTRAINTS", alias)
{
this.ConstraintCatalog = this.CreateStringColumn("CONSTRAINT_CATALOG", 128, true);
this.ConstraintSchema = this.CreateStringColumn("CONSTRAINT_SCHEMA", 128, true);
this.ConstraintName = this.CreateStringColumn("CONSTRAINT_NAME", 128, true);
this.TableCatalog = this.CreateStringColumn("TABLE_CATALOG", null, true);
this.TableSchema = this.CreateStringColumn("TABLE_SCHEMA", null, true);
this.TableName = this.CreateStringColumn("TABLE_NAME", null, true);
this.TableType = this.CreateStringColumn("TABLE_TYPE", null, true);
this.ConstraintType = this.CreateStringColumn("CONSTRAINT_TYPE", 11);
this.IsDeferrable = this.CreateStringColumn("IS_DEFERRABLE", 2);
this.InitiallyDeferred = this.CreateStringColumn("INITIALLY_DEFERRED", 2);
}
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 TmpStr(Alias alias = default) : base("TmpStr", alias)
{
this.Index = this.CreateInt32Column("Index", ColumnMeta.PrimaryKey());
this.Text = this.CreateStringColumn("Text", 255, true);
}
public TNext Set(StringTableColumn column, string value)
{
return(this.SetGeneric(column, SqQueryBuilder.Literal(value)));
}