private void CommitNewObjectsToDb(ObjectsByPropertyIndexSet plan)
{
List <MetadataProperty> metaProps = this.GetMetaProps(plan.IndexSet);
StringBuilder sql = new StringBuilder(string.Format("INSERT INTO [{0}]([{1}]", (object)this.FClass.DataTable, (object)this.FClass.IDProperty.DataField));
int paramIndex1 = 1;
StorageCommitPlan.MetaPropsToSql((IList <MetadataProperty>)metaProps, sql, ",", "[{0}]", (DataType[])null, ref paramIndex1);
sql.Append(") VALUES (?");
DataType[] paramTypes = new DataType[paramIndex1];
object[] values = new object[paramIndex1];
paramTypes[0] = DataType.String;
int paramIndex2 = 1;
StorageCommitPlan.MetaPropsToSql((IList <MetadataProperty>)metaProps, sql, ",", "?", paramTypes, ref paramIndex2);
sql.Append(")");
InDbCommand command = this.FSession.Db.CreateCommand(sql.ToString(), paramTypes);
try
{
for (int index1 = 0; index1 < plan.Count; ++index1)
{
DataObject dataObject = plan[index1];
int index2 = 1;
values[0] = (object)dataObject.Id.ToString();
StorageCommitPlan.CopyPropsToParams(dataObject, (IList <MetadataProperty>)metaProps, values, ref index2);
command.Execute(values);
}
}
finally
{
command.Dispose();
}
}
private void CommitModifiedObjectsToDb(ObjectsByPropertyIndexSet plan)
{
if (plan.IndexSet.IsEmpty)
{
return;
}
List <MetadataProperty> metaProps = this.GetMetaProps(plan.IndexSet);
StringBuilder sql = new StringBuilder(string.Format("UPDATE [{0}] SET ", (object)this.FClass.DataTable));
int paramIndex1 = 0;
StorageCommitPlan.MetaPropsToSql((IList <MetadataProperty>)metaProps, sql, (string)null, "[{0}]=?", (DataType[])null, ref paramIndex1);
sql.Append(string.Format(" WHERE [{0}]=?", (object)this.FClass.IDProperty.DataField));
DataType[] paramTypes = new DataType[paramIndex1 + 1];
object[] values = new object[paramIndex1 + 1];
int paramIndex2 = 0;
StorageCommitPlan.MetaPropsToSql((IList <MetadataProperty>)metaProps, (StringBuilder)null, (string)null, (string)null, paramTypes, ref paramIndex2);
paramTypes[paramIndex2] = DataType.String;
InDbCommand command = this.FSession.Db.CreateCommand(sql.ToString(), paramTypes);
try
{
for (int index1 = 0; index1 < plan.Count; ++index1)
{
DataObject dataObject = plan[index1];
int index2 = 0;
StorageCommitPlan.CopyPropsToParams(dataObject, (IList <MetadataProperty>)metaProps, values, ref index2);
values[index2] = (object)dataObject.Id.ToString();
command.Execute(values);
}
}
finally
{
command.Dispose();
}
}
