C# (CSharp) Sql SqlBuilder.Write Examples

Example #1

File: ColumnDefination.cs Project: carbon/Data

        public void WriteTo(SqlBuilder sb)
        {
            sb.WriteIdentifier(Name);

            sb.Append(" ");

            sb.Write(Type);

            if (!IsOptional)
            {
                sb.Append(" NOT NULL");
            }

            if (AutoIncriment)
            {
                sb.Append(" AUTO_INCREMENT");
            }

            if (IsKey)
            {
                sb.Append(" ");

                sb.Append(IsUnique ? "UNIQUE" : "PRIMARY");

                sb.Append(" KEY");
            }

            if (Default != null)
            {
                sb.Append(" DEFAULT ");

                sb.Append(Default);
            }

            if (OnUpdate != null)
            {
                sb.Append(" ON UPDATE ");

                sb.Append(OnUpdate);
            }

            if (Format != null)
            {
                sb.Append(" " + Format.Value.ToString().ToUpper());
            }
        }

Example #2

File: MySqlType.cs Project: carbon/Data

        public static string ToSql(this DbTypeInfo type)
        {
            var sql = new SqlBuilder(MySqlAdapter.Default);

            sql.Write(type);

            return sql.ToString();
        }