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());
}