public TransactionResult AddManyToManyRelation(ManyToManyRelation attribute, object sourceId, Model model)
{
TransactionResult result = new TransactionResult(SQLiteErrorCode.Ok, null);
if (model != null)
{
var query = string.Format("INSERT INTO {0} ({1}, {2}) VALUES('{3}', '{4}')",
attribute.JoinTable,
attribute.JoinSourceId,
attribute.JoinTargetId,
sourceId,
model.PrimaryKeyValue
);
result = this.WriteQuery(query);
}
return(result);
}
public TransactionResult AddManyToManyRelations(ManyToManyRelation attribute, object sourceId, IDictionary models)
{
TransactionResult result = new TransactionResult(SQLiteErrorCode.Ok, null);
if (models != null)
{
foreach (object targetId in models.Keys)
{
var query = string.Format("INSERT INTO {0} ({1}, {2}) VALUES('{3}', '{4}')",
attribute.JoinTable,
attribute.JoinSourceId,
attribute.JoinTargetId,
sourceId,
targetId
);
result = this.WriteQuery(query);
}
}
return(result);
}