public override string ToString() { var result = CommandText.ToString(); foreach (var sqlParameter in ParameterCollection) { if (result.Contains(sqlParameter.ParameterName)) { switch (sqlParameter.DbType) { case DbType.AnsiString: case DbType.AnsiStringFixedLength: case DbType.Date: case DbType.DateTime: case DbType.DateTime2: case DbType.DateTimeOffset: case DbType.Guid: case DbType.String: case DbType.StringFixedLength: case DbType.Time: result = result.Replace(sqlParameter.ParameterName, $"'{sqlParameter.Value.ToString()}'"); break; default: result = result.Replace(sqlParameter.ParameterName, $"{sqlParameter.Value.ToString()}"); break; } } } return(result); }
private SqlCommand GenerateSqlCommand() { var result = new SqlCommand(CommandText.ToString(), Connection); if (Transaction != null) { result.Transaction = Transaction; } result.Parameters.AddRange(ParameterCollection.ToArray()); return(result); }
public bool EndOfList(string replaceWith) { bool flag = false; string input = CommandText.ToString(); var match = TrailingCommaRegex.Match(input); if (match.Success) { CommandText.Clear(); CommandText.Append(input.Remove(input.Length - match.Groups["FullOperator"].Length, match.Groups["FullOperator"].Length)); CommandText.Append(replaceWith); CommandText.Append(match.Groups["LineSuffix"].Value); flag = true; } return(flag); }
public void QueryNoReader() { if (_dbConnector != null || Reader != null) { throw new AegisException(AegisResult.DataReaderNotClosed, "There is already an open DataReader associated with this Connection which must be closed first."); } _dbConnector = _pool.GetDBC(); _command.Connection = _dbConnector.Connection; _command.CommandText = CommandText.ToString(); Prepare(); _command.ExecuteNonQuery(); _dbConnector.QPS.Add(1); EndQuery(); }
public bool EndOfWhere(string replaceWith) { bool flag = false; string input = CommandText.ToString(); Match match = TrailingWhereAndOrRegex.Match(input); if (match.Success) { CommandText.Clear(); CommandText.Append(input.Remove(input.Length - match.Groups["FullOperator"].Length, match.Groups["FullOperator"].Length)); if (match.Groups["Operator"].Value.Equals("where", StringComparison.InvariantCultureIgnoreCase)) { CommandText.Append(match.Groups["LinePrefix"].Value); } CommandText.Append(replaceWith); CommandText.Append(match.Groups["LineSuffix"].Value); flag = true; } return(flag); }