EF 主键自增、级联删除

时间:2021-01-11 20:42:30

一、主键自增

1.设置数据库中,主键自增

2.设置VS中Model1.edmx

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAioAAAFPCAIAAADsg3KQAAAgAElEQVR4nO2d/W9c13nnL2BLFEn3L9ACCwMLZNVudrtrIK3Hrhqy7P6wIMsiSFrZadcqk84CBGoWYQu/BG0Vg2p2y13vSGYYqYyzaSSQaRg7qWkNmTi0bLphGGpsmbRsSh65YixbsWi98G2oqJJ494dzX87bvXNfzpl778z3gy8M8vLOULry3M8855w5j/H/np9BEARBkBrH+MnpCwiCIAhS40A/CIIgSAKBfhAEQZAEAv0gCIIgCQT6QRAEQRKI8au5P0ht9tz/OaTOEuf/h6dHfty1/yk33yybCxNd+ydOXZ77kn3k0g+/Qf77pR9evfTDb3Ttf6rrK3OXnBP2P9W1/6kv/fDqqW8+xTwVgmQqZl0A/SA1jUL9HF64+oOvPGXp5ytzl4T/uS3HEP18syx/BbBmQpBMRLMXagT0g9Q0CvWDIA2bpMWhBugHqWmgHwSJn6TFoQbjV3N/mNokfq9ElCfO/w/QD4KQJC0ONRjm+rMIksJAPwjilaTFoQboB0lpoB8E8UrS4lCDsQ2AZj766ErYPD3yY+gHQbyStDjUYCT9BwD1j0L9JP1XAQAoA/oB2oF+AAAi0A/QTkT9PPCHXKAfAOoJ6AdoB/oBAIhAP0A70A8AQAT6Adrxcszf/q+j0A8ADQv0A7Tj5R6S9OinmDcMI1fw2JvULBdyhmEY+aLWPwQADQP0A7Tj4x4vA4XRTzFvEGgxWK4IZYsw+nGeX/obuGciJ9vfUw+1Dzp/Bfop+YOSx4f51e7T5Yvik7N/cf9fITsNWgbhgX6AdvzdIzVQJP1Qd0D3xqhHP/SNN5R+mDt2OP1Yx6P+6mr6oZ6wyq+grwjtRO9Lp5hyIQfb1QPQD9BOVfeIBgqtn1wuR90ry4Ucf4i54VL3LqpMYu/c7vnWIXHwjRwJpR/yrO6fM0/ph3si5iD5hn/KcIUX/YT889l/W0ohnr+C/vszz1Ar/0A/dQL0A7QTdeXbPi6++snn3ZslsQ99RHyz73XcuxxRqB/+Rs39OtEWwu9WrZ8wv4J+iKgf4gb6jyEVP3Ua/45AED/znDm3Msvl8zkjEQECJUA/QDvR9PNrD+zj4qufQtG5W5YLOcPIF6nbJ3uzdb9jjlPfCHf+XKGsRj/y+RIf/Rji2VF/tb9+ghdY9B9CHHzjHlbM80UWLVT6Ajh/MOd0p8rhnpOqfqjTi3mURBkD+gHaqY1+LJlY2skXqXsWO/XvfitbEkCJhrv1q9GP82PaKT6Db1L5pKf64ZRp8iNjfEXCGIW7lNI5KaqiEp+E/gWwT/aAfoB2aqUfahbIlY7k9u58x95x3TsyrwtCWP04P6EfWMwzt2bpjBDzJNSwnyiLUL/aTz+yhYIhB9/oh/nqxy2S5PqRDKD56Md6RkwHZRHoB2inZvpx3jsLIzYecz+SMkc68EWf7PGE9mCfZIiNel6PETXpGmuvpQcRf3WQlW8eg4FeEgqgH3HwjV7IwSwVcS8sNXLnjtR56ccsF3K5fF7yJwFpB/oB2qmdfiTT9dVWvrlLvoren84JrR/+DGbaovrtXlYSOWVNxF9dRT+SaSDZn58hiH68rny5kDPyednKA8mHjvjn5MpBVnEgM0A/QDu0V95cWPJKVP2ALKJytAxL3jIK9AO0A/0AAXX6wbRPZoF+gHagHyCgRhrSNRsgK0A/QDvQDwBABPoB2omonwf3cYF+AKgnoB+gHegHACAC/QDtQD8AABHoB2gnqn4e4gL9AFBPQD9AO9APAEAE+gHaUauf0+98iCANnqRf02qAfoB2UqufD1/70/hJ/E6ENGCSfk2rAfoB2kmzfu5snowT6AdJJEm/ptUA/QDtNIh+Dh76duJ3JaRBkvRrWg3QD9BO+vWz5A30g6QwSb+m1QD9AO3o1s/9LNIj0tD6uV+GFv0svC1J0rczJFtJ+jWtBugHaKc2+imVSv6yESPq57HHHiuVSo899pgu/Sy8/dL0q9/81vGvH33260ef/aeJSRgIiZCkX9NqgH6Admqgn5KNV/UjNZOonxdeeKFUKr3wwgu0fnzG4sLpZ+Htl6ZfJeL5+tFnn/v+BAogJFqSfk2rAfoB2slK9dPV1VUqlfL5fKlU6urqovVj3HfUuO9ofP04dQ/tHqsGSvqOhmQoSb+m1QD9AO2kYe4nSPUzPDzsVFHDw8Ne+qElFEI/C2+fXnhbLH2e+/7E148+C/0goZL0a1oN0A/QTjT9/IcHH+KideXb/ffff+rUKTLr89hjj506dYroh+DohxuCi6wfYiDiHugHCZukX9NqgH6Admqvn8hzP+LKN336cfLNbx2HfpBQSfo1rQboB2gnqn4e5pLI537uO1qi9UO+Da2fhbdPL7x9fPS7Uv28NP0q9IOEStKvaTVAP0A7EfXzWw9z0Vf9+BjIuO/ofUdLRD/ki9D6Edzz99/4llP3wD1IhCT9mlYD9AO0o1s/omwChtOPdOTNcY9joHD6EdzDr7eGe5DwSfo1rQboB2inNvqJs/Carn7I6oNHHnmEHn+j3RNBP/isD6I2Sb+m1QD9AO3UQD9VP3Yqjagfxz2lUmmJ+szpfUdLonvC6sd1T9I3LyTrSfo1rQboB2gnK9UP5x7HNPRUUOiPnWJ7N0RDkn5NqwH6Adqp/dxPtKUH4twPVxtF3PMN7kFUJ+nXtBqgH6Cd2q98C5iqK9/89xtFwwUkqST9mlYD9AO0kwn9RAv0gySSpF/TaoB+gHagHwRRm6Rf02qAfoB20qyf+HGeDfpBapakX9NqgH6AdlKrHwTJaJJ+TasB+gHagX4QRG2Sfk2rAfoB2omqn89zeXrkx9eurSMIkvRrWg3QD9AO9IMgapP0a1oN0A/QTlL6SfrvXW/gkgK1QD9AO9BPfYBLCtQC/QDtQD/1AS4pUAv0A7QD/dQHuKRALdAP0E5E/ez9PBfoJ1miXtJyIWfki+LxYp4cLhdyRq5QjveHAxkE+gHaSZN+yoWcYSO7JQJv2EtKX0n/Swn9ADnQD9BOWvRTLuSYG2Ux73fTo2+aXjfQxkLQj335qvijmn5AowL9AO1E088n936eSzz9hFUI9MPjqR/TLOZ9/AP9ADnQD9BOKvTD3C1Finl7HClXKNPfGrmcO8hkPQN3smnfYYt56lD9UV0/cmVTF4cZqaMH3xwPidcW1C3QD9BOKvRDvz93py3IXY//mXBTpL/2PLnuJ5OqD75564eRjnvZuStdzMM6jQT0A7STOv24h/JFkyl1qPfdHvqpfnLd4r30gC0CTe5r7uI43wr68R3CA/UH9AO0kwr9SO5tlH4kdz1v/VQ5uW7xGXxzj0E/IDDQD9BOVP38EZeYK9/KhRw7tONMfbvjQaZpFvPiTZMbfPM/uW4Jph/rILXMkFlxSH0jH3xzrnMBJqp3oB+gnZToxzS5D6tQLqKOOxaxjjmDa84DJCdDP+5R69rm80z1kxdWHkiXHvDTcqCegX6AdlKkHxADXFKgFugHaAf6qQ9wSYFaoB+gHeinPsAlBWqBfoB2oJ/6AJcUqAX6AdpJSj8IUq9J+jWtBugHaAfVT32ASwrUAv0A7UA/9QEuKVAL9AO0A/3UB7ikQC3QD9BORP389h9xgX6SBZcUqAX6AdqBfuqDqJcU3U6BHOgHaCc1+hFbzoAQXPPc8RrNtkEUoB+gnaj6+WMusXe8pncW87lhos+pHEE/aLYNYgH9AO2kQj9Vup1yp0I/Ejz1g2bbIBLQD9BOKvTDNkrgjlMbYKPNtifV9YNm2yAM0A/QTjr049zZaAehzXYIqg++odk2CAP0A7STFv2YpunMmLu3O//O2Wiz7eK99ADNtkEUoB+gnWj6+Y+//cdc1C28tt+Bo812GHwG39xj0A8IDPQDtJMK/TCL3Zz7HNpshyCYftBsGwQF+gHaSYV+2NEiVxhosx2Y6vpBs20QBugHaCcl+gExwSUFaoF+gHagn/oAlxSoBfoB2tGkn6v/5t8hCFKDaLozQD9AO9APgmQ6mu4M0A/QDvSDIJmOpjsD9AO0A/0gSKaj6c4A/QDtRNTPp/87F+gHQRKJpjsD9AO0Uxv9YOWbbnBJGwfoB9QJ0E99gEvaOEA/oE6AftJF1K3VAl5SRc0nyA6v2PsgGZLRzxe/e6772UUkK/nid89p+j9DIanRj+5m2/JtfVKHq5/gDbNNk9WPz6WMrJ9yIUc9kNEP+yOgnWT00/3sovFkCclKup9d1PR/hkLSoR9ps211O7Yx+2qaplnM1+5uGfJvwegnaMNsU79+fB7YEO380gT0g1QP9BNUP947ZKrQT7Ibj6rQT7WG2SY/+MYOjjl1FN/5Vexeav/c/om79zhTiLnPz/6oUMjRz19mvwVqgH6Q6oF+IlU/7hH21kjf6Jj9r9mbqnBLlbtN8ouoW3CuUMizB6VnCr+d33Xb728hfWavP7d0TM75FaaffoROfDKnMH9gupG5xDE++ikywmmgZrM1BfpBqgf6CTH3I2m2zbfzYW7G0l7R0pbb/DFaYNIW3cW8QT+9c7Ou2sy7XMjTdYU4hOj56+i/gO/gm/xXmD76IV8y8ssVyqyh3Nkb+mxGJbKyie40S/9RmXYYsI9yoB+keqCfsCvfmGbbfs1MGQEwnerE9/mScSu7mY28RTcnCeq2zJ8pGVgTug5V6wjO/fHkSw+Evzz7K0xv/bDjX+53zMIG98kYlQhFZQD9uPaGfXSRRv38yt+8/qnDi3v+z5vGE8nfeRED+om48Np5V++vH/cduqRRKv+E3FFKP1XOp/RTdXaKXgEm7WYtfRI//Ug7lkp+hVlNP6wAXf0Iv0CBfiz/FGAfXaROP7/yN6//ydjS5cuXT759EQZKSaCfEEsPJA7xHXwT7sHOaULLbXFlsK0f+fky/QRp5k09jutm7dsRnFv15ztn5fErTJ+Vb5IyRzr3Q00UeeqHLZLEoo46kMthNbYu0qUf4p6rV6/evHmzUqnAQCkJ9BO8+pF+Kofppe239ED+RF7HmffqkvOl+gnSzNs9g+pmXbUjOLscoeBb/Xj8CtN/4bW7jK0oGYoLph96+ZzPyjrmDwD76CFF+qHdQ9jc3Hz+1L8YT5QsAzlfILUN9INdD2pGqi4pFlxrJS36Ed3zy1/+8uLK9YOT7xLrhJsQOvT+2a2trTfftY+8O0V/O/bRloN18N2pLYqL73dwR7Y++nP6qba2tra2zv74rcTFED1PhNB5XevnES7QT7Kk6ZLCPnpJi34+dXjx8uXLNykqlcor73zwwJElki+Ol0NMCPnoh3ZPCP1Izsywfp4oGU+Ubt68GdBAdayf//TpR7hAP8mSkkuqe+skYKZHP3v+98LLZz6oVCqk7vnFtY2Xy9dK7699vL71swvX1tbW+OG4qPrp+PH1ra2tqTHuIe9OWdaRHhF+OvZRhvVju4cQxEDQD/RTM1JySTHrUwPSoh/jCctAm5ubzpjbA0eWXi5f+y9Pv14ul/nhuKj6ocqX68OHWNkwZQ2lHP7Zsqwf1j0BDQT9+OgHQeo1ul+zqdGPbaDnT/2LM99D9CNqKZ5+SsaTbw1f9Bt8c/XjQrsqs/oR6p6ABqpn/bQ9wgXVT7LgkjYOadLPk9R8+BMl40lLP0RLL725/NLChcDrsIk87PUCZL7Hmvt53xHJn7/pnOMx+OY1zZNZ/fC+4Y5AP9X0gyCIpmi6M4TZ9YB6G/7AkaXS+2tRlh5YamGw5nu4pQe0fpiDrpDIU9my4ZckCNNIKY644iDYGgToB0EQ3dF0Z4i459snD515uXwtytKDJ0vMCBstCTIuxw+p+enHldmb72ZbP08yxaXnEegH+kGQmkfTnSHqlqNPlIwnSlGWHiBKA/0gCKI7mu4MsfQTZekBojTQD4IguqPpzhCv4YKwIi7x23GjpZH1E25xqtgRjcXanprafszzQ41ckzZnpzXJxnF+vyxzsJe0XMgZ+bzXXtoAVCd2v58nAk1RIJoC/YT9bIRrGFOQjGTnZpZcPk/voJkXReMhFj+bZQaJfopulzrThH5AONBuLtuBflTqx+MsDro9KXuWt2TqVj9MVwZWP9Ltw4N3GQf1D/ST7dS1fvZzqZl+pFUQ06yafC8ZZqPar1FFU6Hs57OsINcPLSBXP16dy4N3GQf1D/ST7UA/wfRTdViN68+TLxTy8jmNciGXy+VyhWIhl8/7Vz+0cuqh/PHSjysg5zp5di4P3mUc1D/QT7YD/YSsftgGazIpuDdFqiUa3QI6X6Dbk/rM/TAVj9P9NLt468cWUN5HP9JCx6fLOKh/oJ9sB/oJpx+uvaeoH+E9PfdmvFgolIUeoR4ja+xhxz/SFqNZwE8/sr6xsiUJwbuMg/oH+sl2oJ8Q+mFXaVlHmHsdV+cYhpHLiW3NrNumxwJr6dw7NUefWftU0Y/1Fwyy9CBQl3FQ/0A/2Q70E1Q/ontMXj/FvLWSWLgN2gdl5Usxb+QKRWqqSPoMzrkZntrwWs0BQDSgn2wH+gm78k0BRD/2m3tLMj7SqRegH6AW6CfbgX4S0E+jgksK1AL9ZDvQD/RTM3BJgVqgn2ynnvXTvp9LWP0gSL0m6de0GqCfbAf6qfuXaHrAJQVqgX6yHegH+qkZuKRALdBPtlPH+vn19v1coJ9kwSUFaoF+sh3oB/qpGbikQC3QT7ZT1/r5Ey5K9EN/0pTfgKDKxqRZ/bioKqAfoBboJ9uBfoLpJ8CO1/kiqyNxezjoR9xIAjvlgOhAP9kO9KO4+skVivJmP9APpx9uy7tGvzggAnL9nAdZ4N/+3QL0E0I/VTf2R/XjC3NJiX3sHj7wD4gA9JNhoJ/Q1Q+RiDAU5+7bJvupODDXmNCXlFwkt8c2BuBAeKCfDAP9BNcPU/l49ZxD9eMLfUmLeargYVwEQFCgnwwD/YSqflyB8B0T6Eba+bxskQLmfkyJflD9gFiE0M8PZt56/MgJMT+YeavGt11AgH4ifu6HG2ST9T+jvynmc5IWp42HOPiGuR8QhxD6efzICelTPH7khHiy/xpX5xzxUWpv0PUN9BNWP9Y4m6gS8gNRP4U85n4cmEvKz5Ch9gGhCaef27dv3blj5fbtW7dv/+uNrQ0v/YgHW5tbWptbRP20trQ07dzp9SjgBfQTdvBN2q7UNO0BOMz9+MJfUnfpdaNfGRCNcPq5caNy40blxo3NGzc2t7Y211Y//vDn78apfnbu2HFPS+uupqbW5pbz0E9IoJ8Q+inmqTfo3GdW7Bsodj3wxW88E4DwhNNPpbLGvSIvlBeDVD/ct/e0tO7cscMwjNaWFvKFl6KAD9BPxLkfEAlcUqCWcPpZX7+2unrl6tVfXPn40srlixeXz5XfKfnrR+qVll3Nu5qayNdNO5vER4EgQD/QTy3BJQVqCaefD35+7vzZ02ff+tnS4k/fWZhdLL1yeu6lqvoRv23aubO1pUWUDfQTijrXz+/0cIF+kgWXFKglnH4WSydnX35+Zuo7r06NvTo19srk6Gs/+m6E6if4OcAH6AdBGjNJv6bVoOVzP60tLTvuvps+IjUKqp+YQD+N8BJND7ikQC1adj1obW4hMzpeS4jIadBPTKAf6KeW4JICtWjRz66mppZdzeeFKR9SEkE/qoB+oJ9agksK1KJFP85iNmehAUlz067W5padO3bQP/WvkIAP0E9I/TCf/SEHGv2zPGGAfoBasOVohoF+guunmDfyRes/8m1FxV1jyoVcw3/UlAb6AWqBfjIM9BOi+ikXcvl83sjlcpRnhOpH3A6hiqIaCf6SUheL2atIPAiADOgnw9S3fv7z7/RwUTH4Rm6J8o5yJjU8R4uJ7s/dyIgFpXAB3TZA6AEEqgL9ZBjoJ9Tgm6SGkVU/uZznxm8N/naev6QFutuc4BymIR0AEqCfDAP9hKt+nC2vpUNsuUIZ1Y8vkvFMXsxu47liHsUPqAL0k2Ggn1D6KTq9e7ybKTjWkY0sNTo++pFM/qDwAdWAfjIM9BNGP8V8Lpcz8vk83eiUv31iJbYPXivf3JKHXFe7joS2gT8S/fy3p6eff+HEz15f+D7+m+L/Pv/CiS8V34d+AuqnXMhZC6/LhXyh6FH9lAu5XKEo7/qDOyl7SZ2pH9c0zHIDrD0A1ZDo58D0pX88dSX/vbX82C9U/bcioPb5G/C/X/32dOHYP9W1fr7AJdbSg0KhbM/sFAviB3+Ifpzihx6dw8d/LDj95MULSC83wNIDUA2Jfv7yme98ZeTF+46aqlKpVFZWVh599NG2tra2trZHH310ZWWlUqko/BUNmL+eXPvObBn6CbnwWtpt2/rW7cZtHcR6Nwb2kvrP/KBgBNWRVz9HSypvlJVKxXGPYyDoJ2aeHHsb1U9c/TCKIQvc3Df19s2Tepvf2PdTr7kfAKJRo+qHWOeDDy5+8MFF8jX0EzP1X/10fIELthxNFlxSoJYaVT8B9TNrmmPfo45Mm+Z1c/9R8+AF649Hfjp2nfkzH+SeZ9o0TXN2OnlDaE39Vz/QT8rAJQVq0Vv9OAsNAg6+eemHKMcxCv31fd8zL5rMj8zr5uz1+tcPqh/op8bgkgK1aKx+6HVuAZceRNGPbSC6BuJPqMeg+kGQhk3Sr2k16Kp+KpXK3Nzcww8/XKlUHn744bm5OWcIjghJ+qiI+hGONIJ+UP00yEs0PeCSArXoqn4qlUpnZ+e+ffsqlcq+ffs6Ozs5/aisfo6aBy+YF083ln5Q/UA/NQaXFKhFY/XT1tbm6IdYh57+UasfVD9pBvqpD3BJgVr0Vj+ObAJWP7w2VMz9jIxNIgiiPIncsEA9oXfuhxios7OTnvvxqX72nzZNSiSzplw5PivfpPpZ39xWm5VVE0EaOSH0Y322t7E/sgtk6F35Njc319bWRtwTpPq5j/qIj2m60znBP/fD/Wh2GvpBEPUZGZvkmiZ57k0E/QAPNH7uR9SPv3g0BfpBEOWBfkB89FY/b7zxRltb2xtvvJHgFjvQD4Ioj60fTjqyfUg5/Ui20HMPYXvXhkJv9ZNUxQP9IIjWjIxN/qlhGEbu/767Td0/ZE1iaf2wff6knc9RJTUOtdjzLdlAPwiiPCNjk/t9teG2+6H1IzYBoruilgs5FECNhLz6+Z+FI8OzWwPfmq6D/0I/CKI8I2OTn5Poh+tiLuiHrnXYlhcofxoQiX5+/Zl3fvSjH62trdXHf5PRz8TA7u5j8/zxmd49e3snrBM6hpZXVs2V1eXB7r3219QJCJLijIxN/lfDMIxP/vUry5ubm3fu3DHZ6kVe/RAcB+WL5IeoeBoTiX6MJ0tib+zsUmP9zA/17N6zl8rA+MSA+7VzpqWf5cHuvez5e3dTBpof6tndPyOc5j7PeL+jLgSpXUbGJh80DMP4949Pvn39+vXbt2+bklJGPvjGFjqy6SLQGEA/yquf5cFuSw/zQz0dQ8srEwO7+2foc8b7bZF0D/R2DwwODQwumOP9PYML5nj/wOBQj6WfhWMdVgm1PNhNVUUTA5Silge7ewYXkr8fIQ2VkbHJnGEYxicee3Hx6tWrt27dMk3TdUmuUPCe+6HdZJpo0N241Eg/09PTZOe3tra2kZER5c/vQwKDb0QbC8c6iHUE/ZCDdvUzML66PNh/bLC/Z3BooHfCnLf1M95PO4YdlFs41uHUQNLnR5CQ6f2zvwh+8sjY5KFDh5577rnFRVo/AISgFvqZnp529to5ePCg94lTfUbH8JL0wNJwh2GwP10a7mDPrkz1iacYtdWPZDCtt3+AOUIKmuqDb3RZI+iHPuIWSQgSPYZhdHV/9uJHN4KcDP2A+NRCP07dQ7tHVgNV0U9HRwf9c0E/U31GR0eH0TdVoU6psX6czPQ6SrCrEzK8tmIfrDZnM9PrzvH46oc5E0Eihgx+/d7vf+6lV0pVT4Z+QHxqoR+x9Dl48CC9+VtA/fRNLQ1TAuL1M9VnneH6JwH9yJceeOtHON8uj5iaRqofujbC9A8SN870ywMPfrrqydAPiE9N9UMMRNwTST9WFeQcYmsh/oRkqh9rVmamt3ugt3tg3FmA4K0ftgxyyibf6odZ2I3qB1GQsNXPV7/6d//wD8f/+Z9/+t57P19ZuZZ4/+mGSiK2UE6t9eNAOtGF1g81wcPox/057Z9E5n6IY4hFZnq7jw3a1uH0Q2qjQa/qZ3Wmd4/H3M/EwO491FPRyxAQJGoMw/iN33zw7HsfBzkZ1Q+Ij3b9fOELX5DqZ3p6Opp+HAHR+uGdQz0q4bkfagxt3PXQXscf3tUPv/JN8JMdrHxDVCT4uoMV6AeoQK9+aPc4zU/37dsncw/nGB/9WALq63P0M9XHb9xBTk5EP7YqrPket2phqh87nnM/qwGXtGHiB0kg0A+Ij0b90O7xXW/N+se1zFSf+w1vJiIcSz/Cgmv7kQlWP2pi73rgeQJ2PUASCfQD4qNRP2HdQ3uFIFlZUKEPWCfQmqJ+Ssbnsq0fBElnFOmH3u86Kmhnl1m06yeUe3QA/SCI8tib7gg7vIUD+mlosOcb9IMgoSPTT0J7tkE/mQX6gX4QJHTELUfd3UatGkjaQptrtU1VP07rBeuUXKFMb2HKNO6WHYN+sgf0A/0gSOjIdrz26awgOyjXT47yC/W1JZtqzbxBpoB+oB8ECR1pwwUih1yhLG+hLZnoEfTDNk310YtfOzuQEaAf6AdBQse/+pG20CYHWUvIBt+44zJHMSUR9JNZoB/oB0FCR9DPWVsM+SKnEhuZJsLpJ2gzb5ARoB/oB0FCx2vlmy0BaQvtIHM/VfWD6qd+QLdT6AdBQkeiH3mxw1qJPhheP9WbeYNMkapup1pIbM83aaT7uaFdKZK1YNMdEJ9UdTut0HvuuO0VDMPeXoe03DbYU6qQcPXj1dWU2Qnbc982e883TmkD49jtDUk00A+IT9q6nVJ7jPaJe12LvUyrK6jG+hnv9y59rAJooNd1Sc/gxLEO4Rxrk2xXUWK3Uy5WQ5QAABTgSURBVBN7XSMJBvoB8UlTt1O+e7Zz1HPfa/GASALVD13xeH+9m/Sj28MrZH6oh5iG6/cj6AedfhCV6f2zvwh+MvQD4mO8dmrx2qrbujXpbqeiTHz1E8A/iejHq/Rx9DPez3SNoxsr2NahixsP/WDSCFEXwzCCd5xDs200246PMTE9e3R0wjFQot1OnakeWij++hE7pPKksvqZ6d3jtqRbWZ3ppbpl213p6IPs3I9b8TAPRJA4IROqv/f7n3vplVLVk1H9gPgYpmleW113DJRot1MLa4GB5Zk6rH7mh3o6+gc6uo/NTwz0TlijbfNDA3Yr7p7BBa6y8ah+MP2DqIuzpOeBBz9d9WToB8THmvtxDJRst1MKp6rJ4NwPHdnKt/GhY/OOXRaOdVjVzPJgN1nSJq9+ZPpB9YMoC6ofUGPcpQfEQJ/9+1OJdTud6qNUEkA/qVz5VuVzP44tbP3MD/VwHwwadPUTYO4H+kEUxTCM3/jNB8++93GQk6EfEB9m5duHl688eXg0wW6n9Od6GudzP2ysGmhFWPlGWcrWEla+IeoSfN3BCvQDVODqZ+uXN4+OTvzB0Z9iz7cY+vEvfaiND3j92IsR6JUFVRa2YeIHSSzWpjuf6Hlxkd5y1O2rwG6r47U5D7UJDzbNaTws/RD3fHj5CrYcVVz9xAu9IJsLdj1AEkwM/VCy4beAA42FYVLuMbHjdcr0gyDpjI9+2A1D3RZ0BKEnty0h6KfxMF47tei4x4R+oB8ECZDI+pHsUA39NCrGxPSs4x4T+oF+ECRAYuhHOAT9NCpoNwf9IEjooPoB8YF+oB8ECR2n3dxnhxevXr166+zTOV45Uv2U6Z7cJn0M+mk80O0U+kGQ0BkZm/yrz9wrXVIdZOWbR09uSKixQLdTBfp5+bVTCNIIofVz6NChL/+ur1Kk+pFMA0E/DUqqup0Ku1e7B8h+B8xPxfZAU33iKQaqHwRRHux6AOKTtm6nfvrp6Oigfy7oZ6rP6OhgtiCFfhBES6AfEJ80dTutpp++qaVhSkC8fqb6rDPYTUmhHwRRHugHxKfW+qnW7dRfP1YV5BxiayH+BOgHQTQF+gHx0a6fMN1OA+iHmuBh9OP+nPYP9IMgWoJm22i2HR+9+gnZ7TSQfhwB0frhnUM9CvpBEOVB9QPio1E/4budCr1L5fqxBNTX5+jH7gpE0TcF/SCIrkA/ID4a9RPhsz5s/9KpPsOzzTYRjqUfYcG1/chE9OPb8kfWv2e8n+ogJwnd9hRBUhHoB8RHu37Cfs6ULmQkKwsq9AHrBFpT1E/J+FzS1Y9Xt1MrM717SNuemd49snbadBs6KvRz2j2BWO3ZnkNbIERHoB8QH+z5plg/4/3Bup1atrD6alOPdY/MD/XsFp3EtUB1v10e7HZPHu93uqaiKSqiPpx+Jr4o21oHGxkAX6AfDdUPXfHIvrZH24Rhuu5j86Tc6Z+ZH+ohohrvp+QxMcAN3433O8ph9LMyMeC2SaW/RhAVIfr5Ws8njM8Os9VPuZBj9tUhFPOG5ChobKAfLfrxKn0ijYNZ43JUQeOErmxo/SwPdlO/iyuYECR2RsYmD/3VZz7hNlyg9SOtd+RaAo0M9JNA9bPCjNH1DC5Y42xeyxPko3Cr5srqTK87WEfXUtxoG30agijIyNjk/8gZv/tlce7HSz+mWcxjIA7QQD/JVD/OoBkZW5sf6rHswlYqXjNJ1vMwJ7vVj1AnYfoHUZyRscnP3Htvz9eeW1xcLP3tp7xnfqhNrlH/ABboR4N+6HisfKuqHyKeju4eycPd5+SrH7tC4tbRofpBFGdkbDJn5L4srnwr5r0Vg/IHMEA/yvXj+7kfWwPi4FvvhL3Gmipc5oeq6kc692M6KxdWVs2VhWMd0A+iNCNjk/fe+5mv8fqxChwPz6D8AQzQT8qqHzbMnJDvIB6/8o1YkJgMK98Q1ZFXP7Z2PPSD6gcwoNm2Wv34lz6eGx/46Me3+gmyqg0TP4j6jIxN5gxr7sfSTzHvfMaH8YyzFqFcyEE/gCJVzbYjdzv1e2Dd7/lm73og/yl2PUB0hFv5dvbp++nPlzL6cWaDUPwAliw12/budtrQ+kGQ2of+3M8/PmIYX5xg7iPFvLDvASZ+AE+Wmm17dzuFfhCkpvHe9UAOdj0AItlqtu3V7RT6QZCaBluOgvhkrdm2vNsp9IMgNQ30A+KTvWbbsm6n0A+C1DRoto1m2/FJVbPtyN1O/R4I/SCI8qD6AfFJVbPtqN1OfR8I/SCI8kA/ID7parbteCVUt1P/B0I/CKI80A+IT+qabSsH+kEQ5YF+QHyw59v22sb2+sb2+sb2mnNk0z6yAf0giCTQD4gP9LO9vrHd19f34osvOrJZ29h+8cUX+/r61qEfBJFlZGzSu7EPAIGAfrbXN7bb29sfeughUgCR0uehhx5qb2+PoR+h/QG3LRt2oUb4ZKktE/QD4gP9uLIhBRApfRwhhdWPV39SN2wTBFlLBXeDauItyXP2z2Av0SzE7uG0Z2+AdxsB9DMxwHZSn+kN9MzqYw++ffmzhmEYj0w4g2/lQs4wjHyxmDcMI1+0v2V+Zp3qbgwHbTUm0M/22sb21Euzrm9sG02/uhRt7oe08LG/3ivtpMBVP1RjBao/At9Mgbs9oZNCujMxsJvuOWu1yeDaMtEJVP2M97s9O5imgrVNFf3kcjnDXz/spqQG9sJuRKCf7fXN7Surd/r6+kgBREqfvr6+K6t3oq1844qV3gnbLmwjba7bqagfQV3C7QkjeOkN1+/cSSj9LA92i0Kyn3nhWMeexN5/VNGPU8946YfYx+0DhAKoEYF+SAF05yfzl0gBREqfn8xfWtuIrB+++uH0s7IqqX6opqXk4WJxI9yeqveaQxLKxICsLqHG4rqPzVsqmum1vg2oH2sIrqM7ydHXqoNvsm/dbyxJofxpbNDtlC+AqpY+Eaof60fe+mF7ZpM7jngzCnIESUfk+jHZ6of0xnX+BQPrhx2CSyTh9OP2m2P0g4qnwUlVt1MtBKp+NreXP7jZ3t5+rrx5rrzps+YtZPVj31AWjnVw88+8fpyH2HccSWUjvT1h+ieVCawfaiCO+vedGOAWmzCFzsTA7u6B3kxUP8Icj8fcD2qfRiRL3U4pmP13nHOpR7vnV9GP/ZlTiX6cRFl4ba6smuP93qWJpR/iD9orzteofjKdmV75xEww/bgnS+d+egYX0j33Q9vEFg23DoEdgIN+GpFsdTu1j7M7jDqndnQIXloa9tPPxvZP5i91dXW1e9DV1fWT+UuigXxfmWRExSv821syM0RVQrR+Asz9QD9pzfxQD7NIWrLyLYJ+lge73Ro6BSvfsOsBiE7Wup1SXmEOTPVZvbg5/1TTT1dX16uzyysrN1+dXW5vb1/+4CYpg5yDXV1dIfXjczdxjzjKmR/q2U2fRo25YeVb5kOPodHOYJYeOOdX1894/97d/OL7ZD/3A/2A6GSv26krlg6hHQPVijugftrb21dWbpK0t7cvvLO+8M46dzCkfpzVTZRppCP41u3JqXWEc6osbMPED5JYoB8Qnyx2O/X5oeCfMNWPVehID0aa+4kfyW49drDrAZJgoB8Qn1R1O41Y/dDO4f0TeO7HneaRHkxIPwiSzqDZNpptxydV3U4DN9tmDtB95oSFcf76oVa+Me0VNraVrHxDkHoNqh8Qn3R1Ow3abJs+j11wzT2sun4iJfEXP4IkG+gHxCd13U59mm1LyxtGNu657mAc9IMgygP9gPhgzzfoB0FCB/oB8YF+oB8ECR3oB8QH+oF+ECR0oB8QH+gH+kGQ0IF+QHzk+rl0baNuAv0giPJAPyA+cv381pF36iZB9bPhG+gHQahAPyA+cv2cryOC68dr32voB0G4QD8gPtAPox9np9EYW46aK757tTGxNuGnD2Ij0YZNlro3QT8gPtCPBv04vU2lsfssdAwts/qZ6bU24Xf1QzQ23s9sqk+6vHwNW45mIO5G5gHejgTXT6in1RLoB8SnsfXjO98TveFCd4+8UYIrG+r24XZnEPTjNFxg+lo6behQJ6U7EwOknaDzrdBujksw/cifttZ/O+gHxCeEfn4w89bjR06I+cHMWzU2Siiq9vvxmu+Jpp/xftI8W176kDvF/FCPdfvwrX6odnPLg912rTMx4Da4RLu59Gamd49UM6H0I3Y79XraWgf6AfEJoZ/Hj5yQPsXjR06IJwubUFvQ59zT0rpzxw7n26adTa3NLQGfh3427mm5I8HbzXEDbjHmfohIhOPU+1+ZmY6x+mGLG8s67M2rSj86JLnQ7xLcUO9L3H/NmV7r2wD6kT9tAoF+QHzC6ef27Vt37li5ffvW7dv/emNrw0s//gdFi7Q2tzTtbAryPK3NLa3NLaJ+WltamnbuTIV+fKsf+m7iXf1wN6Plwe69vUOcb7I0Wd1Y8fQE/QaCvBFx/gWhH9BYhNPPjRuVGzcqN25s3rixubW1ubb68Yc/fzda9UPLw7+yCVL97Nyx456W1l1NVv2UtH5MaoZGGrEAEuZ+xMqGG/S3ngfTP6lMYP1Q/6CUfiYG5G9coB9QR4TTT6WyxgngQnkxbPVDBtwMw2hu2tXctEt6ptfzGLLhO8MwWltayBciqax+7He17nCcuPRAfC8c5AiSkni9/wimH/dk8V88FW84oB8Qn3D6WV+/trp65erVX1z5+NLK5YsXl8+V3yl56eeellbxeMuuZm58jHwhrZDO+xZJ5Nl2NTWRr+mBOyXVT8SPnbo1ykwvtS6AXTwt1Y/zI0c/3I1GuD0tHOuAftKa+aGe3XuY2Tth5VsE/Xg9ba3/dmi2jWbb8Qmnnw9+fu782dNn3/rZ0uJP31mYXSy9cnruJal+iBVE7rrrLjJtw4nE8FhHIFqK/rZp587WlhZDqJ+U6CfapjvjQ9TYCDWEIgya2frpH+iwZp6dH4kr3zxuT1j5lvLQY2j2v9T8UA+79MA5P5B+vJ62xkH1A+ITTj+LpZOzLz8/M/WdV6fGXp0ae2Vy9LUffVeqHymGx9xPQP2I0gpyTnT9eH9G1e+VSX/mlKt+xPsF89bVnhByVFRlYRsmfpDEAv2A+Gj53I+07hHLHbLSWqqfHXffff78+daWFvKFVGA+B9VUP9H0ozQ+m/eMY9cDJLlAPyA+Gnc9aG7a1bKrWWqFe1pad9x9d2tzS9POnYZhkC/oc8h/naXYPhqLr5+A24wmoh8ESWegHxAfjfppbWnZ1dTkeIW2QvOuXbuampyDZAmcqJ9dTU1EYNLaSIl+gjdZgH4QxAn0A+JToz3f7rrrLsMwnD0OmnY2kQKIHCTfkh+R9dOk6HEWszkLDUiam3a1Nrc4z+YYSwrazSGI8kA/ID6NveUo9IMgkQL9gPhAP9APgoQO9APiA/1APwgSOtAPiA/0A/0gSOhAPyA+0A/0gyChA/2A+EA/0A+ChA70A+ID/Ti5s7Zxa33z1vrmrfWNW+ubd6AfBPEK9APiI9fP9evXV+uFwPq59d6FS6deP3Pq9TPvXbi0vnkL+kEQr0A/ID5y/VTqiGD6ubW+eevU62euXKtcuVY59fqZa6s3fAxU9cU5Ozp84jx1ZH788NRl99vzJw8fcDk+T46fOf7MyaWkbytIcjlz/MD4bPJ/jECBfkB89OqnrRqqfpEP1fRjDbjNzp2m9TM7d9r5USj9EPHY/7XVIupn9Az5emlq2Ec/S1PDB0bPrKxePvEMr6vZ0QPMcyJpzJnjzj+b/S/ue3IV/cyO8s+zNDV8IIl3LdAPiI92/Vy/fs0rKdHP7Nxpn4TVD7HIidHh46PDrh7mx117PHNyiehnfvzw1GVGP/Q5q+bK+ZOHrTvL5RPP2OXU+ZOHD5CvqYNICjM/TpW2zluQyyeeoQ4yCVD9zI8fYM7xeTa9gX5AfGqkn+efe+75555LrX5W129KE0k/5kqQwTepfti3sW7xxJrGrXvmxwO8p0YSyZnjB6RiCKWfyyee4Y6wT3v+5OGExuugHxCfWujn3Lmz9ICbr36m+uytQvumKpXK0nCHsIdo31SlMtVndAwvsY+zDnAP6autfphRsgMHbGdE0Q+tHA/9uOURkrLMj8vGxLgCl6jozHHr2yD6Ycbf7LHZBP6C0A+IT6qqn6k+yzqVSmVpuI/yy9Jwh/MT1jZS/binLg176+eWNAqqH3d8jB12O3DAGjnh9UPdlVxp0Tcj6eCbma3J6saKXD8mW/2QNyvOv2Ag/VAVT2IjbyvQD1CBXv1MT0+vrl6nlXPs2992PMTrZ2m4g3UK86No+vEbfJPM+ijRz+wotUaAqXvs+8v5k4dHz5C6x9aPe5exBu6YyoYuquhhPUz/pDWB9UP5g/rfgH/XQi8zsR+V3MjbCvQDVKBFP3Nzc6Ojo5VKZXR0dG5ujhiIHn87d+5steqnRvoRZRNXP/PjB545ecJZ+TYq08+quWJZSix0nHkjj+qHCaqf1ObM8QPSf7Jg+nFPlvz7kjG3BEfeVqAfoAIt+uns7BwZGalUKiMjI52dnRsbG071Q4/CSeZ+rKkfwUHZ0c/s6PgsvfRAWv2Qr8kSuAPjs576kc/9uEn0/S/in6WpYaZUlax8i6gfMgB7ONHCF/oB8VGvnwsXLrS1tTn6aWtro/UTZOWbtXiAdkh29ENC60cy90Pfd+bHD4yOy+Z+PFe+ucHKt5SH/ten1wswSw+c8wPrhwzGJrrqBPoB8dFV/TjjbJ2dndPT0+E/dsoKhncK/32a9SNWP8InRqXVT9WFbZj4QRIL9APio2vuhxios7Nzbm4u6MOm+ihv+OuHVEjOEXbJXOCVb/r0oyo+4/vY9QBJMNAPiI+ulW9k2I0MwQWH/syOYBt+Qsj9iJDBmyrY537kK99i73qAIPUf6AfEJ1360UHYz/3IAv0gCBPoB8RHl35GR0fb2trI8utkQbs5BFEe6AfEBw0XoB8ECR3oB8QH+oF+ECR0oB8QH7l+Ll3bqJtAPwiiPNAPiI9cP/UU6AdBlAf6AfGBfqAfBAkd6AfEB/qBfhAkdKAfEB/oB/pBkNCBfkB8oJ/ttY3ttY07a+Jx8qP17bV16AdBmEA/ID68fgAAAIAaAP0AAABIAOgHAABAAkA/AAAAEuD/AzlhIZ/3qNr2AAAAAElFTkSuQmCC" alt="" />

二、级联删除

使用Data Annotations:

如果我们要到一对主从表增加级联删除,则要在主表中的引用属性上增加Required关键字,如:

EF 主键自增、级联删除
 public class Destination
{
public int DestinationId { get; set; }
public string Name { get; set; }
public string Country { get; set; }
public string Description { get; set; }
public byte[] Photo { get; set; }
public List<Lodging> Lodgings { get; set; }
} public class Lodging
{
public int LodgingId { get; set; }
public string Name { get; set; }
public string Owner { get; set; }
public bool IsResort { get; set; }
public decimal MilesFromNearestAirport { get; set; }
[Required]
public Destination Destination { get; set; }
}
EF 主键自增、级联删除

可以看到,在生成的数据库中,外键应用了级联删除规则

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAA4QAAAB2CAIAAAAfnsrjAAAbVElEQVR4nO2dO2scy7bH+4M49GdQMB9BkT+CogGnChQrEwYHSgwGJc7FiS4I7jWCndxX4n22z8EYhL0fzg4YZGRjDIY+QU93r6pa9eqp1+r5/6hgpqemetWq17+rqru7/3r7r//87V///evvCAgICAgICAgICIVDx4rRe5Vnz198+/btPeH8/PyXX37p+74jDF97lfPz867r3nPQ40MK7PHYI+7I79+///bt27PnL8xMdZF4M+W1ltpsy0VUft+/f//s+Yu+Acya4ODZ8xesMyeGWmTz+f4FEetqm/NtVUuzpFcbTmC+0jaQ8BrlzlTX9VMIOW7LVGBOTYNTlemQzXsAAAABJNYM4WL0HWESo14GGfHOwjQYD5/Z4+ZPIXFsKb97944OrjZ7QvBmKiRHmpFsBLcHtLNXF6ODVVF/efb8hc2ZmgO90dwFEVKRzCPhzndULZrC4CXtc0h2QnJhy5et7pkZj8oUFZ0hx22ZCs/pO6NROEowPLMQowAAEE5i5RAoRr9+/fpPwnkMXdf9syW+fv06DK5aptZBdTG6gGfPX9R2WxpCqtakiobPfd+31kA03JnquvMphBwvTLhvh2xW6dMBAEAcaWVAhBh9S+giedsSdHCtbUt6hIrR2m5LQ2zVmsRobsP2wZEpqjiH4D5ehmU9D8QoAACEk1YGhIrRh4eH39bCw8PDMLiuKVMTQsVobbelIbZqTZopt2H7sO72MjFks0qfDgAA4kgrAyLE6K9rgQ6utW1Jj1AxWtttaVhl1VplpkwgRgEAIJy0MsAjRodBCEFWSFtFClDdYwgICAgICAjhIa0M8IvRtOcDAAAAAABgAmIUAAAAAABUA2IUAAAAAABUI0KMXv/tPxAQEBAQEBAQEA481BSjac8NAAAAAAAOnFxi9Pz8PIO1JWjf8vYtNBFnsziDRQCvtsaaSmRNeaEIzZdQs0EtlojRkAdQDRUx9HFVLdG+5e1baCLOZnEGiwBebY01lcia8kIRmi+hZoNwIEbz0r7l7VtoIs5mcQaLAF5tjTWVyJryQhGaL6Fmg3AkitHrk67rTq7VKNcn3dHFm0ReSQdjuU5ls5lG/ubiaLJO97NJBc8HeNVvt4EtI7EZZOL7DQ44w65YCjk7d7Em8Da82sy5dnCKgZZLeKs0SjMoKymz7KldYedJXbvyt5o6+dII6ULL1O1GdcUqEStG9Y6t0UpjuZ5ryFrdwusT2sdcn3hHkOpjXioDSopRPUKYn5dI7Ep4nZZjWF29V6Oo3jB3mmUyQv3mRjc+7L+Lax2Du3YF25O2dmVvNZXyZaafW4wGptDQSL16hIrRo4sLrTk0WmmkidE3F0exKr/6mLcGMco4fl8z6tKEGF2dV6Oo3jAZzRKsYhjj/YVZUIwmsieWEq2mRr786UOMrh6xYvSN1q+RSkNXmecok4Qdlxeuyecd5J+JrvsCxag6Hfnm4mgw4PqkOzo5YW1KZqpioacfIidVJk+HLzRT6kGX240Is0es+QvumCyJB9QQclqavs3t9PjJ3mLUPMvsjqOLNxYzptoyHLLGYRxC0le8wZagaeTR0ZGSo+kn3dhE3j5Mr9rSvG+4YXLbqXbHbB7Q7CR4SvPeV3nUatlc7VJr2npaTUgLuk/QhVqdZlZarSbcm/GsssF1othGnV5viEawGFU7O/ag1vepzWH+PDcypZqkqB/BM6OamJ7zwhxOaqpioXPiQnO34TbbmOd2uxZh6iuYM/E2055mYmcIl7i7hjDenvNlc7uSonphYTHYtaBsOYvXDOXEjjiGQ6aLH63usSVIEhoN5pb2wtrjIm8fsFfZNFttmLTDUnLg8sAIqzZCCmvPCJa8ZLSHdurK51qtJme+MnahVqfxpzFTsDXYyBEkuFHn0BuiES1G3XXr/v5eq0Bsi2C77GS1I3yZfjpkkce5TA0Wo7aTese8cLcrIyVXnJzNtqK3nlGFryGshV4PWE/kVc/kD1F+Dqnh3jjuASnkL2YK+bwNr9rSDMlawYbpF6OOthnuvWWluaB2ZbXHdgpHfDb9xvOVsAt1VEMzcTP2gsa1TGOUGMTXgXAxOlc0/TKDENY8tD9pY9lSIvaM7o5p13FcPU5qaugyvf6Tux/cc8y7p9rCzNveYtRbQzgLbW63eibUYKWztBaut/RJsiFxlATNQncWkD/L2bx9yF5l02y6YRrmzsfixagyQbtfae5duxLbw5yiTqvJm69sXajTafdcpQ1rXMtHEF+jzqM3RJNFjP7Pr7/TMJ0shxgdB50L0ixJ4S+eGU1EzA1M1yfd0cU1rbthF1UpLTRaJD+TkXsChjXAZnOsGA2pIayFthPZ/hhuMDXJe5YQM6Li2GtjULHacpTJ2zMH7FX7wYYaJqNGyZFoMWpfMjL/tTiCLS+57TE/12o1ufOVqQu9tztNy5vNcm/jiurTvI06i94QTR4x+vffaZhOlkeMThcZTBmTbSD+5qFUMbMfXUTU3fTXJ+rl3E5nvzG/JDQ1/NFOls9MEyU7YxaNefTYwpWmwDNqNYT1tr+G6J6J70npyG45i9cMJdmAONNn7+5GT2PhspzR2wfs1cV7Rqs0THWLnP4tToyq/01QmnvWruT2OBxSstVkzlfGLtTqNL7Smim4Gyz9HKcxbFnLoTdEswoxqjWh62lKfriLL7zZ06nzNDUj7tFO1yfqia9PuqMj5j7ZlKbGPPSe/KB0L7rn1Ynq+DHPl72Ah96b/RBjp1FDCGwGrXbNx0neHQYbpU+6NMtZvGZoyXrj8AkaU4n+v3BZ3v16cp3D2wfrVTbN+1Yb5vRf9h9eMarCdvnRpUmqZXTtymGP3QnlWk3ZfCXrQjmreaexp6Q1gbGBW1EJGUGiGnV6vSEaiWJUEnGWv7k4UtqgRbMmRaJvxdkszuA4Ku2+h1dbY00lsqa8UITmS6jZOgIbdTEgRvMSZbmhPSFGecTZLM5gH8qGQWXtsCDwamusqUTWlBeK0HwJNXsFjboYEKN5Cbac3ScDMcojzmZxBgdgW34tB7zaGmsqkTXlhSI0X0LNvr+/l96oi5FJjP5Bw3QyiNEGad9CE3E2izNYBPBqa6ypRNaUF4rQfAk1G4RTWYyeAwAAAACAA6ayGA0kuaHFePr0aW0TPLRvoYk4m8UZLAK53cJaWVOJrCkvFKF9kVCzQS3yLtNLpP0m1L6FJuJsHgz+BJIydAu1rQAzayoRuYOOG3Gd54BQs0EtIEZ12m9C7VtoksrmVwEkORHEaA7WJH3WwZpKJN+gU6zbYUnY4ZfMiMRxClSkjBi92WrP6e22N/NPm8u7MeLd5abr6AEVNbJ+kH5Q4RK8u9zMVhDUJuSw3GtYLgwLs/sktc3LefXq1VMnnz59SnIiiNEcrEn6iObzo8f5Qq1MZRWjZbodlrRitFhGdLOHwV0bRMm4pI08lsHIGO/GeCR5PkKsAXZL5oSMUZScY/rdFBGmgeYP87/yDMntsa8Y7bouTIwq7r+73IwH6E83W4cQ5dJRD5ofyOnIEXcpu6UesbwaS8Xocp+ktnk5Q2fqiJCqM4UYzQHEaHWyytC6gjW3GHVE+CRKjDoiJMyIOa2zG1vmQZQc1D5aBqObrSHlbrbd9ob+XR/rhggxBqin0y1x/ufucuPTB6Z5puVEZ7QgOcqQQIyyetQtRtXaMLvfp4QWCq+eu8wKnhm1WV6NJGK0j/FJapuX4+hMu67rIUbbBmK0LtU1aFZVCjHqpZYYVYdNOplpWSO1DE+by0st2k5qavHUqc/tzRID+PQ8AuDucrNExLjsKrvuWpE0YtTUowFidHD27ifvpCifjnLQJbz4qfaFYnS2fLsdFLR66svtPOd+Qz7PKczQa6Ihte3WiK3amUqMhvtkf3KL0cGZPcRo20CM1qK66CygTSFGvdSbGaWMk4HKoKQPPsz33YBKBzJmJtLQnez46DeAt4QdbxVV4BxBlT0DnIreXN7pP+YbltsimRjV9KhbjBLpOYmwEPG/h/AKuPAacEs91fLpN3Vr5pDsIDrnz1Nl1TaszMeN1PjrsGRiNNgn+5NcjA7Sc2CqgT3EaNtAjJbHLftylEgtYQox6qUFMTrNr2jDjSkzVUHGDWSa1NxN9NgjxBjAWjIMyON0E7uPYLPZ2H51z74Sy+m4r+2oWy8pxSjVo54bmPTNituboOXvKmLUYTnd7Wqe2vaZYMwQa7FZIyFGezIVSpVoDzHaNhCjJQnRebVKJIcqhRj1Ul+MklmXcDFKJKUai52IpFrCjBBsgM2Sjtl7yp3a/SuLZvlOcmy31bcGFiGxGJ30qGeZnvspYKXevdZcZJme/ylKjGo33DFidPzG2+i3MLVP9ieTGNWUaA8x2jYQo8UIFHYVSyT5RCnEqJe6YlSf4wtdptdGzHlSyLYoToc9Pc1gAzhLLAO1BcetSoF/cRu2MorNjAZKusANF2oCAcIr2Q1MVssDxaiaR8vM6O7rDW+iamEJn+xPjj2jphLtIUbbBmK0AFFirrUS2UeYQox6qShGmdXmyBuYjGi2W9fp3kvt9osIA/hYMfcWxQhXzXLPsVVSZ8+o9SefHDVu57Ft3DSqdYAUG8gvRrXmwYrRcZLeb2EJn+xPphuYNCXaQ4y2TWvSRy7J7xxavFMzEwushRj1Uk2M8uueZLw3hn6/GCVSUxkEp3NRLRpvgMUS11OXeDP0vxmJm38JsmttVLqb3vqTsiWDRZuy5648HBs91XSqLNMT6zbbrWVmdBeNdYRl+SOjT/YHzxkFnyBGU5BPhjYoST+F5XeICTHqpZYYNYYfujlvhzby+MWougZPBkEmwgID7JbM/yH7CMwtBc4let9f5oMHMSva96WeMyqJhC1/L2xLEO1YGENCMeodvZKcCGI0BxCje1JGiTYlRgdCDM4qRr0WZjp1n1qMFstI7nHKtmE0PAJoijJvYIrFvIxxXLckphGp55iSbcTCKMTZDDGaA4jRfSimRBsUoxSbzXJnQNyI6zwHMpvt3YIZskcTNESZd9NLooGWf2O+84zSgIXRiLMZYjQHEKP7YOrF/XWk6BIx816518iDuM5zQKjZoBYQozrtN6H2LTQRZzPEaA5ES5/qeJXogjSllwjEaLMINRvUIlqMngfzFADJhFd1AAqgLUmbi9SHieaH2t0GAIdCZTEayDlmRrPRvoUm4mwWZ7AI4NV90KYAk8wIrqNE1j05KrSMhJoNarETo//79z9owDJ9y7RvoYk4m8UZLAJ4dR8c9xstTnMdJbLuxXqhZSTUbFALiFGd9ptQ+xaapLL5VQBJTiTRye0Dr+4DxKiDrGK0WLfDkrCMSmZkNVULlGEUo7/9QUNqMco8qml70+sPXxge8+p8GgNNiDzqKeWj3dUmZLN8H/Z95ITZyJO4JSsJxah7F8unpM8ZpdidbGJ9BWtwoTiebsa+DsGebJXytlDEq63U+bTkUKI92zDpKzQqPKdxYfeYW4yW6XZY0orRYhnRzSb1SnmfpqWuBbwOVIlnedo8SYg1gD2ooltiPPNeN9B1FrNu215Zc3CPvS8mRll/6i+mdzpde+3lkpdeumvRgCFGm6sJqoUJ3FKAtGLUESGPGHU4uScHtWOBsomeg319l5mCWYUDz16Zgl6tX+fTkkls6a1JLYQaryJMIEaT61G8gWkB5rQOeePQfMVovvXSMUwzTz0cHm1Pa6pWg3bPvvcZwL2vk7HE9TZQW47cL/fkX29zgC8EbUSMGu9XZ+BemDm/0ss6a2JeYEXOjDY3gHksXOqWrBQQo13X9bnEqMPJjkNxYrRXCsX3HtpLrYOSKEazerV+nU9IPqVlXh74LnJyAzGqswIxquo2Opk5VTfu6tEYuDeXl1o05jVL6j+HCKwBvFUG9AcjbcssLP1VOY1Zve8uN8ZpbW+yXzVNiFHvpOgY2RbLNQKZdSyRGGWXBW62wwvndyewrUwwU/HdZrOhubjc2qbozSvOJG7JSm4xOviqzyhGvTU0gRglheITo3fa9bJQMZrPq/XrfELyySylRNz+UZcTfSut3PSWLQWln9zy3WNAueXToxCjC7CfaOy6lDaqVz7m+67bo+2amVY0JCbbXfCzrpFi1FDVlhwps26zNJh+5GxprvPOTqU9o2T6Z7v17hQdsW5mco5AAZdcFM+eUbIUwH1WxldddRqTXjQRsox4M28K5Gx17MXZxy1ZSS5GB+k5MOW+zyVGQzbSpRCjyq8GzIS3bWnKln5lCnq1fp1PSCEx6loPNK595n14Zj9IVrrYJdHe6DTpdJJR0fuw64inT59CjLppQYxOlUMrU1NmqrKPa9ea1Nz1J/YIqgHeg4wlVOoaW38cObrhNldNsTYbpRccTjLOR8m8gI6n+sxo13Xbm9hJ6Rtt1jCrGHVvMNBS1KqfO46WOHucMcDam+znlqzkEKOD+qRKtM8nRid0J9Mf0opRz8zoaIxtJrVF4VXQq/XrfEIaEKMqSm8WUmruFLzdYJAahRj1Ul+MkvoSLkaJpFRjcbOKil40I9gqrL3GWm9g2my3G6vNxFZ1JorZNUjV7ebybieqHZtZV0l1MUrmCGMdzozEQWtzCcQoUz0NA7Sb5Oahlqmi1kSixOj0j0VuyUomMaop0b6AGB1ghu0w2eReiI9Zpp8NYVav3ClUo6BX69f5hDSxTK/3aMpkpnIt4dx9p6dg6wat/acrL5lW6iFGF2CeSJ9JVNqoY5neNZSy9Yz2AnqaRi3y3tpobxbGL2yOVCPc/fLNlunOW+zKM9CKGPVflZtpKAtA1hEozw1M8TOjzH9TzIymc0tWcuwZNZVon0mMupzsiaT72DWXGXMDk1JtOnNff5s9WEGv1q/zCSkkRvkL98mfzGY5BabnodhSCJsZDc4LxKiDimKU0XyRNzAZ0dj9oD2piEqEZUrUbgnXX3E50mIFiVH1lC125RloR4x65ag+ecqN3FyFjhyTAm9gosaSz8aslTJ9oHe+eiJLZkaTuSUrmW5g0pRoX+oGJosgYns6fYGHX2/SCyVcjHI7pTwpVKOgV+vX+YSUEqN6mdh6trkING3g2TPKpWDtBm39pycvOSZHIUYXYOwAcV6fGOXrF6NEaip9wnQuqkVZA3irdHSFaV9y53/mFuKVxE3LabzDW6b/k4Y6YlTdKcGhTtczVw7zgpFjYSeJGFWMUXpvM0fmqpbSf49pXHLjqFeMJnNLVoQ/Z7S3O3mCryraCpN27WUvFOPX+bQ2fSZOjPZ5vNpKnU9IOTHa2+8qIx7dbLfsGiqJPh9Wb1piUrB0gw5TPHmBGLVRS4ya3Rm54OAL2C9G1eVvZjwmEVgDrFapaJbQympchllyZB7kdyHoS16hVX8VlBGjkkjY8uMIXkSsZuEeJBSjn3wkOZFEJ7cPvLqMomJULFnFaJluhyWtGC2WkdxV68ayYTQ8AmiKBsUoOyck71abAJT597AVg76XOX6Is1mcwSKAV5cBMRpCPjFaF6FllNls78pPi0tDwEGDYrQyZVs+Vd6hglti3yTOZnEGiwBeXQbEaAgQo00h1GxQC4hRnfabUPsWmoizWZzBIoBXl7EyMardY+QO4clCjDaFULNBLaLF6HkwTwEAAAQQpc8OMCx2ZqbyAgBUFqMAAAD2obq2ExcWuzdTCQIA0gIxCgA4CKorKoTFYXFBZ6pLAIC0yBajFfs7AIAIqgspBDMUK/GsJwIApEKYGJXeSwJZSKwq1XUGwrIQWKbFKpJc4C4AxFFBjFbv9BcPCeCgqF4VEVYcFlfFTLV9TcBdAIgjoxit3t0XGCTAWqleDxFyhNrVaiEryEJJ4C4AxJFLjGJ0AdKprpwQUoXaVWlf1pSXAsBdAIgjpRjFuAIOiuoaC23kQED5RgFfASCOZGIUgyUAAGQC/Wc48BUA4kgjRiE6AQAgH+haw4GjABDHToz+329/0pBEjBaxHwAADgL0roHAUQCII7EYLWIzAAAcHNBYgcBRAIgjjRjt+x7NHgAAsgKZFQK8BIA4RjH69k8amn0DEwAAHCyQWSHASwCIA2IUAABkgH35IcBFAIgDYhQAAMQAPeoF/gFAHBCjAAAgBohRL/APAOKAGAUAAElAjzqAcwCQCMQoAAAIA5KLBW4BQCgQowAAIA+8asQErgBAKBCjAAAgEryHmQInACAXXozWtgoAAIAfmx49KDV2yHkHYB1AjAIAgGAcevRgQ+0yAQDEATEKAABroLoEbCTULgcAQDQQowAAsB6qa0HIUABALBCjAACwQqpLQ8hQAEAgkxj9i4baVgEAAAAAgIMAYhQAAAAAAFQDYhQAAAAAAFQDYhQAAGL4cPXl0ZPvHzyxfpwaWxtPr74fP/7y8iObzhz/+Opnf/sw/muO398+PDr7sfswJUss+XD15dHjh9dJMwsAAPmBGAUAgAh+nO4EIiM3Hz3+fHprxvz58sl4/OP3451enH5VIr8+G8Xo2Q/LwVmVfrj6sjsypnB6Ro8AAIAIIEYBACCY12efT28HTfn59Lb/cPXl+Orn+COvLxUxStIhf+wXiVF6uukUzLkAAKBtIEYBACCMSXpOUpJqSnWestemTk9vf758wj2WaPeXeDF6+zCu0f98+UQTwdCjAABBQIwCAEAQRE2OOzVfn02ftWnR3j4zyk5eRovR3Rxtb9G4j7WZVwAAaBaIUQAAiODHKblJ6PXZeI/Rx+/H+rbRYDFK/suFL8dPLDOjjx9Oz9hdqruzQI8CACQAMQoAAKFo058/Xz75fHz2cKzeRTRGUJfpr2yKc7odKvoGJtvGUwAAEMVOjP7/279oqG0VAAC0x4erL0REPrzezXHOWzbN29u5mdEfp/NW0V6LHH83/QN7U7/21CcAAGgYiFEAAFjG9Jymj9+Pn3z/8FF5jKhVjN4+PHry5Vh/IKiiO0dRG/Vopx4zowAAmUCMAgBAOOP+TiIZ+36cNLU9rYncOL8TprqOHHXtJEaPr366xKiyxD+J3SG+dnM9AAA0DsQoAAAEMewBHWc06TzopA6VNXrloU7DzCh565I5Xfr9wyhGxzvl1ZlOY2a0H9MZRbDyQH7cvQQAEALEKAAARDNJwOHJSjvJON9cb0Q+vR00K1mdH5+c32sPLj17YN/SNE+mEjGq3sOk3U2P+VEAgAhGMfqPv2iobRUAADQM2dNp3Ip0+/BIf+b8z5dPPp+ePXAvjh8eUD88Lmo3mXr85MtuD8A4ETst9O90pzIzOp8UNy0BAGQCMQoAAAAAAKoBMQoAAAAAAKoBMQoAAAAAAKoBMQoAAAAAAKoBMQoAAAAAAKoBMQoAAAAAAKoBMQoAAAAAAKoBMQoAAAAAAKoBMQoAAAAAAKrxb6k9/U61EYqTAAAAAElFTkSuQmCC" alt="" />

EF 主键自增、级联删除

使用Fluent API:

modelBuilder.Entity<Lodging>().HasRequired(l => l.Destination).WithMany(d => d.Lodgings).WillCascadeOnDelete(true);

相对应的,如果要关闭级联功能则为:

modelBuilder.Entity<Lodging>().HasRequired(l => l.Destination).WithMany(d => d.Lodgings).WillCascadeOnDelete(false);