/// <summary>
/// Creates a new Insert Query object which is ready to use.
/// </summary>
/// <param name="fields">Array of EntityFieldCore objects to use to build the insert query</param>
/// <param name="fieldsPersistenceInfo">Array of IFieldPersistenceInfo objects to use to build the insert query</param>
/// <param name="query">The query object to fill.</param>
/// <param name="fieldToParameter">Hashtable which will contain after the call for each field the parameter which contains or will contain the field's value.</param>
/// <remarks>Generic version.</remarks>
/// <exception cref="System.ArgumentNullException">When fields is null or fieldsPersistenceInfo is null</exception>
/// <exception cref="System.ArgumentException">When fields contains no EntityFieldCore instances or fieldsPersistenceInfo is empty.</exception>
/// <exception cref="ORMQueryConstructionException">When there are no fields to insert in the fields list. This exception is to prevent
/// INSERT INTO table () VALUES () style queries.</exception>
protected override void CreateSingleTargetInsertDQ(IEntityFieldCore[] fields, IFieldPersistenceInfo[] fieldsPersistenceInfo,
IActionQuery query, Dictionary <IEntityFieldCore, DbParameter> fieldToParameter)
{
TraceHelper.WriteLineIf(Switch.TraceInfo, "CreateSingleTargetInsertDQ", "Method Enter");
QueryFragments fragments = new QueryFragments();
fragments.AddFormatted("INSERT INTO {0}", this.Creator.CreateObjectName(fieldsPersistenceInfo[0]));
DelimitedStringList fieldNames = fragments.AddCommaFragmentList(true);
fragments.AddFragment("VALUES");
DelimitedStringList valueFragments = fragments.AddCommaFragmentList(true);
DbParameter newParameter;
bool hasIdentity = false;
for (int i = 0; i < fields.Length; i++)
{
IEntityFieldCore field = fields[i];
IFieldPersistenceInfo persistenceInfo = fieldsPersistenceInfo[i];
if (string.IsNullOrEmpty(persistenceInfo.IdentityValueSequenceName))
{
if (!CheckIfFieldNeedsInsertAction(field))
{
continue;
}
fieldNames.Add(this.Creator.CreateFieldNameSimple(persistenceInfo, field.Name));
AppendFieldToValueFragmentsForInsert(query, fieldToParameter, valueFragments, field, persistenceInfo);
}
else
{
newParameter = this.Creator.CreateParameter(field, persistenceInfo, ParameterDirection.InputOutput);
query.AddParameterFieldRelation(field, newParameter, persistenceInfo.TypeConverterToUse, parameterValueCanBeNull: false);
query.AddSequenceRetrievalQuery(CreateCommand("SELECT @@IDENTITY", query.Connection), false).AddSequenceParameter(newParameter);
hasIdentity = true;
fieldToParameter.Add(field, newParameter);
}
}
if (fieldNames.Count <= 0)
{
if (hasIdentity)
{
// a table with just 1 identity field, use a special case query: INSERT INTO table values ()
fieldNames.Clear();
valueFragments.Clear();
fragments.AddFragment("()");
}
else
{
throw new ORMQueryConstructionException("The insert query doesn't contain any fields.");
}
}
query.SetCommandText(MakeParametersAnonymous(fragments.ToString(), query.Parameters));
TraceHelper.WriteIf(Switch.TraceVerbose, query, "Generated Sql query");
TraceHelper.WriteLineIf(Switch.TraceInfo, "CreateSingleTargetInsertDQ", "Method Exit");
}
/// <summary>
/// Adds the passed in fieldpersistenceinfo object to the list of persistence info objects already in the bucket, with the passed in
/// fieldname as key.
/// </summary>
/// <param name="fieldName">name of field the persistenceinfo object is for</param>
/// <param name="persistenceInfo">persistenceinfo object to store</param>
public void AddFieldPersistenceInfo(string fieldName, IFieldPersistenceInfo persistenceInfo)
{
_fieldPersistenceInfos.Add(fieldName, persistenceInfo);
// add to sorted list with the count as the key
_fieldPersistenceInfosPerIndex.Add(_fieldPersistenceInfosPerIndex.Count, persistenceInfo);
}
