C# (CSharp) MigSharp.Providers RecordingProvider.CreateTable Examples

CreateTable() private method

private CreateTable ( TableName tableName, IEnumerable columns, string primaryKeyConstraintName ) : IEnumerable
tableName	MigSharp.Core.TableName
columns	IEnumerable
primaryKeyConstraintName	string
return	IEnumerable

Example #1

File: RecordingProviderTests.cs Project: dradovic/MigSharp

 public void VerifyNewObjectNamesAreRecorded()
 {
     var provider = new RecordingProvider();
     // ReSharper disable ReturnValueOfPureMethodIsNotUsed : needed to force enumeration
     provider.CreateTable(new TableName("Table", null), new[] { new CreatedColumn("Column", new DataType(DbType.Boolean), false, true, string.Empty, false, null, false) }, "MyPK").ToList();
     // ReSharper restore ReturnValueOfPureMethodIsNotUsed
     CollectionAssert.AreEquivalent(new[] { "Table", "Column", "MyPK" }, provider.NewObjectNames.ToList());
 }

Example #2

File: RecordingProviderTests.cs Project: nachojammers/MigSharp

 public void VerifyDateTypesAreRecorded()
 {
     var provider = new RecordingProvider();
     provider.CreateTable("Table", new[]
     {
         new CreatedColumn("Primary Key Column", new DataType(DbType.Int32, 0, 0), false, true, string.Empty, false, null),
         new CreatedColumn("Identity Column", new DataType(DbType.Int64, 0, 0), false, false, string.Empty, true, null),
         new CreatedColumn("Column", new DataType(DbType.String, 0, 0), false, false, string.Empty, false, null),
     }, "MyPK").ToList();
     CollectionAssert.AreEquivalent(new[]
     {
         new UsedDataType(new DataType(DbType.Int32, 0, 0), true, false),
         new UsedDataType(new DataType(DbType.Int64, 0, 0), false, true),
         new UsedDataType(new DataType(DbType.String, 0, 0), false, false),
     }, provider.DataTypes.ToList());
 }

Example #3

File: RecordingProviderTests.cs Project: dradovic/MigSharp

 public void VerifyDateTypesAreRecorded()
 {
     var provider = new RecordingProvider();
     provider.CreateTable(new TableName("Table", null), new[]
     {
         new CreatedColumn("Primary Key Column", new DataType(DbType.Int32), false, true, string.Empty, false, null, false),
         new CreatedColumn("Identity Column", new DataType(DbType.Int64), false, false, string.Empty, true, null, false),
         new CreatedColumn("Column", new DataType(DbType.String, 10), false, false, string.Empty, false, null, false),
     // ReSharper disable ReturnValueOfPureMethodIsNotUsed : needed to force enumeration
     }, "MyPK").ToList();
     // ReSharper restore ReturnValueOfPureMethodIsNotUsed
     CollectionAssert.AreEquivalent(new[]
     {
         new UsedDataType(new DataType(DbType.Int32), true, false),
         new UsedDataType(new DataType(DbType.Int64), false, true),
         new UsedDataType(new DataType(DbType.String, 10), false, false),
     }, provider.DataTypes.ToList());
 }

Example #4

File: RecordingProviderTests.cs Project: nachojammers/MigSharp

 public void VerifyNewObjectNamesAreRecorded()
 {
     var provider = new RecordingProvider();
     provider.CreateTable("Table", new[] { new CreatedColumn("Column", new DataType(DbType.Boolean, 0, 0), false, true, string.Empty, false, null) }, "MyPK").ToList();
     CollectionAssert.AreEquivalent(new[] { "Table", "Column", "MyPK" }, provider.NewObjectNames.ToList());
 }