public static ICreateIndexOnColumnOrInSchemaSyntax OnTableForEntity <TEntity>(this ICreateIndexForTableSyntax root)
where TEntity : class, IEntity
{
var tableName = TableName.ForEntity <TEntity>();
return(root.OnTable(tableName));
}
public static IInsertDataSyntax IntoEntityTable <TEntity>(this IInsertExpressionRoot root, object entity)
where TEntity : class, IEntity
{
var tableName = TableName.ForEntity <TEntity>();
return(root.IntoTable(tableName).Row(entity));
}
public static ICreateTableWithColumnSyntax TableForEntity <TEntity>(this ICreateExpressionRoot root)
where TEntity : class, IEntity
{
var tableName = TableName.ForEntity <TEntity>();
return(root.Table(tableName));
}
public static IAlterTableAddColumnOrAlterColumnOrSchemaOrDescriptionSyntax TableForEntity <TEntity>(this IAlterExpressionRoot root)
where TEntity : class, IEntity
{
var tableName = TableName.ForEntity <TEntity>();
return(root.Table(tableName));
}
public static ICreateForeignKeyCascadeSyntax BetweenEntities <TForeignEntity, TPrimaryEntity>(this ICreateForeignKeyFromTableSyntax root, string foreignColumnName = null)
where TForeignEntity : class, IEntity
where TPrimaryEntity : class, IEntity
{
var foreignTableName = TableName.ForEntity <TForeignEntity>();
foreignColumnName = foreignColumnName ?? ColumnName.ForeignKeyTo <TPrimaryEntity>();
var primaryTableName = TableName.ForEntity <TPrimaryEntity>();
var primaryColumnName = ColumnName.PrimaryKey;
return(root
.FromTable(foreignTableName).ForeignColumn(foreignColumnName)
.ToTable(primaryTableName).PrimaryColumn(primaryColumnName));
}
public static ICreateForeignKeyCascadeSyntax ForeignKey <TFromEntity, TToEntity>(this ICreateExpressionRoot root,
string fromColumnName = null, string toColumnName = "Id")
where TFromEntity : class, IEntity
where TToEntity : class, IEntity
{
var tableFrom = TableName.ForEntity <TFromEntity>();
var tableTo = TableName.ForEntity <TToEntity>();
fromColumnName = fromColumnName ?? $"{tableTo}{ColumnName.PrimaryKey}";
toColumnName = toColumnName ?? ColumnName.PrimaryKey;
return(root
.ForeignKey($"FK_{tableFrom}_{fromColumnName}_{tableTo}_{toColumnName}")
.FromTable(tableFrom)
.ForeignColumn(fromColumnName)
.ToTable(tableTo)
.PrimaryColumn(toColumnName));
}
public static void TableForEntity <TEntity>(this IDeleteExpressionRoot root) where TEntity : class, IEntity
{
var tableName = TableName.ForEntity <TEntity>();
root.Table(tableName);
}
public static string ForeignKeyTo <TEntity>() where TEntity : class, IEntity
{
var tableName = TableName.ForEntity <TEntity>();
return($"{tableName}Id");
}
public static string UniqueOnEnity <TEntity>(params string[] colums)
where TEntity : class, IEntity
{
return($"UX_{TableName.ForEntity<TEntity>()}_{string.Join("_", colums)}");
}
