/// <summary>
/// 获取Sql语句内容
/// </summary>
/// <returns>Sql语句内容</returns>
public override String GetCommandText()
{
SqlCommandBuilder sb = new SqlCommandBuilder(this.Database);
sb.AppendDeletePrefix().AppendTableName(this._tableName).AppendWhere(this._where);
return sb.ToString();
}
/// <summary>
/// 获取Sql语句内容
/// </summary>
/// <returns>Sql语句内容</returns>
public override String GetCommandText()
{
SqlCommandBuilder sb = new SqlCommandBuilder(this._database);
sb.AppendUpdatePrefix().AppendTableName(this._tableName);
if (this._parameters.Count > 0)
{
sb.AppendUpdateSet();
}
sb.AppendAllParameterEquations(this._parameters).AppendWhere(this._where);
return sb.ToString();
}
/// <summary>
/// 获取Sql语句内容
/// </summary>
/// <returns>Sql语句内容</returns>
public override String GetCommandText()
{
SqlCommandBuilder sb = new SqlCommandBuilder(this.Database);
sb.AppendInsertPrefix().AppendTableName(this._tableName);
if (this._parameters.Count > 0)
{
sb.AppendAllColumnNamesWithParentheses(this._parameters).AppendInsertValues().AppendAllParameterNamesWithParentheses(this._parameters);
}
return sb.ToString();
}