public void TestGetTheRightCopier3()
{
DbContext dc = new DbContext("SqlServer");
dc.NewTransaction(delegate()
{
IDbBulkCopy c = dc.GetDbBulkCopy();
Assert.IsNotNull(c);
Assert.IsTrue(c is SqlServerBulkCopy);
});
}
public void TestSqlServeerBulkCopy()
{
DbContext dc = new DbContext("SqlServer");
SqlStatement sql = new SqlStatement("select [Id],[Name] from [Books] order by [Id]");
List<long> rcs = new List<long>();
DbEntry.Context.ExecuteDataReader(sql, delegate(IDataReader dr)
{
dc.NewConnection(delegate()
{
IDbBulkCopy c = dc.GetDbBulkCopy();
c.BatchSize = 2;
c.DestinationTableName = "test";
c.NotifyAfter = 3;
c.SqlRowsCopied += new SqlRowsCopiedEventHandler(delegate(object sender, SqlRowsCopiedEventArgs e)
{
rcs.Add(e.RowsCopied);
});
c.WriteToServer(dr);
});
});
Assert.AreEqual(1, rcs.Count);
Assert.AreEqual(3, rcs[0]);
}
