internal override string CreateSaveList(TableInfo baseClass, ForeignKeyInfo fkInfo, EntityBase baseInstance, out TenorParameter[] parameters, out System.Data.DataTable data)
{
IList values = (IList)fkInfo.PropertyValue(baseInstance);
data = new System.Data.DataTable();
for (int i = 0; i < fkInfo.LocalManyToManyFields.Length; i++)
{
data.Columns.Add(fkInfo.LocalManyToManyFields[i], fkInfo.LocalFields[i].RelatedProperty.PropertyType);
}
for (int i = 0; i < fkInfo.ForeignManyToManyFields.Length; i++)
{
data.Columns.Add(fkInfo.ForeignManyToManyFields[i], fkInfo.ForeignFields[i].RelatedProperty.PropertyType);
}
for (int i = 0; i < values.Count; i++)
{
System.Data.DataRow row = data.NewRow();
for (int j = 0; j < fkInfo.LocalManyToManyFields.Length; j++)
{
row[fkInfo.LocalManyToManyFields[j]] = fkInfo.LocalFields[j].PropertyValue(baseInstance);
}
for (int j = 0; j < fkInfo.ForeignFields.Length; j++)
{
row[fkInfo.ForeignManyToManyFields[j]] = fkInfo.ForeignFields[j].PropertyValue(values[i]);
}
data.Rows.Add(row);
}
const string localParamPrefix = "local{0}";
List <TenorParameter> parame = new List <TenorParameter>();
string tableExpression = GetPrefixAndTable(fkInfo.ManyToManyTablePrefix, fkInfo.ManyToManyTable);
// generating delete statement
StringBuilder sql = new StringBuilder();
sql.Append(string.Format("DELETE FROM {0} WHERE ", tableExpression));
for (int i = 0; i < fkInfo.LocalManyToManyFields.Length; i++)
{
if (i > 0)
{
sql.Append(this.GetOperator(LogicalOperator.And));
}
sql.Append(this.CommandBuilder.QuoteIdentifier(fkInfo.LocalManyToManyFields[i]));
sql.Append(" = ");
sql.Append(this.ParameterIdentifier + string.Format(localParamPrefix, i));
TenorParameter p = new TenorParameter(string.Format(localParamPrefix, i), fkInfo.LocalFields[i].PropertyValue(baseInstance));
parame.Add(p);
}
parameters = parame.ToArray();
sql.AppendLine();
return(sql.ToString());
}
