Exemple #1
0
 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);
 }
Exemple #2
0
 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);
 }
Exemple #5
0
 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);
 }
Exemple #6
0
 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)));
 }