-
Notifications
You must be signed in to change notification settings - Fork 34
/
ICreatedTableWithAddedColumn.cs
75 lines (66 loc) · 2.95 KB
/
ICreatedTableWithAddedColumn.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
using MigSharp.Providers;
namespace MigSharp
{
/// <summary>
/// Represents a column on a newly created table.
/// </summary>
public interface ICreatedTableWithAddedColumn : ICreatedTableBase
{
/// <summary>
/// Gets the column name.
/// </summary>
string ColumnName { get; }
/// <summary>
/// Specifies the size and the scale of the data type of the column.
/// </summary>
/// <param name="size">The length for character data types or the maximum total number of decimal digits for numeric data types.</param>
/// <param name="scale">The maximum number of decimal digits that can be stored to the right of the decimal point. Scale must be a value from 0 through <paramref name="size"/>.</param>
ICreatedTableWithAddedColumn OfSize(int size, int scale);
/// <summary>
/// Puts the column under an unique constraint.
/// </summary>
/// <param name="constraintName">Optionally, specify the name of the unique constraint. If null or empty, a default constraint name will be generated.</param>
ICreatedTableWithAddedColumn Unique(string constraintName);
/// <summary>
/// Makes the column auto-increment.
/// </summary>
ICreatedTableWithAddedColumn AsIdentity();
/// <summary>
/// Adds a default value to the column.
/// </summary>
ICreatedTableWithAddedColumn HavingDefault<T>(T value) where T : struct;
/// <summary>
/// Adds a default value to the column.
/// </summary>
ICreatedTableWithAddedColumn HavingDefault(string value);
}
/// <summary>
/// Contains the extensions methods for the <see cref="ICreatedTableWithAddedColumn"/> interface.
/// </summary>
public static class CreatedTableWithAddedColumnExtensions
{
/// <summary>
/// Specifies the size of the data type of the column.
/// </summary>
/// <param name="column"></param>
/// <param name="size">The length for character data types or the maximum total number of decimal digits for numeric data types.</param>
public static ICreatedTableWithAddedColumn OfSize(this ICreatedTableWithAddedColumn column, int size)
{
return column.OfSize(size, 0);
}
/// <summary>
/// Puts the column under an unique constraint with a default constraint name.
/// </summary>
public static ICreatedTableWithAddedColumn Unique(this ICreatedTableWithAddedColumn column)
{
return column.Unique(null);
}
/// <summary>
/// Sets the default of the column to be the current system time of the database server.
/// </summary>
public static ICreatedTableWithAddedColumn HavingCurrentDateTimeAsDefault(this ICreatedTableWithAddedColumn column)
{
return column.HavingDefault(SpecialDefaultValue.CurrentDateTime);
}
}
}