private void SetManyToManyRelation(Type t, object key1, object key2)
{
if ((Info.CrossTables.ContainsKey(t) && (key1 != null)) && (key2 != null))
{
CrossTable table = Info.CrossTables[t];
var builder = new InsertStatementBuilder(new FromClause(table.Name));
builder.Values.Add(new KeyOpValue(table[0].Column, key1, KvOpertation.None));
builder.Values.Add(new KeyOpValue(table[1].Column, key2, KvOpertation.None));
SqlStatement sql = builder.ToSqlStatement(Provider.Dialect, Info.QueryRequiredFields, Info.AllowSqlLog);
Provider.ExecuteNonQuery(sql);
}
}
public void WriteToServer(DataRow[] rows)
{
ProcessWrite(delegate
{
foreach (DataRow dr in rows)
{
var sb = new InsertStatementBuilder(new FromClause(this.DestinationTableName));
var dcc = dr.Table.Columns;
for (int i = 0; i < dcc.Count; i++)
{
object o = GetValue(dr[i]);
sb.Values.Add(new KeyOpValue(dcc[i].ColumnName, o, KvOpertation.None));
}
if (!WriteSingleToServer(sb)) { break; }
}
});
}
protected virtual object ExecuteInsertIntKey(InsertStatementBuilder sb, ObjectInfo info, DataProvider provider)
{
SqlStatement sql = sb.ToSqlStatement(provider.Dialect, null, info.AllowSqlLog);
sql.SqlCommandText = AddIdentitySelectToInsert(sql.SqlCommandText);
return provider.ExecuteScalar(sql);
}
public virtual object ExecuteInsert(InsertStatementBuilder sb, ObjectInfo info, DataProvider provider)
{
if (info.HasOnePrimaryKey && info.KeyMembers[0].MemberType == typeof(Guid))
{
if(info.KeyMembers[0].Is.DbGenerateGuid)
{
Guid key = Util.NewGuid();
sb.Values[0].Value = key;
}
SqlStatement sql = sb.ToSqlStatement(provider.Dialect, null, info.AllowSqlLog);
provider.ExecuteNonQuery(sql);
return sb.Values[0].Value;
}
return ExecuteInsertIntKey(sb, info, provider);
}
private bool WriteSingleToServer(InsertStatementBuilder sb)
{
SqlStatement sql = sb.ToSqlStatement(_provider.Dialect, null);
sql.SqlTimeOut = _bulkCopyTimeout;
_provider.ExecuteNonQuery(sql);
_count++;
if (_batchSize > 0 && (_count % _batchSize) == 0)
{
var cc = Scope<ConnectionContext>.Current;
cc.Commit();
cc.BeginTransaction();
}
if (SqlRowsCopied != null && _notifyAfter > 0 && ((_count % _notifyAfter) == 0))
{
var e = new SqlRowsCopiedEventArgs(_count);
SqlRowsCopied(this, e);
if (e.Abort) { return false; }
}
return true;
}
public void WriteToServer(IDataReader reader)
{
ProcessWrite(delegate
{
while (reader.Read())
{
var sb = new InsertStatementBuilder(new FromClause(this.DestinationTableName));
for (int i = 0; i < reader.FieldCount; i++)
{
object o = GetValue(reader[i]);
sb.Values.Add(new KeyOpValue(reader.GetName(i), o, KvOpertation.None));
}
if (!WriteSingleToServer(sb)) { break; }
}
});
}
public virtual InsertStatementBuilder GetInsertStatementBuilder(object obj)
{
var isv = new InsertStatementBuilder(this.Context.Info.From);
this.Context.Handler.SetValuesForInsert(isv, obj);
return isv;
}
