public void Update <TDataObject>(IList <TDataObject> objs)
where TDataObject : class, IIntKeyedDataObject, new()
{
//TODO: Update cache here. not only delete cached items
if (objs.Count > 0)
{
using (var scope = DBScope("Updating multiple " + typeof(TDataObject).Name + ". Count = " + objs.Count))
{
RunInTransaction(scope.Connection, (cn, transaction) =>
{
using (var cmd = cn.CreateCommand())
{
var sc = new SqlSerializationContext((SqlCommand)cmd);
foreach (var o in objs)
{
DataObjectSqlSerializer <TDataObject> .AppendUpdateSql(sc, o);
Logger.WriteLine("ID = " + o.ID);
sc.Next();
CacheIt(o);
}
sc.Finish();
cmd.Transaction = transaction;
cmd.LexExecuteNonQuery();
}
});
}
}
}
public void Insert <TDataObject>(IList <TDataObject> objs)
where TDataObject : class, IIntKeyedDataObject, new()
{
if (objs.Count > 0)
{
using (var scope = DBScope("Inserting multiple " + typeof(TDataObject).Name + ". Count = " + objs.Count))
{
RunInTransaction(scope.Connection, (cn, transaction) =>
{
using (var cmd = cn.CreateCommand())
{
cmd.Transaction = transaction;
var sc = new SqlSerializationContext((SqlCommand)cmd);
foreach (var o in objs)
{
if (o.ID != 0)
{
throw new DMError("DataObject has been already inserted.");
}
DataObjectSqlSerializer <TDataObject> .AppendInsertSql(sc, o);
sc.Next();
}
sc.Finish();
using (var r = cmd.LexExecuteReader())
{
int i = 0, c = objs.Count;
while (true)
{
if (!r.Read())
{
throw new DMError("Invalid Data Reader");
}
int id = Convert.ToInt32(r.GetDecimal(0));
TDataObject obj = objs[i];
DataObjectSqlSerializer <TDataObject> .KeyColumn.Storage.SetValue(obj, id);
CacheIt(obj);
Added <TDataObject>();
Logger.WriteLine("ID = " + id);
++i;
if (i < c)
{
r.NextResult();
}
else
{
break;
}
}
}
}
});
}
}
}
