private static void GenerateXY(
ConnectorBase conn,
PointWrapper point,
out string x, out string y)
{
if (point.PointColumnName != null)
{
string pt;
if (point.LatitudeTableName != null)
{
pt = conn.WrapFieldName(point.LatitudeTableName) + @"." + conn.WrapFieldName(point.PointColumnName);
}
else
{
pt = conn.WrapFieldName(point.PointColumnName);
}
if (conn.TYPE == ConnectorBase.SqlServiceType.MSSQL)
{
x = pt + @".STX";
y = pt + @".STY";
}
else
{
if (conn.TYPE == ConnectorBase.SqlServiceType.POSTGRESQL)
{
x = @"ST_X(" + pt + @")";
y = @"ST_Y(" + pt + @")";
}
else // MYSQL
{
x = @"X(" + pt + @")";
y = @"Y(" + pt + @")";
}
}
}
else
{
if (point.LatitudeColumnName != null)
{
x = (point.LatitudeTableName != null ? conn.WrapFieldName(point.LatitudeTableName) + "." : "")
+ conn.WrapFieldName(point.LatitudeColumnName);
}
else
{
x = (point.Latitude ?? 0m).ToString(CultureInfo.InvariantCulture);
}
if (point.LongitudeColumnName != null)
{
y = (point.LongitudeTableName != null ? conn.WrapFieldName(point.LongitudeTableName) + "." : "")
+ conn.WrapFieldName(point.LongitudeColumnName);
}
else
{
y = (point.Longitude ?? 0m).ToString(CultureInfo.InvariantCulture);
}
}
}
private void BuildJoin(StringBuilder sb, ConnectorBase connection)
{
if (_ListJoin != null)
{
foreach (Join join in _ListJoin)
{
switch (join.JoinType)
{
case JoinType.InnerJoin:
sb.Append(@" INNER JOIN ");
break;
case JoinType.LeftJoin:
sb.Append(@" LEFT JOIN ");
break;
case JoinType.RightJoin:
sb.Append(@" RIGHT JOIN ");
break;
case JoinType.LeftOuterJoin:
sb.Append(@" LEFT OUTER JOIN ");
break;
case JoinType.RightOuterJoin:
sb.Append(@" RIGHT OUTER JOIN ");
break;
case JoinType.FullOuterJoin:
sb.Append(@" FULL OUTER JOIN ");
break;
}
if (join.RightTableSchema != null)
{
if (join.RightTableSchema.DatabaseOwner.Length > 0)
{
sb.Append(connection.WrapFieldName(join.RightTableSchema.DatabaseOwner));
sb.Append('.');
}
sb.Append(connection.WrapFieldName(join.RightTableSchema.Name));
}
else
{
sb.Append('(');
if (join.RightTableSql is Query)
{
sb.Append(((Query)join.RightTableSql).BuildCommand(connection));
}
else
{
sb.Append(join.RightTableSql.ToString());
}
sb.Append(')');
}
sb.Append(' ');
if (join.RightTableAlias != null)
{
sb.Append(join.RightTableAlias);
}
else
{
sb.Append(join.RightTableSchema != null ? join.RightTableSchema.Name : @"");
}
if (join.Pairs.Count > 1)
{
sb.Append(@" ON ");
WhereList wl = new WhereList();
foreach (WhereList joins in join.Pairs)
{
wl.AddRange(joins);
}
wl.BuildCommand(sb, connection, this, join.RightTableSchema, join.RightTableAlias == null ? join.RightTableSchema.Name : join.RightTableAlias);
}
else if (join.Pairs.Count == 1)
{
sb.Append(@" ON ");
join.Pairs[0].BuildCommand(sb, connection, this, join.RightTableSchema, join.RightTableAlias == null ? join.RightTableSchema.Name : join.RightTableAlias);
}
}
}
}
public string BuildCommand(ConnectorBase connection)
{
if (this.QueryMode == QueryMode.ExecuteStoredProcedure || this.QueryMode == QueryMode.None) return string.Empty;
StringBuilder sb = new StringBuilder();
bool ownsConnection = false;
if (connection == null)
{
ownsConnection = true;
connection = ConnectorBase.NewInstance();
}
try
{
bool bFirst;
if (this.QueryMode != QueryMode.None)
{
switch (this.QueryMode)
{
case QueryMode.Select:
{
if (Offset > 0 &&
connection.TYPE == ConnectorBase.SqlServiceType.MSSQL &&
!connection.SupportsSelectPaging())
{
// Special case for Sql Server where in versions prior to 2012 there was no paging support
BuildSelectForMsSqlPaging(sb, connection);
}
else if (Offset > 0 && Limit > 0 &&
connection.TYPE == ConnectorBase.SqlServiceType.MSACCESS)
{
// Special case for Ms Access where paging is not supported so we do a complex emulation of LIMIT+OFFSET
BuildSelectForMsAccessLimitOffset(sb, connection);
}
else if (Offset > 0 &&
connection.TYPE == ConnectorBase.SqlServiceType.MSACCESS)
{
// Special case for Ms Access where paging is not supported so we do a complex emulation of OFFSET
BuildSelectForMsAccessOffset(sb, connection);
}
else
{
sb.Append(@" SELECT ");
if (IsDistinct) sb.Append(@"DISTINCT ");
if (Limit > 0 &&
(connection.TYPE == ConnectorBase.SqlServiceType.MSACCESS ||
(connection.TYPE == ConnectorBase.SqlServiceType.MSSQL && !(connection.SupportsSelectPaging() && Offset > 0))
))
{
sb.Append(@"TOP " + Limit);
sb.Append(' ');
}
BuildSelectList(sb, connection);
sb.Append(@" FROM ");
if (Schema != null)
{
if (Schema.DatabaseOwner.Length > 0)
{
sb.Append(connection.WrapFieldName(Schema.DatabaseOwner));
sb.Append('.');
}
sb.Append(connection.WrapFieldName(_SchemaName));
}
else
{
sb.Append(@"(");
if (_FromExpression is dg.Sql.IPhrase)
{
sb.Append(((dg.Sql.IPhrase)_FromExpression).BuildPhrase(connection, this));
}
else sb.Append(_FromExpression);
sb.Append(@") ");
sb.Append(connection.WrapFieldName(_FromExpressionTableAlias));
}
BuildJoin(sb, connection);
if (_ListWhere != null && _ListWhere.Count > 0)
{
sb.Append(@" WHERE ");
_ListWhere.BuildCommand(sb, connection, this, null, null);
}
BuildGroupBy(sb, connection, false);
BuildHaving(sb, connection);
BuildOrderBy(sb, connection, false);
if (connection.TYPE == ConnectorBase.SqlServiceType.MYSQL)
{
if (Limit > 0)
{
sb.Append(@" LIMIT ");
sb.Append(Limit);
// OFFSET is not supported without LIMIT
if (Offset > 0)
{
sb.Append(@" OFFSET ");
sb.Append(Offset);
}
}
}
else if (connection.TYPE == ConnectorBase.SqlServiceType.POSTGRESQL)
{
if (Limit > 0)
{
sb.Append(@" LIMIT ");
sb.Append(Limit);
}
if (Offset > 0)
{
sb.Append(@" OFFSET ");
sb.Append(Offset);
}
}
else if (connection.TYPE == ConnectorBase.SqlServiceType.MSSQL)
{
if (connection.SupportsSelectPaging() && Offset > 0)
{
// If we are in MsSql OFFSET/FETCH mode...
sb.Append(@" OFFSET ");
sb.Append(Offset);
sb.Append(@" ROWS");
if (Limit > 0)
{
sb.Append(@" FETCH NEXT ");
sb.Append(Limit);
sb.Append(@" ROWS ONLY");
}
}
}
// Done with select query
}
// Write out supported hints
switch (_QueryHint)
{
case QueryHint.ForUpdate:
if (connection.TYPE == ConnectorBase.SqlServiceType.MYSQL ||
connection.TYPE == ConnectorBase.SqlServiceType.MSSQL ||
connection.TYPE == ConnectorBase.SqlServiceType.POSTGRESQL)
{
sb.Append(@" FOR UPDATE");
}
break;
case QueryHint.LockInSharedMode:
if (connection.TYPE == ConnectorBase.SqlServiceType.MYSQL)
{
sb.Append(@" LOCK IN SHARED MODE");
}
else if (connection.TYPE == ConnectorBase.SqlServiceType.POSTGRESQL)
{
sb.Append(@" FOR SHARE");
}
break;
}
}
break;
case QueryMode.Insert:
{
sb.Append(@"INSERT INTO ");
if (Schema.DatabaseOwner.Length > 0)
{
sb.Append(connection.WrapFieldName(Schema.DatabaseOwner));
sb.Append('.');
}
sb.Append(connection.WrapFieldName(_SchemaName));
sb.Append(@" (");
bFirst = true;
foreach (AssignmentColumn ins in _ListInsertUpdate)
{
if (bFirst) bFirst = false;
else sb.Append(',');
sb.Append(connection.WrapFieldName(ins.ColumnName));
}
if (InsertExpression != null)
{
sb.Append(@") ");
sb.Append(InsertExpression);
}
else
{
sb.Append(@") VALUES (");
bFirst = true;
foreach (AssignmentColumn ins in _ListInsertUpdate)
{
if (bFirst) bFirst = false;
else sb.Append(',');
if (ins.SecondType == ValueObjectType.Literal)
{
sb.Append(ins.Second);
}
else if (ins.SecondType == ValueObjectType.Value)
{
if (ins.Second is Query)
{
sb.Append('(');
sb.Append(((Query)ins.Second).BuildCommand(connection));
sb.Append(')');
}
else
{
Query.PrepareColumnValue(Schema.Columns.Find(ins.ColumnName), ins.Second, sb, connection, this);
}
}
else if (ins.SecondType == ValueObjectType.ColumnName)
{
if (ins.SecondTableName != null)
{
sb.Append(connection.WrapFieldName(ins.SecondTableName));
sb.Append(@".");
}
sb.Append(connection.WrapFieldName(ins.Second.ToString()));
}
}
sb.Append(@")");
if (_ListWhere != null && _ListWhere.Count > 0)
{
sb.Append(@" WHERE ");
_ListWhere.BuildCommand(sb, connection, this, null, null);
}
}
}
break;
case QueryMode.Update:
{
bool hasJoins = _ListJoin != null && _ListJoin.Count > 0;
sb.Append(@"UPDATE ");
if (hasJoins &&
(connection.TYPE == ConnectorBase.SqlServiceType.MSSQL ||
connection.TYPE == ConnectorBase.SqlServiceType.MSACCESS) &&
_FromExpressionTableAlias != null && _FromExpressionTableAlias.Length > 0)
{
sb.Append(connection.WrapFieldName(_FromExpressionTableAlias));
}
else
{
if (Schema.DatabaseOwner.Length > 0)
{
sb.Append(connection.WrapFieldName(Schema.DatabaseOwner));
sb.Append('.');
}
sb.Append(connection.WrapFieldName(_SchemaName));
if (_FromExpressionTableAlias != null && _FromExpressionTableAlias.Length > 0)
{
sb.Append(' ');
sb.Append(connection.WrapFieldName(_FromExpressionTableAlias));
}
}
if (hasJoins)
{
if (connection.TYPE == ConnectorBase.SqlServiceType.MYSQL)
{
BuildJoin(sb, connection);
}
}
bFirst = true;
foreach (AssignmentColumn upd in _ListInsertUpdate)
{
if (bFirst)
{
sb.Append(@" SET ");
bFirst = false;
}
else sb.Append(',');
sb.Append(connection.WrapFieldName(upd.ColumnName));
sb.Append('=');
if (upd.SecondType == ValueObjectType.Literal)
{
sb.Append(upd.Second);
}
else if (upd.SecondType == ValueObjectType.Value)
{
Query.PrepareColumnValue(Schema.Columns.Find(upd.ColumnName), upd.Second, sb, connection, this);
}
else if (upd.SecondType == ValueObjectType.ColumnName)
{
if (upd.SecondTableName != null)
{
sb.Append(connection.WrapFieldName(upd.SecondTableName));
sb.Append(@".");
}
sb.Append(connection.WrapFieldName(upd.Second.ToString()));
}
}
if (hasJoins)
{
if (connection.TYPE == ConnectorBase.SqlServiceType.MSSQL ||
connection.TYPE == ConnectorBase.SqlServiceType.MSACCESS)
{
sb.Append(@" FROM ");
if (Schema.DatabaseOwner.Length > 0)
{
sb.Append(connection.WrapFieldName(Schema.DatabaseOwner));
sb.Append('.');
}
sb.Append(connection.WrapFieldName(_SchemaName));
if (_FromExpressionTableAlias != null && _FromExpressionTableAlias.Length > 0)
{
sb.Append(' ');
sb.Append(connection.WrapFieldName(_FromExpressionTableAlias));
}
BuildJoin(sb, connection);
}
}
if (_ListWhere != null && _ListWhere.Count > 0)
{
sb.Append(@" WHERE ");
_ListWhere.BuildCommand(sb, connection, this, null, null);
}
BuildOrderBy(sb, connection, false);
}
break;
case QueryMode.InsertOrUpdate:
{
if (connection.TYPE == ConnectorBase.SqlServiceType.MYSQL)
{
sb.Append(@"REPLACE INTO ");
if (Schema.DatabaseOwner.Length > 0)
{
sb.Append(connection.WrapFieldName(Schema.DatabaseOwner));
sb.Append('.');
}
sb.Append(connection.WrapFieldName(_SchemaName));
sb.Append(@" (");
bFirst = true;
foreach (AssignmentColumn ins in _ListInsertUpdate)
{
if (bFirst) bFirst = false;
else sb.Append(',');
sb.Append(connection.WrapFieldName(ins.ColumnName));
}
if (InsertExpression != null)
{
sb.Append(@") ");
sb.Append(InsertExpression);
}
else
{
sb.Append(@") VALUES (");
bFirst = true;
foreach (AssignmentColumn ins in _ListInsertUpdate)
{
if (bFirst) bFirst = false;
else sb.Append(',');
if (ins.SecondType == ValueObjectType.Literal)
{
sb.Append(ins.Second);
}
else if (ins.SecondType == ValueObjectType.Value)
{
if (ins.Second is Query)
{
sb.Append('(');
sb.Append(((Query)ins.Second).BuildCommand(connection));
sb.Append(')');
}
else
{
Query.PrepareColumnValue(Schema.Columns.Find(ins.ColumnName), ins.Second, sb, connection, this);
}
}
else if (ins.SecondType == ValueObjectType.ColumnName)
{
if (ins.SecondTableName != null)
{
sb.Append(connection.WrapFieldName(ins.SecondTableName));
sb.Append(@".");
}
sb.Append(connection.WrapFieldName(ins.Second.ToString()));
}
}
sb.Append(@")");
if (_ListWhere != null && _ListWhere.Count > 0)
{
sb.Append(@" WHERE ");
_ListWhere.BuildCommand(sb, connection, this, null, null);
}
}
}
else
{
_NeedTransaction = true;
if (connection.TYPE == ConnectorBase.SqlServiceType.POSTGRESQL)
{
throw new NotImplementedException(@"This operation is not implemented for PostgreSQL due to database limitations.");
}
// MSSQL
QueryMode qm = this.QueryMode;
this.QueryMode = QueryMode.Update;
sb.Append(BuildCommand(connection));
sb.Append(@"; IF @@rowcount = 0 BEGIN ");
this.QueryMode = QueryMode.Insert;
sb.Append(BuildCommand(connection));
sb.Append(@"; END");
this.QueryMode = qm;
}
}
break;
case QueryMode.Delete:
{
sb.Append(@"DELETE");
if (_ListJoin != null && _ListJoin.Count > 0)
{
if (Schema.DatabaseOwner.Length > 0)
{
sb.Append(connection.WrapFieldName(Schema.DatabaseOwner));
sb.Append('.');
}
sb.Append(connection.WrapFieldName(_SchemaName));
}
sb.Append(@" FROM ");
if (Schema.DatabaseOwner.Length > 0)
{
sb.Append(connection.WrapFieldName(Schema.DatabaseOwner));
sb.Append('.');
}
sb.Append(connection.WrapFieldName(_SchemaName));
BuildJoin(sb, connection);
if (_ListWhere != null && _ListWhere.Count > 0)
{
sb.Append(@" WHERE ");
_ListWhere.BuildCommand(sb, connection, this, null, null);
}
BuildOrderBy(sb, connection, false);
}
break;
case QueryMode.CreateTable:
{
sb.Append(@"CREATE TABLE ");
if (Schema.DatabaseOwner.Length > 0)
{
sb.Append(connection.WrapFieldName(Schema.DatabaseOwner));
sb.Append('.');
}
sb.Append(connection.WrapFieldName(_SchemaName));
sb.Append('(');
int iPrimaryKeys = 0;
bool bSep = false;
foreach (TableSchema.Column col in Schema.Columns)
{
if (col.IsPrimaryKey) iPrimaryKeys++;
if (bSep) sb.Append(@", "); else bSep = true;
BuildColumnProperties(sb, connection, col, false);
}
if (iPrimaryKeys > 0)
{
if (bSep) sb.Append(@", ");
sb.AppendFormat(@"CONSTRAINT {0} PRIMARY KEY(", connection.WrapFieldName(@"PK_" + _SchemaName));
bSep = false;
foreach (TableSchema.Column col in Schema.Columns)
{
if (!col.IsPrimaryKey) continue;
if (bSep) sb.Append(@", "); else bSep = true;
if (col.IsPrimaryKey) sb.Append(connection.WrapFieldName(col.Name));
}
bSep = true;
sb.Append(')');
}
sb.Append(')');
if (Schema.TableOptions != null && Schema.TableOptions.Count > 0)
{
foreach (KeyValuePair<string, string> option in Schema.TableOptions)
{
sb.Append(' ');
sb.Append(option.Key);
sb.Append('=');
sb.Append(option.Value);
}
}
}
break;
case QueryMode.CreateIndex:
BuildCreateIndex(sb, connection, _CreateIndexObject);
break;
case QueryMode.CreateIndexes:
{
if ((Schema.Indexes.Count + Schema.ForeignKeys.Count) > 1)
{
_NeedTransaction = true;
}
foreach (TableSchema.Index index in Schema.Indexes)
{
BuildCreateIndex(sb, connection, index);
sb.Append(@";");
}
foreach (TableSchema.ForeignKey foreignKey in Schema.ForeignKeys)
{
BuildCreateIndex(sb, connection, foreignKey);
sb.Append(@";");
}
}
break;
case QueryMode.AddColumn:
{
sb.Append(@"ALTER TABLE ");
if (Schema.DatabaseOwner.Length > 0)
{
sb.Append(connection.WrapFieldName(Schema.DatabaseOwner));
sb.Append('.');
}
sb.Append(connection.WrapFieldName(_SchemaName));
sb.Append(@" ADD ");
if (connection.TYPE == ConnectorBase.SqlServiceType.MYSQL || connection.TYPE == ConnectorBase.SqlServiceType.POSTGRESQL)
{
sb.Append(@"COLUMN ");
}
BuildColumnProperties(sb, connection, _AlterColumn, false);
if (connection.TYPE == ConnectorBase.SqlServiceType.MYSQL)
{
int idx = Schema.Columns.IndexOf(_AlterColumn);
if (idx == 0) sb.Append(@"FIRST ");
else sb.AppendFormat(@"AFTER {0} ", connection.WrapFieldName(Schema.Columns[idx - 1].Name));
}
}
break;
case QueryMode.ChangeColumn:
{
if (_AlterColumnOldName != null && _AlterColumnOldName.Length == 0) _AlterColumnOldName = null;
if (_AlterColumnOldName != null)
{
if (connection.TYPE == ConnectorBase.SqlServiceType.MSSQL)
{
sb.Append(@"EXEC sp_rename ");
if (Schema.DatabaseOwner.Length > 0)
{
sb.Append(connection.WrapFieldName(Schema.DatabaseOwner));
sb.Append('.');
}
sb.Append(connection.WrapFieldName(_SchemaName));
sb.Append('.');
sb.Append(connection.WrapFieldName(_AlterColumnOldName));
sb.Append(',');
sb.Append(connection.WrapFieldName(_AlterColumn.Name));
sb.Append(@",'COLUMN';");
}
else if (connection.TYPE == ConnectorBase.SqlServiceType.POSTGRESQL)
{
sb.Append(@"ALTER TABLE ");
if (Schema.DatabaseOwner.Length > 0)
{
sb.Append(connection.WrapFieldName(Schema.DatabaseOwner));
sb.Append('.');
}
sb.Append(connection.WrapFieldName(_SchemaName));
sb.Append(@" RENAME COLUMN ");
sb.Append(connection.WrapFieldName(_AlterColumnOldName));
sb.Append(@" TO ");
sb.Append(connection.WrapFieldName(_AlterColumn.Name));
sb.Append(';');
}
}
if (connection.TYPE == ConnectorBase.SqlServiceType.POSTGRESQL)
{
// Very limited syntax, will have to do this with several statements
sb.Append(@"ALTER TABLE ");
if (Schema.DatabaseOwner.Length > 0)
{
sb.Append(connection.WrapFieldName(Schema.DatabaseOwner));
sb.Append('.');
}
sb.Append(connection.WrapFieldName(_SchemaName));
string alterColumnStatement = @" ALTER COLUMN ";
alterColumnStatement += connection.WrapFieldName(_AlterColumn.Name);
sb.Append(alterColumnStatement);
sb.Append(@" TYPE ");
bool isTextField; // UNUSED HERE
BuildColumnPropertiesDataType(sb, connection, _AlterColumn, out isTextField);
sb.Append(',');
sb.Append(alterColumnStatement);
sb.Append(_AlterColumn.Nullable ? @" DROP NOT NULL;" : @" SET NOT NULL;");
sb.Append(alterColumnStatement);
sb.Append(@" SET DEFAULT ");
Query.PrepareColumnValue(_AlterColumn, _AlterColumn.Default, sb, connection, this);
sb.Append(';');
}
else
{
sb.Append(@"ALTER TABLE ");
if (Schema.DatabaseOwner.Length > 0)
{
sb.Append(connection.WrapFieldName(Schema.DatabaseOwner));
sb.Append('.');
}
sb.Append(connection.WrapFieldName(_SchemaName));
sb.Append(' ');
if (connection.TYPE == ConnectorBase.SqlServiceType.MYSQL)
{
sb.AppendFormat(@"CHANGE {0} ", connection.WrapFieldName(_AlterColumnOldName != null ? _AlterColumnOldName : _AlterColumn.Name));
}
else
{
sb.Append(@"ALTER COLUMN ");
}
BuildColumnProperties(sb, connection, _AlterColumn, connection.TYPE == ConnectorBase.SqlServiceType.MSSQL);
if (connection.TYPE == ConnectorBase.SqlServiceType.MYSQL)
{
int idx = Schema.Columns.IndexOf(_AlterColumn);
if (idx == 0) sb.Append(@"FIRST ");
else sb.AppendFormat(@"AFTER {0} ", connection.WrapFieldName(Schema.Columns[idx - 1].Name));
}
}
}
break;
case QueryMode.DropColumn:
{
sb.Append(@"ALTER TABLE ");
if (Schema.DatabaseOwner.Length > 0)
{
sb.Append(connection.WrapFieldName(Schema.DatabaseOwner));
sb.Append('.');
}
sb.Append(connection.WrapFieldName(_SchemaName));
sb.Append(@" DROP COLUMN ");
sb.Append(connection.WrapFieldName(_DropColumnName));
}
break;
case QueryMode.DropForeignKey:
{
if (connection.TYPE == ConnectorBase.SqlServiceType.MYSQL)
{
sb.Append(@"ALTER TABLE ");
if (Schema.DatabaseOwner.Length > 0)
{
sb.Append(connection.WrapFieldName(Schema.DatabaseOwner));
sb.Append('.');
}
sb.Append(connection.WrapFieldName(_SchemaName));
sb.Append(@" DROP FOREIGN KEY ");
sb.Append(connection.WrapFieldName(_DropColumnName));
}
else if (connection.TYPE == ConnectorBase.SqlServiceType.POSTGRESQL)
{
sb.Append(@"ALTER TABLE ");
if (Schema.DatabaseOwner.Length > 0)
{
sb.Append(connection.WrapFieldName(Schema.DatabaseOwner));
sb.Append('.');
}
sb.Append(connection.WrapFieldName(_SchemaName));
sb.Append(@" DROP CONSTRAINT ");
sb.Append(connection.WrapFieldName(_DropColumnName));
}
else
{
sb.Append(@"ALTER TABLE ");
if (Schema.DatabaseOwner.Length > 0)
{
sb.Append(connection.WrapFieldName(Schema.DatabaseOwner));
sb.Append('.');
}
sb.Append(connection.WrapFieldName(_SchemaName));
sb.Append(@" DROP CONSTRAINT ");
sb.Append(connection.WrapFieldName(_DropColumnName));
}
}
break;
case QueryMode.DropIndex:
{
if (connection.TYPE == ConnectorBase.SqlServiceType.MYSQL || connection.TYPE == ConnectorBase.SqlServiceType.POSTGRESQL)
{
sb.Append(@"ALTER TABLE ");
if (Schema.DatabaseOwner.Length > 0)
{
sb.Append(connection.WrapFieldName(Schema.DatabaseOwner));
sb.Append('.');
}
sb.Append(connection.WrapFieldName(_SchemaName));
sb.Append(@" DROP INDEX ");
sb.Append(connection.WrapFieldName(_DropColumnName));
}
else
{
sb.Append(@"ALTER TABLE ");
if (Schema.DatabaseOwner.Length > 0)
{
sb.Append(connection.WrapFieldName(Schema.DatabaseOwner));
sb.Append('.');
}
sb.Append(connection.WrapFieldName(_SchemaName));
sb.Append(@" DROP CONSTRAINT ");
sb.Append(connection.WrapFieldName(_DropColumnName));
}
}
break;
case QueryMode.DropTable:
{
sb.Append(@"DROP TABLE ");
if (Schema.DatabaseOwner.Length > 0)
{
sb.Append(connection.WrapFieldName(Schema.DatabaseOwner));
sb.Append('.');
}
sb.Append(connection.WrapFieldName(_SchemaName));
}
break;
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (ownsConnection && connection != null)
{
connection.Close();
connection.Dispose();
connection = null;
}
}
return sb.ToString();
}
public void BuildColumnProperties(StringBuilder sb, ConnectorBase connection, TableSchema.Column column, bool NoDefault)
{
sb.Append(connection.WrapFieldName(column.Name));
sb.Append(' ');
bool isTextField;
BuildColumnPropertiesDataType(sb, connection, column, out isTextField);
if (!column.Nullable)
{
sb.Append(@"NOT NULL ");
}
if (!NoDefault && column.Default != null && (!(isTextField && connection.TYPE == ConnectorBase.SqlServiceType.MYSQL)))
{
sb.Append(@"DEFAULT ");
Query.PrepareColumnValue(column, column.Default, sb, connection, this);
sb.Append(' ');
}
}
private void BuildCreateIndex(StringBuilder sb, ConnectorBase connection, object indexObj)
{
if (indexObj is TableSchema.Index)
{
TableSchema.Index index = indexObj as TableSchema.Index;
if (connection.TYPE == ConnectorBase.SqlServiceType.MYSQL)
{
sb.Append(@"ALTER TABLE ");
if (Schema.DatabaseOwner.Length > 0)
{
sb.Append(connection.WrapFieldName(Schema.DatabaseOwner));
sb.Append('.');
}
sb.Append(connection.WrapFieldName(_SchemaName));
sb.Append(@" ADD ");
if (index.Mode == dg.Sql.TableSchema.IndexMode.PrimaryKey)
{
sb.AppendFormat(@"CONSTRAINT {0} PRIMARY KEY ", connection.WrapFieldName(index.Name));
}
else
{
switch (index.Mode)
{
case TableSchema.IndexMode.Unique:
sb.Append(@"UNIQUE ");
break;
case TableSchema.IndexMode.FullText:
sb.Append(@"FULLTEXT ");
break;
case TableSchema.IndexMode.Spatial:
sb.Append(@"SPATIAL ");
break;
}
sb.Append(@"INDEX ");
sb.Append(connection.WrapFieldName(index.Name));
sb.Append(@" ");
}
if (index.Mode != TableSchema.IndexMode.Spatial)
{
switch (index.Type)
{
case TableSchema.IndexType.BTREE:
sb.Append(@"USING BTREE ");
break;
case TableSchema.IndexType.RTREE:
sb.Append(@"USING RTREE ");
break;
case TableSchema.IndexType.HASH:
sb.Append(@"USING HASH ");
break;
}
}
sb.Append(@"(");
for (int i = 0; i < index.ColumnNames.Length; i++)
{
if (i > 0) sb.Append(",");
sb.Append(connection.WrapFieldName(index.ColumnNames[i]));
if (index.ColumnLength[i] > 0) sb.AppendFormat("({0})", index.ColumnLength[i]);
sb.Append(index.ColumnSort[i] == SortDirection.ASC ? @" ASC" : @" DESC");
}
sb.Append(@")");
}
else if (connection.TYPE == ConnectorBase.SqlServiceType.POSTGRESQL)
{
if (index.Mode == dg.Sql.TableSchema.IndexMode.PrimaryKey)
{
sb.Append(@"ALTER TABLE ");
if (Schema.DatabaseOwner.Length > 0)
{
sb.Append(connection.WrapFieldName(Schema.DatabaseOwner));
sb.Append('.');
}
sb.Append(connection.WrapFieldName(_SchemaName));
sb.Append(@" ADD CONSTRAINT ");
sb.Append(connection.WrapFieldName(index.Name));
sb.Append(@" PRIMARY KEY ");
sb.Append(@"(");
for (int i = 0; i < index.ColumnNames.Length; i++)
{
if (i > 0) sb.Append(",");
sb.Append(connection.WrapFieldName(index.ColumnNames[i]));
sb.Append(index.ColumnSort[i] == SortDirection.ASC ? @" ASC" : @" DESC");
}
sb.Append(@")");
}
else
{
sb.Append(@"CREATE ");
if (index.Mode == TableSchema.IndexMode.Unique) sb.Append(@"UNIQUE ");
sb.Append(@"INDEX ");
sb.Append(connection.WrapFieldName(index.Name));
sb.Append(@"ON ");
if (Schema.DatabaseOwner.Length > 0)
{
sb.Append(connection.WrapFieldName(Schema.DatabaseOwner));
sb.Append('.');
}
sb.Append(connection.WrapFieldName(_SchemaName));
if (index.Mode == TableSchema.IndexMode.Spatial)
{
sb.Append(@"USING GIST");
}
sb.Append(@"(");
for (int i = 0; i < index.ColumnNames.Length; i++)
{
if (i > 0) sb.Append(",");
sb.Append(connection.WrapFieldName(index.ColumnNames[i]));
sb.Append(index.ColumnSort[i] == SortDirection.ASC ? @" ASC" : @" DESC");
}
sb.Append(@")");
}
}
else if (connection.TYPE == ConnectorBase.SqlServiceType.MSACCESS)
{
sb.Append(@"ALTER TABLE ");
if (Schema.DatabaseOwner.Length > 0)
{
sb.Append(connection.WrapFieldName(Schema.DatabaseOwner));
sb.Append('.');
}
sb.Append(connection.WrapFieldName(_SchemaName));
sb.Append(@" ADD ");
if (index.Mode == dg.Sql.TableSchema.IndexMode.PrimaryKey)
{
sb.AppendFormat(@"CONSTRAINT {0} PRIMARY KEY ", connection.WrapFieldName(index.Name));
}
else
{
if (index.Mode == TableSchema.IndexMode.Unique) sb.Append(@"UNIQUE ");
sb.Append(@"INDEX ");
sb.Append(connection.WrapFieldName(index.Name));
sb.Append(@" ");
}
sb.Append(@"(");
for (int i = 0; i < index.ColumnNames.Length; i++)
{
if (i > 0) sb.Append(",");
sb.Append(connection.WrapFieldName(index.ColumnNames[i]));
sb.Append(index.ColumnSort[i] == SortDirection.ASC ? @" ASC" : @" DESC");
}
sb.Append(@")");
}
else if (connection.TYPE == ConnectorBase.SqlServiceType.MSSQL)
{
if (index.Mode == dg.Sql.TableSchema.IndexMode.PrimaryKey)
{
sb.Append(@"ALTER TABLE ");
if (Schema.DatabaseOwner.Length > 0)
{
sb.Append(connection.WrapFieldName(Schema.DatabaseOwner));
sb.Append('.');
}
sb.Append(connection.WrapFieldName(_SchemaName));
sb.Append(@" ADD CONSTRAINT ");
sb.Append(connection.WrapFieldName(index.Name));
sb.Append(@" PRIMARY KEY ");
if (index.Cluster == TableSchema.ClusterMode.Clustered) sb.Append(@"CLUSTERED ");
else if (index.Cluster == TableSchema.ClusterMode.NonClustered) sb.Append(@"NONCLUSTERED ");
sb.Append(@"(");
for (int i = 0; i < index.ColumnNames.Length; i++)
{
if (i > 0) sb.Append(",");
sb.Append(connection.WrapFieldName(index.ColumnNames[i]));
sb.Append(index.ColumnSort[i] == SortDirection.ASC ? @" ASC" : @" DESC");
}
sb.Append(@")");
}
else
{
sb.Append(@"CREATE ");
if (index.Mode == TableSchema.IndexMode.Unique) sb.Append(@"UNIQUE ");
if (index.Cluster == TableSchema.ClusterMode.Clustered) sb.Append(@"CLUSTERED ");
else if (index.Cluster == TableSchema.ClusterMode.NonClustered) sb.Append(@"NONCLUSTERED ");
sb.Append(@"INDEX ");
sb.Append(connection.WrapFieldName(index.Name));
sb.Append(@"ON ");
if (Schema.DatabaseOwner.Length > 0)
{
sb.Append(connection.WrapFieldName(Schema.DatabaseOwner));
sb.Append('.');
}
sb.Append(connection.WrapFieldName(_SchemaName));
sb.Append(@"(");
for (int i = 0; i < index.ColumnNames.Length; i++)
{
if (i > 0) sb.Append(",");
sb.Append(connection.WrapFieldName(index.ColumnNames[i]));
sb.Append(index.ColumnSort[i] == SortDirection.ASC ? @" ASC" : @" DESC");
}
sb.Append(@")");
}
}
}
else if (indexObj is TableSchema.ForeignKey)
{
TableSchema.ForeignKey foreignKey = indexObj as TableSchema.ForeignKey;
sb.Append(@"ALTER TABLE ");
if (Schema.DatabaseOwner.Length > 0)
{
sb.Append(connection.WrapFieldName(Schema.DatabaseOwner));
sb.Append('.');
}
sb.Append(connection.WrapFieldName(_SchemaName));
sb.Append(@" ADD CONSTRAINT ");
sb.Append(connection.WrapFieldName(foreignKey.Name));
sb.Append(@" FOREIGN KEY (");
for (int i = 0; i < foreignKey.Columns.Length; i++)
{
if (i > 0) sb.Append(",");
sb.Append(connection.WrapFieldName(foreignKey.Columns[i]));
}
sb.AppendFormat(@") REFERENCES {0} (", foreignKey.ForeignTable);
for (int i = 0; i < foreignKey.ForeignColumns.Length; i++)
{
if (i > 0) sb.Append(",");
sb.Append(connection.WrapFieldName(foreignKey.ForeignColumns[i]));
}
sb.Append(@")");
if (foreignKey.OnDelete != TableSchema.ForeignKeyReference.None)
{
switch (foreignKey.OnDelete)
{
case TableSchema.ForeignKeyReference.Cascade:
sb.Append(@" ON DELETE CASCADE");
break;
case TableSchema.ForeignKeyReference.NoAction:
sb.Append(@" ON DELETE NO ACTION");
break;
case TableSchema.ForeignKeyReference.Restrict:
sb.Append(@" ON DELETE RESTRICT");
break;
case TableSchema.ForeignKeyReference.SetNull:
sb.Append(@" ON DELETE SET NULL");
break;
}
}
if (foreignKey.OnUpdate != TableSchema.ForeignKeyReference.None)
{
switch (foreignKey.OnUpdate)
{
case TableSchema.ForeignKeyReference.Cascade:
sb.Append(@" ON UPDATE CASCADE");
break;
case TableSchema.ForeignKeyReference.NoAction:
sb.Append(@" ON UPDATE NO ACTION");
break;
case TableSchema.ForeignKeyReference.Restrict:
sb.Append(@" ON UPDATE RESTRICT");
break;
case TableSchema.ForeignKeyReference.SetNull:
sb.Append(@" ON UPDATE SET NULL");
break;
}
}
}
}
private void BuildGroupBy(StringBuilder sb, ConnectorBase connection, bool invert)
{
if (_ListGroupBy != null && _ListGroupBy.Count > 0)
{
sb.Append(@" GROUP BY ");
bool bFirst = true;
foreach (GroupBy groupBy in _ListGroupBy)
{
if (bFirst) bFirst = false;
else sb.Append(',');
if (groupBy.ColumnName is dg.Sql.IPhrase)
{
sb.Append(((dg.Sql.IPhrase)groupBy.ColumnName).BuildPhrase(connection, this));
}
else if (groupBy.ColumnName is dg.Sql.Where)
{
((dg.Sql.Where)groupBy.ColumnName).BuildCommand(sb, true, connection, this);
}
else if (groupBy.IsLiteral)
{
sb.Append(groupBy.ColumnName);
}
else
{
if (groupBy.TableName != null)
{
sb.Append(connection.WrapFieldName(groupBy.TableName) + @"." + connection.WrapFieldName(groupBy.ColumnName.ToString()));
}
else
{
sb.Append(connection.WrapFieldName(groupBy.ColumnName.ToString()));
}
}
if (connection.TYPE == ConnectorBase.SqlServiceType.MYSQL)
{
switch (groupBy.SortDirection)
{
default:
case SortDirection.None:
break;
case SortDirection.ASC:
sb.Append(invert ? @" DESC" : @" ASC");
break;
case SortDirection.DESC:
sb.Append(invert ? @" ASC" : @" DESC");
break;
}
}
}
}
}
private void BuildSelectForMsAccessLimitOffset(StringBuilder sb, ConnectorBase connection)
{
// MSACCESS - LIMIT,OFFSET:
// SELECT * FROM
// (
// SELECT TOP [limit] * FROM
// (
// SELECT TOP [offset+limit]
// [selects] FROM [tables, joins]
// WHERE [wheres]
// ORDER BY [orders]
// ) pp ORDER BY [inverted orders]
// ) p ORDER BY [orders]
sb.AppendFormat(@"SELECT * FROM ( SELECT TOP {0} * FROM ( SELECT TOP {1} ", Limit, Offset + Limit);
if (IsDistinct) sb.Append(@"DISTINCT ");
BuildSelectList(sb, connection);
sb.Append(@" FROM ");
if (Schema != null)
{
if (Schema.DatabaseOwner.Length > 0)
{
sb.Append(connection.WrapFieldName(Schema.DatabaseOwner));
sb.Append('.');
}
sb.Append(connection.WrapFieldName(_SchemaName));
}
else
{
sb.Append(@"(");
if (_FromExpression is dg.Sql.IPhrase)
{
sb.Append(((dg.Sql.IPhrase)_FromExpression).BuildPhrase(connection, this));
}
else sb.Append(_FromExpression);
sb.Append(@") ");
sb.Append(connection.WrapFieldName(_FromExpressionTableAlias));
}
BuildJoin(sb, connection);
if (_ListWhere != null && _ListWhere.Count > 0)
{
sb.Append(@" WHERE ");
_ListWhere.BuildCommand(sb, connection, this, null, null);
}
StringBuilder sbOrderBy = new StringBuilder();
StringBuilder sbGroupBy = new StringBuilder();
BuildGroupBy(sbGroupBy, connection, false);
BuildOrderBy(sbOrderBy, connection, false);
sb.Append(sbOrderBy.ToString());
sb.Append(sbGroupBy.ToString());
sb.Append(@") pp ");
BuildGroupBy(sb, connection, true);
BuildOrderBy(sb, connection, true);
sb.Append(@") p ");
sb.Append(sbOrderBy.ToString());
sb.Append(sbGroupBy.ToString());
}
private void BuildSelectForMsSqlPaging(StringBuilder sb, ConnectorBase connection)
{
// MSSQL:
// WITH [table] AS
// (
// SELECT [selects],ROW_NUMBER() OVER([orders]) AS __ROWID__
// FROM [tables, joins] WHERE [wheres]
// )
// SELECT * FROM [table]
// WHERE __ROWID__ BETWEEN [offset+1] AND [offset+1+limit]
// --WHERE __ROWID__ > offset
sb.Append(@"WITH [Ordered Table] AS ( SELECT ");
if (IsDistinct) sb.Append(@"DISTINCT ");
BuildSelectList(sb, connection);
sb.Append(@",ROW_NUMBER() OVER(");
BuildOrderBy(sb, connection, false);
sb.Append(@") AS __ROWID__");
sb.Append(@" FROM ");
if (Schema != null)
{
if (Schema.DatabaseOwner.Length > 0)
{
sb.Append(connection.WrapFieldName(Schema.DatabaseOwner));
sb.Append('.');
}
sb.Append(connection.WrapFieldName(_SchemaName));
}
else
{
sb.Append(@"(");
if (_FromExpression is dg.Sql.IPhrase)
{
sb.Append(((dg.Sql.IPhrase)_FromExpression).BuildPhrase(connection, this));
}
else sb.Append(_FromExpression);
sb.Append(@") ");
sb.Append(connection.WrapFieldName(_FromExpressionTableAlias));
}
BuildJoin(sb, connection);
if (_ListWhere != null && _ListWhere.Count > 0)
{
sb.Append(@" WHERE ");
_ListWhere.BuildCommand(sb, connection, this, null, null);
}
sb.Append(@") SELECT * FROM [Ordered Table]");
if (Limit > 0) sb.AppendFormat(@" WHERE __ROWID__ BETWEEN {0} AND {1}", Offset + 1, Offset + 1 + Limit);
else sb.AppendFormat(@" WHERE __ROWID__ > {0}", Offset);
}
private void BuildSelectList(StringBuilder sb, ConnectorBase connection)
{
if (_ListSelect == null || _ListSelect.Count == 0)
{
sb.Append("*");
}
else
{
bool bFirst = true;
foreach (SelectColumn sel in _ListSelect)
{
if (bFirst) bFirst = false;
else sb.Append(',');
if (sel.ObjectType == ValueObjectType.Value)
{
if (sel.Value is Query)
{
sb.Append('(');
sb.Append(((Query)sel.Value).BuildCommand(connection));
sb.Append(')');
}
else
{
sb.Append(connection.PrepareValue(sel.Value, this));
}
if (!string.IsNullOrEmpty(sel.Alias))
{
sb.Append(@" AS ");
sb.Append(connection.WrapFieldName(sel.Alias));
}
}
else if (sel.ObjectType == ValueObjectType.Literal)
{
if (string.IsNullOrEmpty(sel.Alias))
{
sb.Append(sel.Value.ToString());
}
else
{
sb.Append(sel.Value.ToString());
sb.Append(@" AS ");
sb.Append(connection.WrapFieldName(sel.Alias));
}
}
else
{
if (_ListJoin != null && _ListJoin.Count > 0 && string.IsNullOrEmpty(sel.TableName))
{
if (Schema != null)
{
if (Schema.DatabaseOwner.Length > 0)
{
sb.Append(connection.WrapFieldName(Schema.DatabaseOwner));
sb.Append('.');
}
sb.Append(connection.WrapFieldName(_SchemaName));
}
else sb.Append(connection.WrapFieldName(_FromExpressionTableAlias));
sb.Append('.');
sb.Append(sel.Value == null ? "*" : connection.WrapFieldName(sel.Value.ToString()));
if (!string.IsNullOrEmpty(sel.Alias))
{
sb.Append(@" AS ");
sb.Append(connection.WrapFieldName(sel.Alias));
}
}
else
{
if (!string.IsNullOrEmpty(sel.TableName))
{
sb.Append(connection.WrapFieldName(sel.TableName));
sb.Append('.');
}
sb.Append(sel.Value == null ? "*" : connection.WrapFieldName(sel.Value.ToString()));
if (!string.IsNullOrEmpty(sel.Alias))
{
sb.Append(@" AS ");
sb.Append(connection.WrapFieldName(sel.Alias));
}
}
}
}
}
}
private static void BuildSingleValue(
StringBuilder outputBuilder, ConnectorBase conn,
string firstTableName, object value, ValueObjectType valueType,
string otherTableName, object otherValue, ValueObjectType otherType,
Query relatedQuery,
TableSchema rightTableSchema, string rightTableName)
{
if (valueType == ValueObjectType.Value)
{
if (value is Query)
{
outputBuilder.Append('(');
outputBuilder.Append(((Query)value).BuildCommand(conn));
outputBuilder.Append(')');
}
else if (value is WhereList)
{
outputBuilder.Append('(');
((WhereList)value).BuildCommand(outputBuilder, conn, relatedQuery, rightTableSchema, rightTableName);
outputBuilder.Append(')');
}
else if (value is ICollection)
{
ICollection collIn = value as ICollection;
StringBuilder sbIn = new StringBuilder();
sbIn.Append('(');
bool first = true;
TableSchema schema = null;
if (object.ReferenceEquals(otherTableName, JoinColumnPair.RIGHT_TABLE_PLACEHOLDER_ID))
{
schema = rightTableSchema;
}
else
{
if (relatedQuery != null)
{
if (otherTableName == null || !relatedQuery.TableAliasMap.TryGetValue(otherTableName, out schema))
{
schema = relatedQuery.Schema;
}
}
}
foreach (object objIn in collIn)
{
if (first) first = false;
else sbIn.Append(',');
if (schema != null)
{
sbIn.Append(Query.PrepareColumnValue(schema.Columns.Find((string)otherValue), objIn, conn, relatedQuery));
}
else
{
sbIn.Append(conn.PrepareValue(objIn, relatedQuery));
}
}
if (first)
{
sbIn.Append("NULL"); // Avoid exceptions, create a NULL list, where the condition will always return FALSE
}
sbIn.Append(')');
outputBuilder.Append(sbIn.ToString());
}
else if (otherType == ValueObjectType.ColumnName)
{
TableSchema schema = null;
if (object.ReferenceEquals(otherTableName, JoinColumnPair.RIGHT_TABLE_PLACEHOLDER_ID))
{
schema = rightTableSchema;
}
else
{
if (relatedQuery != null)
{
if (otherTableName == null || !relatedQuery.TableAliasMap.TryGetValue(otherTableName, out schema))
{
schema = relatedQuery.Schema;
}
}
}
if (schema != null)
{
// Try to match value type to the other value type
outputBuilder.Append(Query.PrepareColumnValue(schema.Columns.Find((string)otherValue), value, conn, relatedQuery));
}
else
{
// Format it according to generic rules
outputBuilder.Append(conn.PrepareValue(value, relatedQuery));
}
}
else
{
outputBuilder.Append(conn.PrepareValue(value, relatedQuery));
}
}
else if (valueType == ValueObjectType.ColumnName)
{
if (firstTableName != null)
{
if (object.ReferenceEquals(firstTableName, JoinColumnPair.RIGHT_TABLE_PLACEHOLDER_ID))
{
outputBuilder.Append(conn.WrapFieldName(rightTableName));
}
else
{
outputBuilder.Append(conn.WrapFieldName(firstTableName));
}
outputBuilder.Append('.');
}
outputBuilder.Append(conn.WrapFieldName((string)value));
}
else
{
outputBuilder.Append(value == null ? @"NULL" : value);
}
}
public string Build(ConnectorBase conn, Query relatedQuery = null)
{
string ret = "";
if (Type == ValueObjectType.ColumnName)
{
if (TableName != null && TableName.Length > 0)
{
ret += conn.WrapFieldName(TableName);
ret += ".";
}
ret += conn.WrapFieldName(Value.ToString());
}
else if (Type == ValueObjectType.Value)
{
ret += @"(" + conn.PrepareValue(Value, relatedQuery) + @")";
}
else
{
ret += Value;
}
return ret;
}
public string BuildPhrase(ConnectorBase conn, Query relatedQuery = null)
{
StringBuilder sb = new StringBuilder();
if (conn.TYPE == ConnectorBase.SqlServiceType.MSSQL)
{
}
else
{
if (conn.TYPE == ConnectorBase.SqlServiceType.POSTGRESQL)
{
sb.Append(@"ST_Contains(");
}
else // MYSQL
{
sb.Append(@"MBRContains(");
}
}
if (OuterValueType == ValueObjectType.ColumnName)
{
if (OuterTableName != null && OuterTableName.Length > 0)
{
sb.Append(conn.WrapFieldName(OuterTableName));
sb.Append(".");
}
sb.Append(conn.WrapFieldName(OuterValue.ToString()));
}
else if (OuterValueType == ValueObjectType.Value)
{
if (OuterValue is Geometry)
{
((Geometry)OuterValue).BuildValue(sb, conn);
}
else
{
sb.Append(conn.PrepareValue(OuterValue, relatedQuery));
}
}
else sb.Append(OuterValue);
if (conn.TYPE == ConnectorBase.SqlServiceType.MSSQL)
{
sb.Append(@".STContains(");
}
else // MYSQL, PostgreSQL
{
sb.Append(@",");
}
if (InnerValueType == ValueObjectType.ColumnName)
{
if (InnerTableName != null && InnerTableName.Length > 0)
{
sb.Append(conn.WrapFieldName(InnerTableName));
sb.Append(".");
}
sb.Append(conn.WrapFieldName(InnerValue.ToString()));
}
else if (InnerValueType == ValueObjectType.Value)
{
if (InnerValue is Geometry)
{
((Geometry)InnerValue).BuildValue(sb, conn);
}
else
{
sb.Append(conn.PrepareValue(InnerValue, relatedQuery));
}
}
else sb.Append(InnerValue);
sb.Append(@")");
return sb.ToString();
}