private string GetParamName(int index)
{
IParameterNameGenerator parameterNameGenerator = DatabaseConnection.CurrentConnection.CreateParameterNameGenerator();
for (int i = 0; i < index; i++)
{
parameterNameGenerator.GetNextParameterName();
}
return(parameterNameGenerator.GetNextParameterName());
}
/// <summary>
/// Adds a parameter to the sql statement
/// </summary>
/// <param name="obj">The parameter to add</param>
public void AddParameterToStatement(object obj)
{
string paramName = _gen.GetNextParameterName();
this.AddParameter(paramName, obj);
this.Statement.Append(paramName);
}
public void TestCreateParameterNameGenerator()
{
//---------------Set up test pack-------------------
IDatabaseConnection databaseConnection = new DatabaseConnectionMySql("", "");
//---------------Assert PreConditions---------------
//---------------Execute Test ----------------------
IParameterNameGenerator generator = databaseConnection.CreateParameterNameGenerator();
//---------------Test Result -----------------------
Assert.IsNotNull(generator);
Assert.AreEqual("?Param0", generator.GetNextParameterName());
//---------------Tear Down -------------------------
}
/// <summary>
/// Adds the specified property value as a parameter
/// </summary>
/// <param name="prop">The business object property</param>
private void AddPropToInsertStatement(BOProp prop)
{
if (!_firstField)
{
_dbFieldList.Append(", ");
_dbValueList.Append(", ");
}
_dbFieldList.Append(_connection.SqlFormatter.DelimitField(prop.DatabaseFieldName));
string paramName = _gen.GetNextParameterName();
_dbValueList.Append(paramName);
_insertSql.AddParameter(paramName, prop.Value, prop.PropertyType);
_firstField = false;
}