• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    公众号

C# ColumnSchema类代码示例

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

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



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

示例1: GetSchema

        public DbSchema GetSchema()
        {
            var schema = new DbSchema();
            var map = _configuration.BuildMapping();
            var mappings = _configuration.ClassMappings;

            foreach(var class_map in mappings)
            {
                var table = class_map.Table;
                var table_schema = new TableSchema() {TableName = table.Name, SchemaName = table.Schema};
                foreach (var column in table.ColumnIterator)
                {

                    var type_code = column.GetSqlTypeCode(map);

                    var columnSchema = new ColumnSchema()
                                           {
                                               TableName = table_schema.TableName,
                                               ColumnName = column.Name,
                                               IsNullable = column.IsNullable,
                                               DatabaseType = type_code.DbType,
                                               Size = column.Length,
                                               Scale = column.Scale,
                                               Precision = column.Precision,
                                               IsPrimaryKey = table.PrimaryKey.Columns.Contains(column)
                                           };

                    // columnSchema.DatabaseType = property.GetSqlTypeCode(map).DbType;
                    table_schema.AddColumn(columnSchema);
                }
                schema.AddTable(table_schema);
            }
            return schema;
        }
开发者ID:jcteague,项目名称:SchemaMigrator,代码行数:34,代码来源:NhibernateSchemaBuilder.cs


示例2: BuildAlterColumnCommand

 public override string BuildAlterColumnCommand(ColumnSchema schema)
 {
     string sql = String.Format(
     @"ALTER TABLE {0} ALTER COLUMN {1}",
         Api.CommandBuilder.QuoteIdentifier(schema.TableName),
         ColumnSqlCommand(schema)
     );
     return sql;
 }
开发者ID:Kuick,项目名称:Kuicker,代码行数:9,代码来源:SqlClientBuilder.cs


示例3: GetColumnSize

    public string GetColumnSize(ColumnSchema column)
    {
        string columnSize = column.Size.ToString();

        if (column.NativeType == "numeric" && column.Precision != 0)
        {
            columnSize += "(" + column.Precision.ToString() + "," + column.Scale + ")";
        }

        return columnSize;
    }
开发者ID:mattfrerichs,项目名称:Templates,代码行数:11,代码来源:DBDocumenterTemplate.cs


示例4: GetPropertyName

        public string GetPropertyName(ColumnSchema column)
        {
            string propertyName = column.Name;

            if (propertyName == column.Table.Name + "Name") return "Name";
            if (propertyName == column.Table.Name + "Description") return "Description";

            if (propertyName.EndsWith("TypeCode")) propertyName = propertyName.Substring(0, propertyName.Length - 4);

            return propertyName;
        }
开发者ID:mattfrerichs,项目名称:Templates,代码行数:11,代码来源:TypedDataSet.cst.cs


示例5: GetPropertyNameFromColumn

 /// <summary>
 /// Helper for class generation from tables, converts a column name into a Property Name
 /// </summary>
 /// <param name="column"> Column to be converted</param>
 /// <param name="prefix">Add characters to column</param>
 /// <param name="strip">remove characters from column</param>
 /// <returns>string</returns>
 public static string GetPropertyNameFromColumn(ColumnSchema column, string prefix, string strip)
 {
     if (strip != string.Empty)
     {
         return prefix + column.Name.Replace(strip, "").ToCSharpIdentifier().ToPascalCase();
     }
     else
     {
         return prefix + column.Name.ToCSharpIdentifier().ToPascalCase();
     }
 }
开发者ID:smacinn,项目名称:CodeSmithHelper,代码行数:18,代码来源:DB.cs


示例6: GetReaderMethod

 public string GetReaderMethod(ColumnSchema column)
 {
     switch (column.DataType)
     {
         case DbType.Byte:
         {
             return "GetByte";
         }
         case DbType.Int16:
         {
             return "GetInt16";
         }
         case DbType.Int32:
         {
             return "GetInt32";
         }
         case DbType.Int64:
         {
             return "GetInt64";
         }
         case DbType.AnsiStringFixedLength:
         case DbType.AnsiString:
         case DbType.String:
         case DbType.StringFixedLength:
         {
             return "GetString";
         }
         case DbType.Boolean:
         {
             return "GetBoolean";
         }
         case DbType.Guid:
         {
             return "GetGuid";
         }
         case DbType.Currency:
         case DbType.Decimal:
         {
             return "GetDecimal";
         }
         case DbType.DateTime:
         case DbType.Date:
         {
             return "GetDateTime";
         }
         default:
         {
             return "__SQL__" + column.DataType;
         }
     }
 }
开发者ID:mattfrerichs,项目名称:Templates,代码行数:51,代码来源:TypedDataSet.cst.cs


示例7: IsChildFKColumn

 public static bool IsChildFKColumn(ColumnSchema column, TableSchema table)
 {
     foreach (ReferenceSchema inReference in table.InReferences)
     {
         foreach (ReferenceJoin join in inReference.Joins)
         {
             //Found the child Column...
             if (join.ChildColumn.ObjectID == column.ObjectID)
             {
                 return true;
             }
         }
     }
     return false;
 }
开发者ID:brendankowitz,项目名称:systembusinessobjects,代码行数:15,代码来源:Helper.cs


示例8: GetCSharpTypeFromDBFieldType

	public string GetCSharpTypeFromDBFieldType(ColumnSchema column)
	{
		if (column.Name.EndsWith("TypeCode")) return column.Name;
		string type;
		switch (column.DataType)
		{
			case DbType.AnsiString: type= "string";break;
			case DbType.AnsiStringFixedLength: type= "string";break;
			case DbType.Binary: type= "byte[]";break;
			case DbType.Boolean: type= "bool";break;
			case DbType.Byte: type= "byte";break;
			case DbType.Currency: type= "decimal";break;
			case DbType.Date: type= "DateTime";break;
			case DbType.DateTime: type= "DateTime";break;
			case DbType.Decimal: type= "decimal";break;
			case DbType.Double: type= "double";break;
			case DbType.Guid: type= "Guid";break;
			case DbType.Int16: type= "short";break;
			case DbType.Int32: type= "int";break;
			case DbType.Int64: type= "long";break;
			case DbType.Object: type= "object";break;
			case DbType.SByte: type= "sbyte";break;
			case DbType.Single: type= "float";break;
			case DbType.String: type= "string";break;
			case DbType.StringFixedLength: type= "string";break;
			case DbType.Time: type= "TimeSpan";break;
			case DbType.UInt16: type= "ushort";break;
			case DbType.UInt32: type= "uint";break;
			case DbType.UInt64: type= "ulong";break;
			case DbType.VarNumeric: type= "decimal";break;
			default:
			{
				type= "__UNKNOWN__" + column.NativeType;
				break;
			}
		}
		if(column.AllowDBNull&&
			column.SystemType.IsValueType)
		{
			type=type+"?";
		}
		return type;
	}
开发者ID:cityjoy,项目名称:DapperCodeSmith,代码行数:43,代码来源:ToolsCodeTemplate.cs


示例9: GetConvertToNETType

 public static string GetConvertToNETType(ColumnSchema  column, string strExpression)
 {
     switch (column.NetDataType)
     {
         case "System.Int32":
             return "Convert.ToInt32(" + strExpression + ")";
         case "System.Byte":
             return "Convert.ToByte(" + strExpression + ")";
         case "System.Boolean":
             return "Convert.ToBoolean(" + strExpression + ")";
         case "System.Char":
             return "Convert.ToChar(" + strExpression + ")";
         case "System.DateTime":
             return "Convert.ToDateTime(" + strExpression + ")";
         case "System.Decimal":
             return "Convert.ToDecimal(" + strExpression + ")";
         case "System.Double":
             return "Convert.ToDouble(" + strExpression + ")";
         case "System.Int16":
             return "Convert.ToInt16(" + strExpression + ")";
         case "System.Int64":
             return "Convert.ToInt64(" + strExpression + ")";
         case "System.SByte":
             return "Convert.ToSByte(" + strExpression + ")";
         case "System.Single":
             return "Convert.ToSingle(" + strExpression + ")";
         case "System.TimeSpan":
             return "Convert.ToDateTime(" + strExpression + ")";
         case "System.UInt16":
             return "Convert.ToUInt16(" + strExpression + ")";
         case "System.UInt32":
             return "Convert.ToUInt32(" + strExpression + ")";
         case "System.UInt64":
             return "Convert.ToUInt64 (" + strExpression + ")";
         case "System.Guid":
             return "Convert.ToString(" + strExpression + ")";
         case "System.Byte[]":
             return "(Byte[])(" + strExpression + ")";
         default:
             return "Convert.ToString(" + strExpression + ")";
     }
 }
开发者ID:martinherr3,项目名称:medusa,代码行数:42,代码来源:Helper.cs


示例10: ExtractType

 private string ExtractType(ColumnSchema schema)
 {
     var rez = schema.DataType;
     if (!string.IsNullOrEmpty(schema.CharacterMaximumLength))
     {
         rez = rez + "(" + (schema.CharacterMaximumLength == "-1"
                                ? "max"
                                : schema.CharacterMaximumLength) + ")";
         return rez;
     }
     if (!string.IsNullOrEmpty(schema.NumericPrecision))
     {
         rez = rez + "(" + schema.NumericPrecision;
         if (!string.IsNullOrEmpty(schema.NumericScale))
         {
             rez = rez + "," + schema.NumericScale;
         }
         return rez + ")";
     }
     return rez;
 }
开发者ID:gmav,项目名称:SqlFu,代码行数:21,代码来源:SqlServerCompactModifiedColumnsWriter.cs


示例11: GetMemberVariableDefaultValue

 public string GetMemberVariableDefaultValue(ColumnSchema column)
 {
     switch (column.DataType)
     {
         case DbType.Guid:
         {
             return "Guid.Empty";
         }
         case DbType.AnsiString:
         case DbType.AnsiStringFixedLength:
         case DbType.String:
         case DbType.StringFixedLength:
         {
             return "String.Empty";
         }
         default:
         {
             return "";
         }
     }
 }
开发者ID:mattfrerichs,项目名称:Templates,代码行数:21,代码来源:TypedDataSet.cst.cs


示例12: GetColumns

 public override IList<ColumnSchema> GetColumns(System.Data.Common.DbConnectionStringBuilder connectionstr, string tablename)
 {
     IList<ColumnSchema> list = null;
     using (MySqlConnection connection = new MySqlConnection(connectionstr.ConnectionString))
     {
         connection.Open();
         DataTable columns = connection.GetSchema(SqlClientMetaDataCollectionNames.Columns, new string[] { null, null, tablename, null });
         if (columns != null && columns.Rows.Count > 0)
         {
             list = new List<ColumnSchema>();
             DataView dv = columns.DefaultView;
             dv.Sort = "ORDINAL_POSITION asc";
             foreach (DataRowView table in dv)
             {
                 string name = string.Format("{0}({1})", table["COLUMN_NAME"], table["DATA_TYPE"]);
                 ColumnSchema column = new ColumnSchema(name);
                 list.Add(column);
             }
         }
     }
     return list;
 }
开发者ID:Tony-Liang,项目名称:Common,代码行数:22,代码来源:MySqlProvider.cs


示例13: GetConvert

 public string GetConvert(ColumnSchema column)
 {
     if (column.Name.EndsWith("TypeCode")) return column.Name;
     
     switch (column.DataType)
     {
         case DbType.AnsiString: return "Convert.ToString";
         case DbType.AnsiStringFixedLength: return "Convert.ToString";
         case DbType.Binary: return "Convert.ToByte";
         case DbType.Boolean: return "Convert.ToBoolean";
         case DbType.Byte: return "Convert.ToInt32";
         case DbType.Currency: return "Convert.ToDecimal";
         case DbType.Date: return "Convert.ToDateTime";
         case DbType.DateTime: return "Convert.ToDateTime";
         case DbType.Decimal: return "Convert.ToDecimal";
         case DbType.Double: return "Convert.ToDouble";
         case DbType.Guid: return "Convert.ToString";
         case DbType.Int16: return "Convert.ToInt16";
         case DbType.Int32: return "Convert.ToInt32";
         case DbType.Int64: return "Convert.ToInt64";
         case DbType.Object: return "Convert.ToString";
         case DbType.SByte: return "Convert.ToByte";
         case DbType.Single: return "Convert.ToInt32";
         case DbType.String: return "Convert.ToString";
         case DbType.StringFixedLength: return "Convert.ToString";
         case DbType.Time: return "Convert.DateTime";
         case DbType.UInt16: return "Convert.ToUInt16";
         case DbType.UInt32: return "Convert.ToUInt32";
         case DbType.UInt64: return "Convert.ToUInt64";
         case DbType.VarNumeric: return "Convert.ToDecimal";
         default:
         {
             return "__UNKNOWN__" + column.NativeType;
         }
     }
 }
开发者ID:cityjoy,项目名称:DapperCodeSmith,代码行数:36,代码来源:ToolsCodeTemplate.cs


示例14: GetCSharpConvert

        public static string GetCSharpConvert(ColumnSchema column, string placeholder)
        {
            if (column.Name.EndsWith("TypeCode")) return column.Name;

            switch (column.DataType)
            {
                case DbType.AnsiString: return placeholder;
                case DbType.AnsiStringFixedLength: return placeholder;
                //case DbType.Binary: return "byte []";
                case DbType.Boolean: return "Convert.ToBoolean(" + placeholder + ");";
                case DbType.Byte: return "Convert.ToByte(" + placeholder + ")";
                case DbType.Currency: return "Convert.ToDecimal(" + placeholder + ")";
                case DbType.Date: return placeholder;
                case DbType.DateTime: return placeholder;
                case DbType.Decimal: return "Convert.ToDecimal(" + placeholder + ")";
                case DbType.Double: return "Convert.ToDouble(" + placeholder + ")";
                case DbType.Guid: return placeholder;
                case DbType.Int16: return "Convert.ToInt16(" + placeholder + ")";
                case DbType.Int32: return "Convert.ToInt32(" + placeholder + ")";
                case DbType.Int64: return "Convert.ToInt64(" + placeholder + ")";
                case DbType.Object: return placeholder;
                case DbType.SByte: return "Convert.ToSByte(" + placeholder + ")";
                case DbType.Single: return "Convert.ToFloat(" + placeholder + ")";
                case DbType.String: return placeholder;
                case DbType.StringFixedLength: return placeholder;
                case DbType.Time: return "TimeSpan";
                case DbType.UInt16: return "Convert.ToUInt16(" + placeholder + ")";
                case DbType.UInt32: return "Convert.ToUInt32(" + placeholder + ")";
                case DbType.UInt64: return "Convert.ToUInt64(" + placeholder + ")";
                case DbType.VarNumeric: return "Convert.ToDecimal(" + placeholder + ")";
                default:
                    {
                        return "__UNKNOWN__" + column.NativeType;
                    }
            }
        }
开发者ID:smacinn,项目名称:CodeSmithHelper,代码行数:36,代码来源:CSharp.cs


示例15: GetCSharpVariableType

        public static string GetCSharpVariableType(ColumnSchema column)
        {
            if (column.Name.EndsWith("TypeCode")) return column.Name;

            switch (column.DataType)
            {
                case DbType.AnsiString: return "string";
                case DbType.AnsiStringFixedLength: return "string";
                case DbType.Binary: return "byte []";
                case DbType.Boolean: return "bool";
                case DbType.Byte: return "byte";
                case DbType.Currency: return "decimal";
                case DbType.Date: return "DateTime";
                case DbType.DateTime: return "DateTime";
                case DbType.Decimal: return "decimal";
                case DbType.Double: return "double";
                case DbType.Guid: return "Guid";
                case DbType.Int16: return "short";
                case DbType.Int32: return "int";
                case DbType.Int64: return "long";
                case DbType.Object: return "object";
                case DbType.SByte: return "sbyte";
                case DbType.Single: return "float";
                case DbType.String: return "string";
                case DbType.StringFixedLength: return "string";
                case DbType.Time: return "TimeSpan";
                case DbType.UInt16: return "ushort";
                case DbType.UInt32: return "uint";
                case DbType.UInt64: return "ulong";
                case DbType.VarNumeric: return "decimal";
                default:
                    {
                        return "__UNKNOWN__" + column.NativeType;
                    }
            }
        }
开发者ID:smacinn,项目名称:CodeSmithHelper,代码行数:36,代码来源:CSharp.cs


示例16: IsIdentity

    public bool IsIdentity(ColumnSchema column)
    {
        if((bool)column.ExtendedProperties["CS_IsIdentity"].Value) 
		{
			return true;
		}
        else
        {
            return false;
        }
    }
开发者ID:cityjoy,项目名称:DapperCodeSmith,代码行数:11,代码来源:ToolsCodeTemplate.cs


示例17: GetDefaultValue

 public string GetDefaultValue(ColumnSchema column)
 {
     if (column.Name.EndsWith("TypeCode")) return column.Name;
     switch (column.DataType)
     {
         case DbType.AnsiString: return "\"\"";
         case DbType.AnsiStringFixedLength: return "\"\"";
         case DbType.Binary: return "null";
         case DbType.Boolean: return "false";
         case DbType.Byte: return "0";
         case DbType.Currency: return "0";
         case DbType.Date: return "DateTime.Parse(\"1900-1-1\")";
         case DbType.DateTime: return "DateTime.Parse(\"1900-1-1\")";
         case DbType.Decimal: return "0";
         case DbType.Double: return "0";
         case DbType.Guid: return "Guid.NewGuid().ToString()";
         case DbType.Int16: return "0";
         case DbType.Int32: return "0";
         case DbType.Int64: return "0";
         case DbType.Object: return "\"\"";
         case DbType.SByte: return "0";
         case DbType.Single: return "0";
         case DbType.String: return "\"\"";
         case DbType.StringFixedLength: return "";
         case DbType.Time: return "DateTime.Parse(\"1900-1-1\")";
         case DbType.UInt16: return "0";
         case DbType.UInt32: return "0";
         case DbType.UInt64: return "0";
         case DbType.VarNumeric: return "0";
         default:
         {
         return "__UNKNOWN__" + column.NativeType;
         }
     }
 }
开发者ID:cityjoy,项目名称:DapperCodeSmith,代码行数:35,代码来源:ToolsCodeTemplate.cs


示例18: GetTableColumns

		public ColumnSchema[] GetTableColumns(string connectionString, TableSchema table)
		{
			if (_cachedConnectionString != connectionString)
			{
				_cachedConnectionString = connectionString;
				_doc.Load(connectionString);
			}
			XmlNodeList columns = _doc.SelectNodes("dcl:schema/dcl:table[@name='" + table.Name + "']/dcl:column", _manager);
			int columnCount = columns.Count;
			ColumnSchema[] ret = new ColumnSchema[columnCount];
			for (int i = 0; i < columnCount; ++i)
			{
				byte precision = 0;
				int size = -1, scale = 0;
				string nativeDataType = "", columnName = "";
				DbType dbType = 0;
				bool isNullable = false;

				XmlNode currentColumn = columns[i];
				XmlAttribute columnNameNode = currentColumn.Attributes["name"];
				if (columnNameNode != null)
				{
					columnName = columnNameNode.Value.Trim('\"').Replace("\"\"", "\"");
				}

				XmlAttribute isNullableNode = currentColumn.Attributes["isNullable"];
				if (isNullableNode != null)
				{
					isNullable = bool.Parse(isNullableNode.Value);
				}

				XmlNode predefinedDataTypeNode = currentColumn.SelectSingleNode("dcl:predefinedDataType", _manager);
				if (predefinedDataTypeNode == null)
				{
					XmlNode refNameNode = currentColumn.SelectSingleNode("dcl:domainRef/@name", _manager);
					if (refNameNode != null)
					{
						string refName = refNameNode.Value;
						predefinedDataTypeNode = currentColumn.SelectSingleNode("dcl:schema/dcl:domain[@name='" + refName +"']/dcl:predefinedDataType", _manager);
					}
				}
				if (predefinedDataTypeNode != null)
				{
					XmlAttribute nativeDataTypeNode = predefinedDataTypeNode.Attributes["name"];
					if (nativeDataTypeNode != null)
					{
						nativeDataType = nativeDataTypeNode.Value.ToLower();
					}

					switch (nativeDataType.ToUpper())
					{
						case "CHARACTER LARGE OBJECT":
						case "BINARY LARGE OBJECT":
							dbType = DbType.Binary;
							size = 16;
							break;
						case "CHARACTER":
							dbType = DbType.StringFixedLength;
							size = 100;
							break;
						case "CHARACTER VARYING":
							dbType = DbType.String;
							size = 100;
							break;
						case "NUMERIC":
						case "DECIMAL":
							dbType = DbType.Decimal;
							size = 32;
							break;
						case "SMALLINT":
							dbType = DbType.Int16;
							size = 2;
							break;
						case "INTEGER":
							dbType = DbType.Int32;
							size = 4;
							break;
						case "BIGINT":
							dbType = DbType.Int64;
							size = 8;
							precision = 19;
							break;
						case "DOUBLE PRECISION":
						case "FLOAT":
							dbType = DbType.Double;
							size = 8;
							break;
						case "REAL":
							dbType = DbType.Single;
							size = 4;
							break;
						case "BOOLEAN":
							dbType = DbType.Boolean;
							size = 1;
							break;
						case "DATE":
							dbType = DbType.Date;
							size = 4;
							break;
						case "TIME":
//.........这里部分代码省略.........
开发者ID:cjheath,项目名称:NORMA,代码行数:101,代码来源:DILSchemaProvider.cs


示例19: GetNameFromDBFieldName

	public string GetNameFromDBFieldName(ColumnSchema column)
	{
		return column.Name;
	}
开发者ID:cityjoy,项目名称:DapperCodeSmith,代码行数:4,代码来源:ToolsCodeTemplate.cs


示例20: GetPropertyName

	public string GetPropertyName(ColumnSchema column)
	{
		return MakePascal(GetNameFromDBFieldName(column));
	}
开发者ID:cityjoy,项目名称:DapperCodeSmith,代码行数:4,代码来源:ToolsCodeTemplate.cs



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


鲜花

握手

雷人

路过

鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
上一篇:
C# ColumnType类代码示例发布时间:2022-05-24
下一篇:
C# ColumnProperty类代码示例发布时间:2022-05-24
热门推荐
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

在线QQ客服
地址:深圳市南山区西丽大学城创智工业园
电邮:jeky_zhao#qq.com
移动电话:139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap