I have 2 entities Documents(Id,Number,Content,Date\_Added) and Adocuments(archives of documents)(Ida,Number,Content,Date\_Added) and I want to **move** the Documents (for example) from march in my archive entity. My tables have the same fields.

Select part

```
WPF_TestEntities WPFModel;
DateTime init_per = new DateTime(2012, 03, 01);
DateTime fina_per = new DateTime(2012, 03, 31);
var qry = from d in WPFModel.Document // qry - documents form march
          where d.Date_Added >= init_per &&  d.Date_Added <= fina_per
          select d;

```

Insert part

```
//WPFModel.Adocument.Insert/Add(qry);

```

After that I can delete the march documents from the Document entity.

How can I move the data(qry) from Documents to Adocuments? (will there be any problems with the uniqueness of my Id ?)