C# Framework.Column类代码示例

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了C#中Migrator.Framework.Column类的典型用法代码示例。如果您正苦于以下问题：C# Column类的具体用法？C# Column怎么用？C# Column使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。

Column类属于Migrator.Framework命名空间，在下文中一共展示了Column类的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的C#代码示例。

示例1: ChangeColumn

		public override void ChangeColumn(string table, Column column)
		{
			if (!ColumnExists(table, column.Name))
			{
				Logger.Warn("Column {0}.{1} does not exist", table, column.Name);
				return;
			}

		    var existingColumn = GetColumnByName(table, column.Name);
		    
            column.Name = existingColumn.Name; // name might have different case.

			string tempColumn = "temp_" + column.Name;
			RenameColumn(table, column.Name, tempColumn);

			// check if this is not-null
			bool isNotNull = (column.ColumnProperty & ColumnProperty.NotNull) == ColumnProperty.NotNull;

			// remove the not-null option
			column.ColumnProperty = (column.ColumnProperty & ~ColumnProperty.NotNull);

			AddColumn(table, column);
			ExecuteQuery(String.Format("UPDATE {0} SET {1}={2}", table, Dialect.Quote(column.Name), tempColumn));
			RemoveColumn(table, tempColumn);

			// if is not null, set that now
            if (isNotNull) ExecuteQuery(string.Format("ALTER TABLE {0} ALTER COLUMN {1} SET NOT NULL", table, Dialect.Quote(column.Name)));
		}

开发者ID:modulexcite，项目名称:Migrator.NET，代码行数:28，代码来源:PostgreSQLTransformationProvider.cs

示例2: Up

        public override void Up()
        {
            var col = new Column("Url", DbType.String, 255, ColumnProperty.Null);

            foreach (string table in _tables)
                Database.AddColumn(table, col);
        }

开发者ID:robgray，项目名称:f1speedguides，代码行数:7，代码来源:009_AddUrlFieldToTables.cs

示例3: MapColumnProperties

		public override void MapColumnProperties(Column column)
		{
			Name = column.Name;

			indexed = PropertySelected(column.ColumnProperty, ColumnProperty.Indexed);

			var vals = new List<string>();

			AddName(vals);

			AddType(vals);

			AddIdentity(column, vals);

			AddUnsigned(column, vals);

			AddPrimaryKey(column, vals);

			AddIdentityAgain(column, vals);

			AddUnique(column, vals);

			AddForeignKey(column, vals);

			AddDefaultValue(column, vals);

			// null / not-null comes last on Oracle - otherwise if use Null/Not-null + default, bad things happen
			// (http://geekswithblogs.net/faizanahmad/archive/2009/08/07/add-new-columnfield-in-oracle-db-table---ora.aspx)

			AddNotNull(column, vals);

			AddNull(column, vals);

			columnSql = String.Join(" ", vals.ToArray());
		}

开发者ID:modulexcite，项目名称:Migrator.NET，代码行数:35，代码来源:OracleColumnPropertiesMapper.cs

示例4: IndexKeyColumn

        public IndexKeyColumn(Column column, SortDirection sortDirection)
        {
            if (column == null) throw new ArgumentNullException("column");

            Column = column;
            SortDirection = sortDirection;
        }

开发者ID:Inferis，项目名称:KindjesNet，代码行数:7，代码来源:IndexKeyColumn.cs

示例5: MapColumnProperties

        public void MapColumnProperties(Column column)
        {
            Name = column.Name;
            indexed = PropertySelected(column.ColumnProperty, ColumnProperty.Indexed);
            
            List<string> vals = new List<string>();
            vals.Add(dialect.ColumnNameNeedsQuote ? QuotedName : Name);
            
            vals.Add(type);
            
            if (! dialect.IdentityNeedsType)
                AddValueIfSelected(column, ColumnProperty.Identity, vals);
                
            AddValueIfSelected(column, ColumnProperty.Unsigned, vals);
            if (! PropertySelected(column.ColumnProperty, ColumnProperty.PrimaryKey) || dialect.NeedsNotNullForIdentity)
                AddValueIfSelected(column, ColumnProperty.NotNull, vals);
                
            AddValueIfSelected(column, ColumnProperty.PrimaryKey, vals);
            
            if (dialect.IdentityNeedsType)
                AddValueIfSelected(column, ColumnProperty.Identity, vals);
            
            AddValueIfSelected(column, ColumnProperty.Unique, vals);
            AddValueIfSelected(column, ColumnProperty.ForeignKey, vals);

            if (column.DefaultValue != null)
                vals.Add(dialect.Default(column.DefaultValue));

            columnSql = String.Join(" ", vals.ToArray());
        }

开发者ID:jango2015，项目名称:Migrator.NET，代码行数:30，代码来源:ColumnPropertiesMapper.cs

示例6: MapColumnProperties

		public virtual void MapColumnProperties(Column column)
		{
			Name = column.Name;

			indexed = PropertySelected(column.ColumnProperty, ColumnProperty.Indexed);

			var vals = new List<string>();

			AddName(vals);

			AddType(vals);

			AddIdentity(column, vals);

			AddUnsigned(column, vals);

			AddNotNull(column, vals);

			AddNull(column, vals);

			AddPrimaryKey(column, vals);

			AddIdentityAgain(column, vals);

			AddUnique(column, vals);

			AddForeignKey(column, vals);

			AddDefaultValue(column, vals);

			columnSql = String.Join(" ", vals.ToArray());
		}

开发者ID:modulexcite，项目名称:Migrator.NET，代码行数:32，代码来源:ColumnPropertiesMapper.cs

示例7: GetColumnMapper

 public ColumnPropertiesMapper GetColumnMapper(Column column)
 {
     string type = column.Size > 0 ? GetTypeName(column.Type, column.Size) : GetTypeName(column.Type);
     if (! IdentityNeedsType && column.IsIdentity)
         type = String.Empty;
     
     return new ColumnPropertiesMapper(this, type);
 }

开发者ID:wallymathieu，项目名称:Migrator.NET，代码行数:8，代码来源:Dialect.cs

示例8: GetAndMapColumnProperties

 public ColumnPropertiesMapper GetAndMapColumnProperties(Column column)
 {
     ColumnPropertiesMapper mapper = GetColumnMapper(column);
     mapper.MapColumnProperties(column);
     if (column.DefaultValue != null)
         mapper.Default = column.DefaultValue;
     return mapper;
 }

开发者ID:andrewseward，项目名称:migratordotnet，代码行数:8，代码来源:Dialect.cs

示例9: Int32_is_unsigned_compatible

        public void Int32_is_unsigned_compatible()
        {
            //arange
            Column column = new Column("test", DbType.Int32, ColumnProperty.Unsigned);

            //act
            ColumnPropertiesMapper mapper = _dialect.GetAndMapColumnProperties(column);

            //assert
            StringAssert.Contains("UNSIGNED", mapper.ColumnSql);
        }

开发者ID:nats，项目名称:migratordotnet，代码行数:11，代码来源:MysqlDialectTest.cs

示例10: Guid_is_not_unsigned_compatible

        public void Guid_is_not_unsigned_compatible()
        {
            //arrange
            Column column = new Column("test", DbType.Guid, ColumnProperty.Unsigned);

            //act
            ColumnPropertiesMapper mapper = _dialect.GetAndMapColumnProperties(column);

            //assert
            Assert.IsFalse(mapper.ColumnSql.Contains("UNSIGNED"));
        }

开发者ID:nats，项目名称:migratordotnet，代码行数:11，代码来源:MysqlDialectTest.cs

示例11: MergeNameWithStandardFields

 public static Column[] MergeNameWithStandardFields(string indicatedName, Column nameColumn)
 {
     return new[]
     {
         new Column(CreatePrimaryKeyColumnName(indicatedName), DbType.Int32, ColumnProperty.PrimaryKeyWithIdentity),
         nameColumn,
         new Column("Depricated", DbType.Boolean, ColumnProperty.NotNull, 0),
         new Column("IsDeleted", DbType.Boolean, ColumnProperty.Null, 0),
         new Column("CreatedBy", DbType.Int32, ColumnProperty.NotNull),
         new Column("CreatedDate", DbType.DateTime, ColumnProperty.NotNull, "(getdate())")
     };
 }

开发者ID:Aranjedeath，项目名称:SpecimenCode，代码行数:12，代码来源:LookupTableHelper.cs

示例12: ChangeColumn

		public override void ChangeColumn(string table, Column column)
		{
			if (!ColumnExists(table, column.Name))
			{
				Logger.Warn("Column {0}.{1} does not exist", table, column.Name);
				return;
			}

			var existingColumn = GetColumnByName(table, column.Name);
			
			if (column.Type == DbType.String)
			{
				RenameColumn(table, column.Name, TemporaryColumnName);

				// check if this is not-null
				bool isNotNull = (column.ColumnProperty & ColumnProperty.NotNull) == ColumnProperty.NotNull;

				// remove the not-null option
				column.ColumnProperty = (column.ColumnProperty & ~ColumnProperty.NotNull);

				AddColumn(table, column);
				CopyDataFromOneColumnToAnother(table, TemporaryColumnName, column.Name);
				RemoveColumn(table, TemporaryColumnName);
				//RenameColumn(table, TemporaryColumnName, column.Name);
				
				string columnName = QuoteColumnNameIfRequired(column.Name);
				
				// now set the column to not-null
				if (isNotNull) ExecuteQuery(String.Format("ALTER TABLE {0} MODIFY ({1} NOT NULL)", table, columnName));
			}
			else
			{
				if (((existingColumn.ColumnProperty & ColumnProperty.NotNull) == ColumnProperty.NotNull)
					&& ((column.ColumnProperty & ColumnProperty.NotNull) == ColumnProperty.NotNull))
				{
					// was not null, 	and is being change to not-null - drop the not-null all together
					column.ColumnProperty = column.ColumnProperty & ~ColumnProperty.NotNull;
				}
				else if 
					(((existingColumn.ColumnProperty & ColumnProperty.Null) == ColumnProperty.Null)
					&& ((column.ColumnProperty & ColumnProperty.Null) == ColumnProperty.Null))
				{
					// was null, and is being changed to null - drop the null all together
					column.ColumnProperty = column.ColumnProperty & ~ColumnProperty.Null;
				}
			
				ColumnPropertiesMapper mapper = _dialect.GetAndMapColumnProperties(column);

				ChangeColumn(table, mapper.ColumnSql);
			}
		}

开发者ID:rvaccari，项目名称:Migrator.NET，代码行数:51，代码来源:OracleTransformationProvider.cs

示例13: ChangeColumn

		public override void ChangeColumn(string table, Column column)
		{
			if (!ColumnExists(table, column.Name))
			{
				Logger.Warn("Column {0}.{1} does not exist", table, column.Name);
				return;
			}

			string tempColumn = "temp_" + column.Name;
			RenameColumn(table, column.Name, tempColumn);
			AddColumn(table, column);
			ExecuteQuery(String.Format("UPDATE {0} SET {1}={2}", table, column.Name, tempColumn));
			RemoveColumn(table, tempColumn);
		}

开发者ID:Velir，项目名称:Migrator.NET，代码行数:14，代码来源:SQLiteTransformationProvider.cs

示例14: Up

        public override void Up()
        {
            Column[] columns = new Column[]
                                   {
                                       new Column("Id", DbType.Int32, ColumnProperty.PrimaryKeyWithIdentity),
                                       new Column("TaskId", DbType.Int32,
                                                  ColumnProperty.ForeignKey | ColumnProperty.NotNull),
                                       new Column("Estimate", DbType.Double, ColumnProperty.NotNull),
                                       new Column("Timestamp", DbType.DateTime, ColumnProperty.NotNull)
                                   };

            Database.AddTable("TaskEstimateHistory", columns);
            Database.AddForeignKey("FK_TaskEstimateHistory_Task", "TaskEstimateHistory", "TaskId", "Tasks", "Id", ForeignKeyConstraint.Cascade);
        }

开发者ID:browsk，项目名称:juice，代码行数:14，代码来源:006_AddTaskEstimateHistoryTabls.cs

示例15: Up

 public override void Up()
 {
     Column[] columns = new Column[]
                            {
                                new Column("Id", DbType.Int32, ColumnProperty.PrimaryKeyWithIdentity),
                                new Column("Name", DbType.String, 255, ColumnProperty.NotNull),
                                new Column("Description", DbType.String),
                                new Column("BusinessValue", DbType.Int32),
                                new Column("Priority", DbType.Int32),
                                new Column("Estimate", DbType.Int32),
                                new Column("ProjectId", DbType.Int32, ColumnProperty.ForeignKey | ColumnProperty.NotNull),
                            };
     Database.AddTable("Stories", columns);
     Database.AddForeignKey("FK_Stories_Project", "Stories", "ProjectId", "Projects", "Id", ForeignKeyConstraint.Cascade);
 }

开发者ID:browsk，项目名称:juice，代码行数:15，代码来源:004_AddStoriesTable.cs

示例16: MapColumnProperties

        public void MapColumnProperties(Column column)
        {
            Name = column.Name;
            indexed = PropertySelected(column.ColumnProperty, ColumnProperty.Indexed);

            List<string> vals = new List<string>();
            vals.Add(dialect.ColumnNameNeedsQuote ? QuotedName : Name);

            vals.Add(type);

            if(!string.IsNullOrEmpty(column.Collation))
            {
                if(new DbType[] { DbType.String, DbType.StringFixedLength, DbType.AnsiString, DbType.AnsiStringFixedLength }.Contains(column.Type))
                {
                    vals.Add(dialect.AddCollation(column.Collation));
                }
            }

            if(!dialect.IdentityNeedsType)
                AddValueIfSelected(column, ColumnProperty.Identity, vals);

            AddValueIfSelected(column, ColumnProperty.Unsigned, vals);
            if(!PropertySelected(column.ColumnProperty, ColumnProperty.PrimaryKey) || dialect.NeedsNotNullForIdentity)
            {
                AddValueIfSelected(column, ColumnProperty.NotNull, vals);
            }
            else
            {
                AddValueIfSelected(column, ColumnProperty.Null, vals);
            }

            AddValueIfSelected(column, ColumnProperty.PrimaryKey, vals);

            if(dialect.IdentityNeedsType)
                AddValueIfSelected(column, ColumnProperty.Identity, vals);

            AddValueIfSelected(column, ColumnProperty.Unique, vals);
            AddValueIfSelected(column, ColumnProperty.ForeignKey, vals);

            if(column.DefaultValue != null)
                vals.Add(dialect.Default(column.DefaultValue));

            columnSql = String.Join(" ", vals.ToArray());
        }

开发者ID:mmsommer，项目名称:OGD.Database.Migrator.Net，代码行数:44，代码来源:ColumnPropertiesMapper.cs

示例17: GetColumns

		public virtual Column[] GetColumns(string table)
		{
			var columns = new List<Column>();
			using (
				IDataReader reader =
					ExecuteQuery(
						String.Format("select COLUMN_NAME, IS_NULLABLE from INFORMATION_SCHEMA.COLUMNS where table_name = '{0}'", table)))
			{
				while (reader.Read())
				{
					var column = new Column(reader.GetString(0), DbType.String);
					string nullableStr = reader.GetString(1);
					bool isNullable = nullableStr == "YES";
					column.ColumnProperty |= isNullable ? ColumnProperty.Null : ColumnProperty.NotNull;

					columns.Add(column);
				}
			}

			return columns.ToArray();
		}

开发者ID:eliog，项目名称:Migrator.NET，代码行数:21，代码来源:TransformationProvider.cs

示例18: ChangeColumn

        public override void ChangeColumn(string table, Column column)
        {
            if (!ColumnExists(table, column.Name))
            {
                Logger.Warn("Column {0}.{1} does not exist", table, column.Name);
                return;
            }

            var tempColumn = new Column("temp_" + column.Name)
                             {
                                 ColumnProperty = column.ColumnProperty,
                                 DefaultValue = column.DefaultValue ?? null,
                                 Size = column.Size,
                                 Type = column.Type
                             };

            AddColumn(table, tempColumn);
            ExecuteQuery(String.Format("UPDATE {0} SET {1}={2}", table, tempColumn.Name, column.Name));
            RemoveColumn(table, column.Name);
            RenameColumn(table, tempColumn.Name, column.Name);
        }

开发者ID:Odyl，项目名称:MigratorDotNet，代码行数:21，代码来源:PostgreSQLTransformationProvider.cs

示例19: GetColumns

        // XXX: Using INFORMATION_SCHEMA.COLUMNS should work, but it was causing trouble, so I used the MySQL specific thing.
        public override Column[] GetColumns(string table)
        {
            List<Column> columns = new List<Column>();
            using (
                IDataReader reader =
                    ExecuteQuery(
                        String.Format("SHOW COLUMNS FROM {0}", table)))
            {
                while (reader.Read())
                {
                    Column column = new Column(reader.GetString(0), DbType.String);
                    string nullableStr = reader.GetString(2);
                    bool isNullable = nullableStr == "YES";
                    column.ColumnProperty |= isNullable ? ColumnProperty.Null : ColumnProperty.NotNull;

                    columns.Add(column);
                }
            }

            return columns.ToArray();
        }

开发者ID:jango2015，项目名称:Migrator.NET，代码行数:22，代码来源:MySqlTransformationProvider.cs

示例20: AddColumn

			}
		}

		public void AddColumn(string table, Column column)

开发者ID:asynchrony，项目名称:Migrator.NET，代码行数:4，代码来源:TransformationProvider.cs

注：本文中的Migrator.Framework.Column类示例由纯净天空整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

C# Framework.ForeignKeyConstraint类代码示例发布时间：2022-05-26

C# DocumentObjectModel.DocumentObject类代码示例发布时间：2022-05-26

剪的笔顺,诠释剪的笔画,认识剪的部首

1 六六分期app的软件客服如何联系？(六六分期

六六分期app的软件客服如何联系？不知道吗？加qq群【895510560】即可！标题：六六分期

阅读：18277|2023-10-27

2 可心卡盟:win10系统火狐flash插件崩溃怎么

今天小编告诉大家如何处理win10系统火狐flash插件总是崩溃的问题，可能很多用户都不知

阅读：9677|2022-11-06

3 亲亲特价:怎么删除回收站图标

今天小编告诉大家如何对win10系统删除桌面回收站图标进行设置，可能很多用户都不知道

阅读：8179|2022-11-06

4 济南大学虚拟社区:鲁大师节能降温的具体办

今天小编告诉大家如何对win10系统电脑设置节能降温的设置方法，想必大家都遇到过需要

阅读：8549|2022-11-06

5 xlueops.exe:无线网络安装向导

我们在使用xp系统的过程中,经常需要对xp系统无线网络安装向导设置进行设置，可能很多

阅读：8457|2022-11-06

6 女斗合众国:win7系统cf与主机连接不稳定怎

今天小编告诉大家如何处理win7系统玩cf老是与主机连接不稳定的问题，可能很多用户都不

阅读：9393|2022-11-06

7 0xc000022-[cf烟雾头]cf怎么调烟雾头

电脑对日常生活的重要性小编就不多说了，可是一旦碰到win7系统设置cf烟雾头的问题，很

阅读：8430|2022-11-06

8 qizideyouhuo:应用程序无法正常启动0xc0000

我们在日常使用电脑的时候，有的小伙伴们可能在打开应用的时候会遇见提示应用程序无法

阅读：7865|2022-11-06

9 ipz-185:win7系统vcf文件怎么打开

今天小编告诉大家如何对win7系统打开vcf文件进行设置，可能很多用户都不知道怎么对win

阅读：8416|2022-11-06

10 傻哥蹦迪:win10系统s4怎么打开usb调试

今天小编告诉大家如何对win10系统s4开启USB调试模式进行设置，可能很多用户都不知道怎

阅读：7394|2022-11-06

客服电话

电子邮件

C# Framework.Column类代码示例

示例1: ChangeColumn

示例2: Up

示例3: MapColumnProperties

示例4: IndexKeyColumn

示例5: MapColumnProperties

示例6: MapColumnProperties

示例7: GetColumnMapper

示例8: GetAndMapColumnProperties

示例9: Int32_is_unsigned_compatible

示例10: Guid_is_not_unsigned_compatible

示例11: MergeNameWithStandardFields

示例12: ChangeColumn

示例13: ChangeColumn

示例14: Up

示例15: Up

示例16: MapColumnProperties

示例17: GetColumns

示例18: ChangeColumn

示例19: GetColumns

示例20: AddColumn

请发表评论

全部评论

上一篇：

下一篇：

librespeed/speedtest: Self-hosted Speedt

CVE-2022-2415

avehtari/BDA_m_demos: Bayesian Data Anal

四维彩超怎么看性别？四维看男孩女孩诀窍

右的笔顺,诠释右的笔画,关于右的部首

剪的笔顺,诠释剪的笔画,认识剪的部首

六六分期app的软件客服如何联系？(六六分期

florent37/ViewAnimator: A fluent Android

florent37/Shrine-MaterialDesign2: implem

CVE-2020-36276

SimpleSoftwareIO/simple-sms: Send and re

关于我们

产品与服务

解决方案

139-2527-9053