EF架构~CodeFirst自关联表的插入

时间:2020-12-22 08:42:14

回到目录

这个文章对之前EF的一个补充,对于一些自关联表的添加,如果你建立了表约束确实有这种问题,一般主键为整形自增,父ID为可空,这时,在添加时如果不为ID赋值,结果就会出错。

错误:

无法确定依赖操作的有效顺序。由于外键约束、模型要求或存储生成的值,因此可能存在依赖关系。

解决:

  [HttpPost]
public ActionResult Create(WebManageMenus entity)
{
try
{
entity.Id = -;//自关联表要主动赋值
entity.About = "";
entity.Operator = "";
menuRepository.Insert(entity);
return RedirectToAction("Index");
}
catch
{
return View();
}
}

结果:

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAATAAAABaCAIAAACwgZ0sAAAMaElEQVR4nO2d3U8bVxrG/U+gXKx6Ga4qGWn+gZW5yDW1a5SwliqrqqquuhISKXtRRdHuspIDO23WraOkTUPTfEGyKm7jKNsoTSibYsd8GQyOEzBJGgeS3ToQKBhb9uzFfPjMzBl78Ac+Ns+rnxDY8/EyOs+855yZecYiCKkivPHG74ovAACoIpa6ZwAAUCghSFRIAPYSVEgAGAIVEgCGqEiQx02EIAh1/ydJEtNXE5FriZmri1NDjyYvPQgNzt87Mzv6z6lb/RM3+7ZeTSCxRkmsKalUkL8vGtGZIFOCXJy+ks8+z2dX8tmVfCaZzzzLZ3/JZx7ndxL5zGIu/eD6+aNIrCESa1aqIEjBOIwEGfB2O3v4ksn5euy93uGSy7Q7upPyn/N+niNCs/rDiYv5TDLzOpHZSOS2luPhb2LBs9Ex3+ydk1O3POEbfw19//G3Z/+o3wvvanN7hohPwpzFov5EIj7Sd8DatSqkBCHutrZYtNEWp/0XZSVW2L7bMxTwdIm/y3sXk2wJROOr0aED8u6Jb1O8q438k0rZR0w8RPxImHqILBYLPxJWcraoDqaUdhVbeQNRH0GaUVrxxQLebo4Sdr+fl6Ue63XYfP4guVb8/tf59NL2q1jm9cP4/a/zmaf5zJN8JpHbWczvPMynY/mdhX998YFmX6vRIau1a1VuSbQoNCDe1Sa3wrjb+qa6YYU5A0GWlVjcbW0Rm7UoSLdnSD4diDsiBdkWF1IBTxfn6pMOoKfrgNV2yNpCPa1UkhjtKLWNEScFJQfl8B6wtASicd7Vpj+yVEk3MXURZKzXYTMpSI2iSMgym4wMt3P2eSE1LwuSWoQXfv4it/1wKzWb2XgQG/8yn32S3ZjLbUdzW3Pp9Uh6bXpnbfLa6fc1a/Eum6grovqRSMLTtCfO9aH5CllWYrsVZOEEEfB0yZkY1rHKjphyVpI6F8pJQbcLfQJKhZT+wT2QATvURZBBJ8cZdFmDTlrhI4NcUS6hQSdnnxdSgixIRZ+a7UfHPsv9tvDb/yZ3Xs3NjX2ezySyG5HsRiTzeiq9NpVeD2+/Cl499R65Snykz+0ZEtuNy9VZvELGR/o0p3+TlJHYbgU5IufGu9rU54W429pilHZZialyE7dsIMiC5Ix7H5aS/epmog6CTEaG2zmOowlGDaXPKde9WK/DRlOrzes95uzhxQ6tvrpO3x7I/Ta7+SKYTk3P/Mjndx5lN2ayrycz6/fTa+H0q9B2avzK525yFaXuca4+gwpJNq83A9EbnNw/NN+8ykhst4L0eLo4Vx/vahN7qpq67fF0VSkx6sjZctRz/ID6kwPWrjFChLQxJCqkjloI0tdjd/bwxbujgpAShFivoyMQiWnWLd7XVbqsychwO2fTrD5xsy+3ObH27M7my3uT//57biee3Zja/u/drRe3N1d+2lwZ3Xx++7L3Hc02yTEk5+rkaDLjR8LyYspAUduelO3o0959YvR2L587Og26rKp8Sp1fyj9iIuRMmFIhqaVSPJtgDCmYFKT+p0hZggw6OVsgEktGhh3E7CiNQkdUwbwgBdowcvz7j9Mvb//6+ObGyt3714/l0gvZ15NbKzc3kzfWnt5Yf3p97cl3F0/+Qb3NwqSfKMhD1q5VIe622uLST2nIpCmJbo9XrxkjAZSVWHmTOvQTilHTLyMxWtegbUw+GZGCVDq05JgTs6zFvq56hRTLo/J7EXXN+/l2nWKJukrptfr8QVKQGs2PXesWsqGV2KWXi9+mHl+/9+1H+fRcZv3++pPv1p98txobfBH7anXhqwufHiH3SDSvFpfLVkSQ8iq7rpDlJVbhLKtgokKWm5iEpkLqBSn/Lub5M7Xmlzcmb1wqupd1t4Kc9/PqoaNULWkbDzopg0ByVKkZYUp/GlXIfP7X0SsfZlMjT2a+fBo5m4yeTUbP/XT1T7ntyMuHl1/GLz6LfP5s+rNfpj89z3ca/L+iAC4YdVnFxZTJCeosq14AFSS2K0GSeUqfiwtHo0OHaI2+gsSki7S8q+2Qq5Po7etnd+Jua4vL1ak+LKiQxpSskNGZYHEUQYqX7DUam/fzHEWTRtOw5KiyiCCPycWzIP6VlQd3Lr2ffn75wb1/PAqeTIQ/exo5c/fKB7nt6WezZ55FTi+F+KUQvxQcGBxwavZLNOiWQPSGQYW8IcpPHr+lTFbIChILK7NHYveYHwmri562QgrqrJSFiasglScWd8vXNpULHlZr11G5E6EZQ4rHVszcoCu9v4aRFT7tYTLE6/j0YigKVem7av4kUc/TlO6ykkxM/Hj7wruvH/qmfzg+d+dv82OexP2Tty++l9+eWhz/ZHH8k+XQwHKofznUPzjwNrmicjuL3N8Lm+uyFpl0UTX9shMj5XTI1Sm28pKCFAupZgsC7YJN2YmRh07cF7kjjSCViRx92nXXRl3Yi6c9NHe30ZBKYsDbrbscoroySQi1dJeVZHz8h1vfuHdWTk1e/+iev2fm1l8WfvbdOu/ObU8kQgOJUP9yqH85eCIR9Jzrd9AylLQnC1L6XD6vkw3I8HYcaoUsOzHeZVPGXVbrm8osJefqI0o6fWJTKUdFbtOp5IjJA2/psJAnLDIZ3tWmnAWoU6xG/fwmZr88D7m19Xx29j+DA87BgbcHB5xfD3SKv+e2wonQiUToxFLQkwh6loKecyfsSIzlxJqb/f485Fcn3jrXbz/Xbz93QuStuqeExPYz+6VCAtAQ7PcKCQBToEICwBCokAAwBCokAAyBCgkAQ6BCAsAQECQADAFBAsAQECQADAHnclZ8uJEYEKrygDKcy5EYqBZ7Y+GhNXdUP6as9c5RmzgWcRVICXAul5+ignN5c7A3Fh6k5PTmjuS3QSdnO+8/3a72WdXvGs7lcC5vSkxVyNbWVuq3uxSkWOvGeh02n/+S3hC53dEdiQy3c/bRQoWk+6+KMoNzOZzLm4/SFbK1tfXgwYPUryoQZKFwkS4B6g6nfTQy/K5ki9wRiIzJPwurw7kczuVNRglBtra2Hj58uAYVUlJUMjLscHQo4hEFpsjJ1/NOIBIjVrfPF8QJ53I4lzchxQQpqrGmgvT12H3+S85CB7VD9FBuJ0aDStFzOLqTNDtzEjiXW+Bc3sgYClJRoyLICpzL6YKUh3nUWVabQxaeaI5MLFxs0hXO5XAub2joghTHja1EUBfbvSDFPqfN5w8SwzyVIOXpU0l1sn+5MmUadBrP98C5HM7ljc7eOZfP+/l2R8e7hf6kMsYrCFJ80YCiVaXbqbxWIKmegIVzOZzLm4xKBWneudzXY293dLRzXK/3tFpLRjcGkENKqWCaEyScy1UtG87lDcQeOZf7euxcoejt4k4dzbsGiDfwwLkczuVNyF487RHwdpN3tyUjgT7vaUFSKcfpXuOh7rIWZEyOLeFcDufypmS/PH7FrA83EgMk+0WQRjDrw43E9if7XZAAMAUECQBDQJAAMAQECQBDQJAAMAQECQBDQJAAMAQECQBDQJAAMAQECQBD1ESQzed3bgSzrt5IrEGpQ4VsOL9zI5h19UZijUt9KmQt/M4F6eFJivujSahWrkWADzp80KtO3SqkOUGa9DtPCbqXCGgsmJPaNCKDR7hjoymDDWrPBfqHNgX4oMMHvQYwXiFN+Z0nJWssm8Nh08hGVKnOoDUyeITjOJUgA95unz8oKr/X26/xtoMPOnzQ9wb2K6Qpv3OlBorKlO2VOX0Pdnmwk+M47sifjxEVMilZpCub0ppNUgUJH3QBPujVprEqJN3vXIPyHh7qgHB58NSokNJ0WYlX95BiLtFlhQ86fNCrTkNWSJ3fucrtSnkFnWZUqVaUfgwpOTILQkpvx0ytkPBBhw961alhhdT/FKmR37mC/Aae4klqBaley5Qg4YMOH/Sq0xAVsrTfuWJgV94sK+FqJw47S3dZ4YMOH/RawLIgU4I5v3MS/YvoDIwhKV1WghIVEj7oRJ7wQa8m9RFkLfzOBSElX7RQ9VfNC5J4rUiguCDhgw4f9BpRl5vLTcbu/M6N3glpMKRUCVKc/jE/hoQPOnzQawS7T3uY9zsX5UQKRjcm3N1+S45F4YMOH/Qawa4gWYZZV28k1uhAkNWEWVdvJNYoQJAAMAQECQBDQJAAMAQECQBDQJAAMAQECQBDWEzfN4NAIGoeECQCwVBAkAgEQwFBIhAMBQSJQDAUECQCwVBAkAgEQwFBIhAMBQSJQDAUECQCwVBAkAgEQ/F/zVva85R+5lwAAAAASUVORK5CYII=" alt="" />

回到目录