protected override void CreateEntityColumns(ICreateTableWithColumnSyntax entityTable) { entityTable.WithColumn("UserId").AsInt32() .WithColumn("PhoneNumber").AsString() .WithColumn("Code").AsString() .WithColumn("Expires").AsDateTime(); }
public static ICreateTableColumnOptionOrWithColumnSyntax WithCommonColumns(this ICreateTableWithColumnSyntax table) { return(table .WithColumn("Id").AsInt32().NotNullable().PrimaryKey().Identity() .WithColumn("Name").AsString(255).NotNullable() .WithColumn("Description").AsString(500).Nullable()); }
public static ICreateTableColumnOptionOrWithColumnSyntax WithTimeStamps( this ICreateTableWithColumnSyntax tableWithColumnSyntax) { return(tableWithColumnSyntax .WithColumn("CreatedAt").AsDateTime2().NotNullable() .WithColumn("ModifiedAt").AsDateTime2().NotNullable()); }
public static ICreateTableWithColumnSyntax CreateBase(this ICreateTableWithColumnSyntax create, bool userFK = true) { create .WithColumn("Id") .AsInt32() .NotNullable() .Identity() .PrimaryKey() .WithColumn("Active") .AsBoolean() .NotNullable() .WithDefaultValue(true) .WithColumn("CreateDate") .AsDateTime() .NotNullable() .WithDefaultValue(SystemMethods.CurrentDateTime); if (userFK) { create .WithColumn("IdUsuario") .AsInt32() .NotNullable() .ForeignKey("Usuario", "Id"); } return(create); }
public static ICreateTableWithColumnSyntax WithAuditColumns(this ICreateTableWithColumnSyntax tableWithColumnSyntax) { return(tableWithColumnSyntax.WithColumn("CreatedBy").AsString().WithDefaultValue("Migrator") .WithColumn("CreationDate").AsDateTime().WithDefaultValue(DateTime.UtcNow) .WithColumn("ModifiedBy").AsString().WithDefaultValue("Migrator") .WithColumn("ModificationDate").AsDateTime().WithDefaultValue(DateTime.UtcNow)); }
public static ICreateTableColumnOptionOrWithColumnSyntax WithTimeStamps( this ICreateTableWithColumnSyntax tableWithColumnSyntax) { return(tableWithColumnSyntax .WithColumn("created_at").AsDateTime().NotNullable().WithDefaultValue(RawSql.Insert("now()")) .WithColumn("updated_at").AsDateTime().NotNullable().WithDefaultValue(RawSql.Insert("now()"))); }
protected override void CreateEntityColumns(ICreateTableWithColumnSyntax entityTable) { entityTable.WithColumn("UserName").AsString(50) .WithColumn("DisplayName").AsString(50).Nullable() .WithColumn("HashedPassword").AsString(2000).Nullable() .WithColumn("LastSeenAt").AsDateTime().Nullable(); }
protected override void CreateEntityColumns(ICreateTableWithColumnSyntax entityTable) { entityTable .WithColumn("TopicId").AsInt32() .WithColumn("CreatedBy").AsInt32() .WithColumn("Content").AsString(int.MaxValue); }
protected override void CreateEntityColumns(ICreateTableWithColumnSyntax entityTable) { entityTable.WithColumn("WxId").AsString() .WithColumn("NickName").AsString() .WithColumn("WxAccount").AsString().Nullable() .WithColumn("AvatarFileId").AsInt32().Nullable(); }
protected override void CreateEntityColumns(ICreateTableWithColumnSyntax entityTable) { entityTable.WithColumn("RequireUserPhoneNumberVerified").AsBoolean() .WithColumn("PublicHostName").AsString() .WithColumn("EnableNewUserRegistration").AsBoolean() .WithColumn("EnableNewTopicCreation").AsBoolean() .WithColumn("EnableNewReplyCreation").AsBoolean() .WithColumn("IsReadonly").AsBoolean() .WithColumn("FooterNoticeLeft").AsString().Nullable() .WithColumn("FooterNoticeRight").AsString().Nullable() .WithColumn("HeaderLink1Text").AsString().Nullable() .WithColumn("HeaderLink1Url").AsString().Nullable() .WithColumn("HeaderLink2Text").AsString().Nullable() .WithColumn("HeaderLink2Url").AsString().Nullable() .WithColumn("HeaderLink3Text").AsString().Nullable() .WithColumn("HeaderLink3Url").AsString().Nullable() .WithColumn("HeaderLink4Text").AsString().Nullable() .WithColumn("HeaderLink4Url").AsString().Nullable(); }
public static ICreateTableColumnOptionOrWithColumnSyntax WithTimestamps(this ICreateTableWithColumnSyntax that) { return(that. WithColumn("created_at").AsDateTime(). WithColumn("updated_at").AsDateTime().Nullable() .WithColumn("deleted_at").AsDateTime().Nullable()); }
public static ICreateTableColumnOptionOrWithColumnSyntax WithVersionColumn(this ICreateTableWithColumnSyntax tableWithColumnSyntax) { return(tableWithColumnSyntax .WithColumn("Version") .AsInt32() .NotNullable()); }
WithNameColumn(this ICreateTableWithColumnSyntax tableWithColumnSyntax) { return(tableWithColumnSyntax .WithColumn("name") .AsString(StringLength.Hundred) .NotNullable()); }
protected override void CreateEntityColumns(ICreateTableWithColumnSyntax entityTable) { entityTable .WithColumn("UploadedBy").AsInt32() .WithColumn("Size").AsInt64() .WithColumn("OriginalName").AsString() .WithColumn("StoragePath").AsString(2000); }
public static ICreateTableColumnOptionOrWithColumnSyntax WithTimestampColumns( this ICreateTableWithColumnSyntax tableWithColumnSyntax) { return(tableWithColumnSyntax .WithColumn("DeletedAt").AsDateTime().Nullable().WithDefaultValue(null) .WithColumn("CreatedAt").AsDateTime() .WithColumn("ModifiedAt").AsDateTime()); }
WithIdColumn(this ICreateTableWithColumnSyntax tableWithColumnSyntax) { return(tableWithColumnSyntax .WithColumn("id") .AsInt32() .NotNullable() .PrimaryKey() .Identity()); }
public static ICreateTableColumnOptionOrWithColumnSyntax WithBaseModel( this ICreateTableWithColumnSyntax table ) { return(table .WithColumn("Created").AsDateTime().NotNullable() .WithColumn("Modified").AsDateTime().Nullable() .WithColumn("IsDeleted").AsBoolean().NotNullable()); }
protected override void CreateEntityColumns(ICreateTableWithColumnSyntax entityTable) { entityTable .WithColumn("UserId").AsInt32() .WithColumn("EmailAddress").AsString(50) .WithColumn("OldEmailAddress").AsString(50) .WithColumn("CallbackToken").AsString(300) .WithColumn("IsActivated").AsBoolean(); }
public static ICreateTableColumnOptionOrWithColumnSyntax WithCommonColumns(this ICreateTableWithColumnSyntax tableWithColumnSyntax) { return(tableWithColumnSyntax .WithIdColumn() .WithColumn("DeletedAt").AsDateTime().Nullable() .WithColumn("IsActive").AsBoolean().NotNullable().WithDefaultValue(true) .WithColumn("CreatedAt").AsDateTime().NotNullable().WithDefault(SystemMethods.CurrentUTCDateTime) .WithColumn("UpdatedAt").AsDateTime().NotNullable().WithDefault(SystemMethods.CurrentUTCDateTime)); }
public static ICreateTableColumnOptionOrWithColumnSyntax WithIdColumn(this ICreateTableWithColumnSyntax tableWithColumnSyntax) { return(tableWithColumnSyntax .WithColumn("Id") .AsInt32() .NotNullable() .PrimaryKey() .Identity()); }
public static ICreateTableWithColumnSyntax CommonFields(this ICreateTableWithColumnSyntax e) { return(e.WithColumn("Remarks").AsString(500).Nullable() .WithColumn("TenantId").AsInt64().Nullable().ForeignKey("Tenant", "Id") .WithColumn("IUserId").AsInt64().Nullable() .WithColumn("EUserId").AsInt64().Nullable() .WithColumn("IDate").AsDateTime().Nullable().WithDefault(SystemMethods.CurrentDateTime) .WithColumn("EDate").AsDateTime().Nullable()); }
public static ICreateTableWithColumnSyntax WithTimeStamps( this ICreateTableWithColumnSyntax table, string columnCreatedAt, string columnUpdatedAt) { return(table .WithColumn(columnCreatedAt).AsDateTime() .WithColumn(columnUpdatedAt).AsDateTime()); }
public static ICreateTableWithColumnSyntax WithColumn( this ICreateTableWithColumnSyntax columnSyntax, string columnName, Func <ICreateTableColumnAsTypeSyntax, ICreateTableWithColumnSyntax> columnOptions ) { var column = columnSyntax.WithColumn(columnName); return(columnOptions.Invoke(column)); }
protected override void CreateEntityColumns(ICreateTableWithColumnSyntax entityTable) { entityTable.WithColumn("Title").AsString(255).NotNullable() .WithColumn("Content").AsString(int.MaxValue).Nullable() .WithColumn("Type").AsInt16().NotNullable() .WithColumn("CreatedBy").AsInt32().NotNullable() .WithColumn("LastRepliedAt").AsDateTime().Nullable() .WithColumn("ReplyCount").AsInt32() .WithColumn("ViewCount").AsInt32(); }
/// <summary> /// Create a foreign columnName to the table <paramref name="primaryTableName"/><br/> /// ------------------------------------------------------------------ <br/> /// If <paramref name="columnName"/> is specified, the new column-name will follow that value<br/> /// If <paramref name="columnName"/> is unspecified, the new column-name will be computed<br/> /// <br/> /// If <paramref name="primaryColumnName"/> is specified, the primary-table-column will follow that value<br/> /// If <paramref name="primaryColumnName"/> is unspecified, the primary-table-column will be computed<br/> /// <br/> /// i.e:<br/> /// <paramref name="columnName"/> is unspecified and <paramref name="primaryTableName"/> is "Parent" => column-name will be computed to "ParentId"<br/> /// <br/> /// <paramref name="primaryColumnName"/> is unspecified => the primary-table-column will be "Id"<br/> /// </summary> /// <param name="syntax"></param> /// <param name="primaryTableName"></param> /// <param name="migration"></param> /// <param name="columnName"></param> /// <param name="primaryColumnName"></param> /// <param name="errors"></param> /// <returns></returns> public static ICreateTableColumnAsTypeSyntax WithForeignKeyColumn( this ICreateTableWithColumnSyntax syntax, string primaryTableName, MigrationModel migration, string columnName = null, string primaryColumnName = null, params int[] errors) { return(syntax.WithForeignKeyColumn(primaryTableName, migration, migration.SchemaPrefixId, columnName, primaryColumnName, errors)); }
public static ICreateTableColumnOptionOrWithColumnSyntax WithColumnForForeignKeyTo <TEntity>( this ICreateTableWithColumnSyntax tableWithColumnSyntax, string columnName = null, bool nullable = false) where TEntity : class, IEntity { var defaultColumnName = ColumnName.ForeignKeyTo <TEntity>(); var columnDefinition = tableWithColumnSyntax.WithColumn(columnName ?? defaultColumnName).AsInt32(); return(nullable ? columnDefinition.Nullable() : columnDefinition.NotNullable()); }
/// <summary> /// Make <paramref name="columnName"/> Nullable /// </summary> /// <param name="syntax"></param> /// <param name="columnName"></param> /// <returns></returns> // ReSharper disable once UnusedMember.Global public static ICreateTableColumnAsTypeSyntax WithNullableColumn(this ICreateTableWithColumnSyntax syntax, string columnName) { var column = syntax.WithColumn(columnName); if (column is CreateTableExpressionBuilder builder) { builder.CurrentColumn.IsNullable = true; } return(column); }
WithTimeStamps(this ICreateTableWithColumnSyntax tableWithColumnSyntax) { return(tableWithColumnSyntax .WithColumn("created_at") .AsDateTime() .NotNullable() .WithColumn("modified_at") .AsDateTime() .NotNullable()); }
public static ICreateTableWithColumnSyntax CreateBaseNoCreateDate(this ICreateTableWithColumnSyntax create, bool userFK = true) { create .WithColumn("Id") .AsInt32() .NotNullable() .Identity() .PrimaryKey(); return(create); }
public static ICreateTableColumnOptionOrWithColumnSyntax WithId( this ICreateTableWithColumnSyntax table, string columnName ) { return(table .WithColumn(columnName) .AsInt32() .NotNullable() .PrimaryKey() .Identity()); }