private string GetParamName(int index)
{
IParameterNameGenerator parameterNameGenerator = DatabaseConnection.CurrentConnection.CreateParameterNameGenerator();
for (int i = 0; i < index; i++)
{
parameterNameGenerator.GetNextParameterName();
}
return(parameterNameGenerator.GetNextParameterName());
}
public void TestCreateParameterNameGenerator()
{
//---------------Set up test pack-------------------
IDatabaseConnection databaseConnection = new DatabaseConnectionMySql("", "");
//---------------Assert PreConditions---------------
//---------------Execute Test ----------------------
IParameterNameGenerator generator = databaseConnection.CreateParameterNameGenerator();
//---------------Test Result -----------------------
Assert.AreEqual("?", generator.PrefixCharacter);
//---------------Tear Down -------------------------
}
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>
/// Initialises the sql statement with a autoincrementing object
/// </summary>
private void InitialiseStatement(string tableName, ISupportsAutoIncrementingField supportsAutoIncrementingField)
{
_dbFieldList = new StringBuilder(_bo.Props.Count * 20);
_dbValueList = new StringBuilder(_bo.Props.Count * 20);
var statement = new InsertSqlStatement(_connection);
statement.TableName = tableName;
statement.SupportsAutoIncrementingField = supportsAutoIncrementingField;
_insertSql = statement;
_gen = _connection.CreateParameterNameGenerator();
_firstField = true;
}
/// <summary>
/// Constructor to initialise a new sql statement
/// </summary>
/// <param name="connection">A database connection</param>
public SqlStatement(IDatabaseConnection connection)
{
if (connection == null) throw new ArgumentNullException("connection");
_parameters = new List<IDbDataParameter>();
DatabaseConnection = connection;
_idbConnection = DatabaseConnection.GetConnection();
if (_idbConnection != null)
{
_sampleCommand = _idbConnection.CreateCommand();
_gen = connection.CreateParameterNameGenerator();
}
else
{
_gen = new ParameterNameGenerator(null);
}
_statement = new StringBuilder(100);
}
/// <summary>
/// Constructor to initialise a new sql statement
/// </summary>
/// <param name="connection">A database connection</param>
public SqlStatement(IDatabaseConnection connection)
{
if (connection == null)
{
throw new ArgumentNullException("connection");
}
_parameters = new List <IDbDataParameter>();
DatabaseConnection = connection;
_idbConnection = DatabaseConnection.GetConnection();
if (_idbConnection != null)
{
_sampleCommand = _idbConnection.CreateCommand();
_gen = connection.CreateParameterNameGenerator();
}
else
{
_gen = new ParameterNameGenerator(null);
}
_statement = new StringBuilder(100);
}
/// <summary>
/// Initialises the sql statement with a autoincrementing object
/// </summary>
private void InitialiseStatement(string tableName, ISupportsAutoIncrementingField supportsAutoIncrementingField)
{
_dbFieldList = new StringBuilder(_bo.Props.Count * 20);
_dbValueList = new StringBuilder(_bo.Props.Count * 20);
var statement = new InsertSqlStatement(_connection);
statement.TableName = tableName;
statement.SupportsAutoIncrementingField = supportsAutoIncrementingField;
_insertSql = statement;
_gen = _connection.CreateParameterNameGenerator();
_firstField = true;
}
