public static ICreateTableWithColumnSyntax WithIdColumn(this ICreateTableWithColumnSyntax tableWithColumnSyntax) { return(tableWithColumnSyntax.WithColumn("Id").AsGuid().NotNullable().PrimaryKey()); }
public static ICreateTableWithColumnSyntax Timestamps(this ICreateTableWithColumnSyntax migration) { return(migration .WithColumn("CreatedAt").AsDateTime().NotNullable().WithDefault(SystemMethods.CurrentDateTime) .WithColumn("UpdatedAt").AsDateTime().Nullable()); }
/// <summary> /// Adds modification auditing columns to a table. See <see cref="IModificationAudited"/>. /// </summary> public static ICreateTableColumnOptionOrForeignKeyCascadeOrWithColumnSyntax WithModificationAuditColumns(this ICreateTableWithColumnSyntax table) { return(table .WithColumn("LastModificationTime").AsDateTime().Nullable() .WithColumn("LastModifierUserId").AsInt64().Nullable().ForeignKey("AbpUsers", "Id")); }
/// <summary> /// Adds IsDeleted column to the table. See <see cref="ISoftDelete"/>. /// </summary> public static ICreateTableColumnOptionOrWithColumnSyntax WithIsDeletedColumn(this ICreateTableWithColumnSyntax table) { return(table .WithColumn("IsDeleted").AsBoolean().NotNullable().WithDefaultValue(false)); }
/// <summary> /// Ads CreationTime field to the table for <see cref="IHasCreationTime"/> interface. /// </summary> public static ICreateTableColumnOptionOrWithColumnSyntax WithCreationTimeColumn(this ICreateTableWithColumnSyntax table) { return(table .WithColumn("CreationTime").AsDateTime().NotNullable().WithDefault(SystemMethods.CurrentDateTime)); }
/// <summary> /// Определяет новый столбец с именем на основе свойства или поля, переданного в выражении <paramref name="columnAccessor"/>. /// </summary> /// <returns>См. <see cref="ICreateTableWithColumnSyntax.WithColumn(string)"/>.</returns> /// <remarks>В качестве имени столбцы используется значение атрибута <see cref="ColumnAttribute"/> или имя свойства/типа из выражения <paramref name="columnAccessor"/>.</remarks> public static ICreateTableColumnAsTypeSyntax WithColumn <TTable, TProperty>(this ICreateTableWithColumnSyntax table, Expression <Func <TTable, TProperty> > columnAccessor) { return(table.WithColumn(GetColumnName(columnAccessor))); }
/// <summary> /// Adds IsDeleted column to the table. See <see cref="IPassivable"/>. /// </summary> public static ICreateTableColumnOptionOrWithColumnSyntax WithIsActiveColumn(this ICreateTableWithColumnSyntax table, bool defaultValue = true) { return(table .WithColumn("IsActive").AsBoolean().NotNullable().WithDefaultValue(defaultValue)); }
/// <summary> /// Adds DeleterUserId field to a table. See <see cref="IDeletionAudited"/>. /// </summary> public static ICreateTableColumnOptionOrWithColumnSyntax WithDeleterUserIdColumn(this ICreateTableWithColumnSyntax table) { return(table .WithColumn(SheshaDatabaseConsts.DeleterUserIdColumn).AsInt64().Nullable().ForeignKey(SheshaDatabaseConsts.UsersTable, SheshaDatabaseConsts.IdColumn)); }
/// <summary> /// Adds TenantId column to a table as nullable. See <see cref="AbpTenant{TUser}"/>. /// </summary> public static ICreateTableColumnOptionOrForeignKeyCascadeOrWithColumnSyntax WithTenantIdAsNullable(this ICreateTableWithColumnSyntax table) { return(table .WithColumn(SheshaDatabaseConsts.TenantIdColumn).AsInt32().Nullable().ForeignKey(SheshaDatabaseConsts.TenantsTable, SheshaDatabaseConsts.IdColumn)); }
/// <summary> /// Adds DeleterUserId field to a table. See <see cref="IDeletionAudited"/>. /// </summary> public static ICreateTableColumnOptionOrForeignKeyCascadeOrWithColumnSyntax WithDeleterUserIdColumn(this ICreateTableWithColumnSyntax table) { return(table .WithColumn("DeleterUserId").AsInt64().Nullable().ForeignKey("AbpUsers", "Id")); }
protected override void CreateEntityColumns(ICreateTableWithColumnSyntax entityTable) { entityTable.WithColumn("PhoneNumber").AsString(); }
public static ICreateTableWithColumnSyntax WithId(this ICreateTableWithColumnSyntax table) { return(table.WithColumn("Id").AsId()); }
protected override void CreateEntityColumns(ICreateTableWithColumnSyntax entityTable) { entityTable.WithColumn("Title").AsString(255); }
public static ICreateTableColumnOptionOrWithColumnSyntax WithTimeStamps(this ICreateTableWithColumnSyntax tableWithColumnSyntax) { return(tableWithColumnSyntax .WithColumn("CreatedAt").AsDateTime().NotNullable() .WithColumn("ModifiedAt").AsDateTime().NotNullable()); }
public static ICreateTableColumnOptionOrWithColumnSyntax WithIdColumn(this ICreateTableWithColumnSyntax table, string columnName) { return(table.WithColumn(columnName).AsInt32().NotNullable().PrimaryKey().Identity()); }
public static ICreateTableColumnOptionOrForeignKeyCascadeOrWithColumnSyntax WithNullableUserId(this ICreateTableWithColumnSyntax table, string columnName) { return(table .WithColumn(columnName).AsInt64().Nullable().ForeignKey(SheshaDatabaseConsts.UsersTable, SheshaDatabaseConsts.IdColumn)); }
public static ICreateTableColumnOptionOrForeignKeyCascadeOrWithColumnSyntax WithNullableUserId(this ICreateTableWithColumnSyntax table, string columnName) { return(table .WithColumn(columnName).AsInt64().Nullable().ForeignKey("AbpUsers", "Id")); }
/// <summary> /// Adds an <see cref="Guid"/> primary key to the table. /// </summary> public static ICreateTableColumnOptionOrWithColumnSyntax WithIdAsGuid(this ICreateTableWithColumnSyntax table) { return(table .WithColumn(SheshaDatabaseConsts.IdColumn).AsGuid().NotNullable().PrimaryKey()); }
/// <summary> /// Adds LastModificationTime field to a table. See <see cref="IModificationAudited"/>. /// </summary> public static ICreateTableColumnOptionOrWithColumnSyntax WithLastModificationTimeColumn(this ICreateTableWithColumnSyntax table, bool defaultValue = true) { return(table .WithColumn("LastModificationTime").AsDateTime().Nullable()); }
/// <summary> /// Adds DeletionTime column to a table. See <see cref="IDeletionAudited"/>. /// </summary> public static ICreateTableColumnOptionOrWithColumnSyntax WithDeletionTimeColumn(this ICreateTableWithColumnSyntax table) { return(table .WithColumn(SheshaDatabaseConsts.DeletionTimeColumn).AsDateTime().Nullable()); }
/// <summary> /// Adds an auto increment <see cref="long"/> primary key to the table. /// </summary> public static ICreateTableColumnOptionOrWithColumnSyntax WithIdAsInt64(this ICreateTableWithColumnSyntax table) { return(table .WithColumn("Id").AsInt64().NotNullable().PrimaryKey().Identity()); }
/// <summary> /// Adds foreign key column (Int64) to the table /// </summary> public static ICreateTableColumnOptionOrWithColumnSyntax WithForeignKeyColumnInt64(this ICreateTableWithColumnSyntax table, string foreignColumn, string masterTable) { return(table.WithColumn(foreignColumn).AsInt64().Nullable().ForeignKey(masterTable, SheshaDatabaseConsts.IdColumn).Indexed()); }
/// <summary> /// Adds DeletionTime column to a table. See <see cref="IDeletionAudited"/>. /// </summary> public static ICreateTableColumnOptionOrWithColumnSyntax WithDeletionTimeColumn(this ICreateTableWithColumnSyntax table) { return(table .WithColumn("DeletionTime").AsDateTime().Nullable()); }
/// <summary> /// Adds discriminator field to a table. /// </summary> public static ICreateTableColumnOptionOrWithColumnSyntax WithDiscriminator(this ICreateTableWithColumnSyntax table) { return(table.WithColumn(SheshaDatabaseConsts.DiscriminatorColumn).AsString(SheshaDatabaseConsts.DiscriminatorMaxSize)); }
public static ICreateTableWithColumnSyntax WithEntityBaseColumes(this ICreateTableWithColumnSyntax table) { return(table.WithColumn("Id").AsInt32().PrimaryKey().Identity().NotNullable() .WithColumn("CreatedAtUtc").AsDateTime().NotNullable() .WithColumn("ModifiedAtUtc").AsDateTime().NotNullable()); }
/// <summary> /// Adds columns for <see cref="IHasOwningEntityLink"/> /// </summary> public static ICreateTableColumnOptionOrWithColumnSyntax WithMultipleOwnerColumns(this ICreateTableWithColumnSyntax table, int ownerIdSize = 40) { return(table .WithColumn(SheshaDatabaseConsts.OwnerIdColumn).AsString(ownerIdSize).Nullable().Indexed() .WithColumn(SheshaDatabaseConsts.OwnerTypeColumn).AsString(100).Nullable().Indexed()); }
public static ICreateTableWithColumnSyntax EffectiveDates(this ICreateTableWithColumnSyntax migration) { return(migration .WithColumn("StartDate").AsDateTime().NotNullable().WithDefault(SystemMethods.CurrentDateTime) .WithColumn("EndDate").AsDateTime().Nullable()); }
/// <summary> /// Adds columns for <see cref="IHasEntityLink"/> /// </summary> public static ICreateTableColumnOptionOrWithColumnSyntax WithEntityLinkColumns(this ICreateTableWithColumnSyntax table) { return(table .WithColumn(SheshaDatabaseConsts.EntityIdColumn).AsString(40).Nullable().Indexed() .WithColumn(SheshaDatabaseConsts.EntityTypeColumn).AsString(100).Nullable().Indexed()); }
/// <summary> /// Adds TenantId column to a table as nullable. See <see cref="AbpTenant{TTenant,TUser}"/>. /// </summary> public static ICreateTableColumnOptionOrForeignKeyCascadeOrWithColumnSyntax WithTenantIdAsNullable(this ICreateTableWithColumnSyntax table) { return(table .WithColumn("TenantId").AsInt32().Nullable().ForeignKey("AbpTenants", "Id")); }
public static ICreateTableWithColumnSyntax WithArchiveColumn(this ICreateTableWithColumnSyntax tableWithColumnSyntax) { return(tableWithColumnSyntax.WithColumn("IsArchived").AsBoolean().NotNullable().WithDefaultValue(false)); }