internal string CreateBulkInsertStatementWithParameter(ITableData data, string tableName, List <OdbcParameter> parameters) { QueryText.Clear(); TableName = tableName; GetSourceAndDestColumnNames(data); AppendBeginSql(tableName); while (data.Read()) { QueryText.Append("("); string[] placeholder = new string[DestColumnNames.Count]; QueryText.Append(string.Join(",", placeholder.Select(s => s + "?"))); QueryText.AppendLine(")"); foreach (string destColumnName in DestColumnNames) { int colIndex = data.GetOrdinal(destColumnName); string dataTypeName = data.GetDataTypeName(colIndex); if (data.IsDBNull(colIndex)) { parameters.Add(new OdbcParameter(destColumnName, DBNull.Value)); } else { parameters.Add(new OdbcParameter(destColumnName, data.GetValue(colIndex))); } } if (data.NextResult()) { QueryText.Append(","); } } AppendEndSql(); return(QueryText.ToString()); }
internal string CreateBulkInsertStatement(ITableData data, string tableName) { InitObjects(); GetSourceAndDestColumNames(data); AppendBeginSql(tableName); ReadDataAndCreateQuery(data); AppendEndSql(); return(QueryText.ToString()); }
/// <summary> /// Returns a <see cref = "System.String" /> that represents this instance. /// </summary> /// <returns> /// A <see cref = "System.String" /> that represents this instance. /// </returns> public override string ToString() { var trim = QueryText.ToString().Trim(); if (isSpatialQuery) { return(string.Format(CultureInfo.InvariantCulture, "{0} Lat: {1} Lng: {2} Radius: {3}", trim, lat, lng, radius)); } return(trim); }
/// <summary> /// Returns a <see cref = "System.String" /> that represents this instance. /// </summary> /// <returns> /// A <see cref = "System.String" /> that represents this instance. /// </returns> public override string ToString() { var trim = QueryText.ToString().Trim(); if (isSpatialQuery) { return(string.Format(CultureInfo.InvariantCulture, "{0} SpatialField: {1} QueryShape: {2} Relation: {3}", trim, spatialFieldName, queryShape, spatialRelation)); } return(trim); }
public object Execute(Expression expression) { ProcessExpression(expression); luceneQuery = session.LuceneQuery <T>(indexName); var documentQuery = luceneQuery.Where(QueryText.ToString()); if (skipValue.HasValue) { documentQuery = documentQuery.Skip(skipValue.Value); } if (takeValue.HasValue) { documentQuery = documentQuery.Take(takeValue.Value); } documentQuery = documentQuery.SelectFields <T>(FieldsToFetch.ToArray()); if (customizeQuery != null) { customizeQuery(documentQuery); } return(documentQuery); }
/// <summary> /// Returns a <see cref = "System.String" /> that represents this instance. /// </summary> /// <returns> /// A <see cref = "System.String" /> that represents this instance. /// </returns> public override string ToString() { return(QueryText.ToString()); }