Всем доброго времени суток!
Сейчас пишу тестовое приложение для переноса данных из старой бд в нормализированную новую БД.
Использую EF6, MSSQL.
Суть проблемы:
| C# |
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
| using System;
using System.Collections.Generic;
using System.Data.Entity.Validation;
using System.Linq;
using ModelLibrary;
using MySQLEntity;
namespace ConsoleApplication1
{
class Program
{
static void Main(string[] args)
{
productionEntities oldEntities = new productionEntities();
IEntities newEntities = new IEntities();
IQueryable<incoming> all = from i in oldEntities.incoming where i.delete_inc == 1
select i;
Guid guidStages = new Guid("C62F2F7C-60B2-4D96-8E1E-87F8DA1CCE35");
Guid guidTypes = new Guid("B94DAF2D-D826-4F51-9B7B-79CA2BAC4FD3");
Random rnd = new Random();
List<Categorie> catList = newEntities.Categories.ToList();
foreach (incoming inc in all)
{
int catrnd = rnd.Next(0, 4);
if (inc.date_inc != null)
{
if (inc.kaoutnum_inc != null)
{
if (inc.kaoutdate_inc != null)
{
Incomings incomings = new Incomings();
{
incomings.Num = inc.num_inc;
incomings.Date = (DateTime) inc.date_inc;
incomings.Summary = inc.summary_inc;
incomings.Stages = newEntities.Stages.SingleOrDefault(s => s.Id == guidStages);
incomings.Types = newEntities.Types.SingleOrDefault(t => t.Id == guidTypes );
incomings.Categories = catList[catrnd];
incomings.OrgOutNum = inc.kaoutnum_inc;
incomings.OrgOutDate = inc.kaoutdate_inc;
incomings.DirMark = inc.gendirresol_inc;
}
newEntities.Incomings.Add(incomings);
}
}
}
}
try
{
int changes = newEntities.SaveChanges();
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Value: \"{1}\", Error: \"{2}\"",
ve.PropertyName,
eve.Entry.CurrentValues.GetValue<object>(ve.PropertyName),
ve.ErrorMessage);
}
}
Console.ReadKey();
}
Console.ReadKey();
}
}
} |
|
При выполнении вызывает Эксепшн
Кликните здесь для просмотра всего текста
An unhandled exception of type 'System.Data.Entity.Infrastructure.DbUpdateException' occurred in EntityFramework.dll
Additional information: Entities in 'IEntities.Documents' participate in the 'DocumentsStages' relationship. 0 related 'Stages' were found. 1 'Stages' is expected.
Модель в которую переносим данные:
(
