将数据从一个网站集获取到同一web应用程序sharepoint 2016中的另一个网站集

ClientContext context = new ClientContext("https://source-site-url");
context.Credentials = new NetworkCredential("username", "password");

List sourceList = context.Web.Lists.GetByTitle("ListName");
CamlQuery query = new CamlQuery();
ListItemCollection items = sourceList.GetItems(query);
context.Load(items);
context.ExecuteQuery();

ListCreationInformation listInfo = new ListCreationInformation();
listInfo.Title = "ListName";
listInfo.TemplateType = (int)ListTemplateType.GenericList;
List targetList = context.Web.Lists.Add(listInfo);
context.ExecuteQuery();

foreach (ListItem item in items)
{
    ListItemCreationInformation itemInfo = new ListItemCreationInformation();
    ListItem newItem = targetList.AddItem(itemInfo);
    newItem["ColumnName"] = item["ColumnName"];
    newItem.Update();
    context.ExecuteQuery();
}

context.Dispose();