C# (CSharp) SqlFu.Builders.CreateTable TableCreationData 예제들

예제 #1

파일: CreateTableBuilder.cs 프로젝트: sapiens/SqlFu

 public string GetSql(TableCreationData data)
 {
     _data = data;
     _tableName = _provider.EscapeTableName(data.TableName);
   
     _sb.AppendLine("create table " + _tableName + "(");
     AddColumns(data.Columns);
     AddConstraints(data.PrimaryKey);
     AddConstraints(data.ForeignKeys);
     _sb.Append(");");
     AddIndexes(data.Indexes);
     return _sb.ToString();
 }

예제 #2

        public string GetSql(TableCreationData data)
        {
            _data      = data;
            _tableName = _provider.EscapeTableName(data.TableName);

            _sb.AppendLine("create table " + _tableName + "(");
            AddColumns(data.Columns);
            AddConstraints(data.PrimaryKey);
            AddConstraints(data.ForeignKeys);
            _sb.Append(");");
            AddIndexes(data.Indexes);
            return(_sb.ToString());
        }