Kutenda nekuedza kwako, zvisinei:
Yako yekutanga sarudzo haina mutsauko kunze kwezita retafura rave kuwanda (kwete zvandiri kuda) uye zita reindekisi rinochinja kuva "IX_Entities_COL1_COL2" pachinzvimbo che "UniqueCOL1_COL2".
Iyo mitsara yakaiswa nechirongwa checonsoon yakafanana chaizvo nezvakaitika pakutanga (zvandinoona zvisina kusarudzika).
Yako yechipiri imwe nzira inokundikana kana uchiwedzera kutama nekuda kwe [] mabhureki akaenzana, kubvisa mabhureki akaenzana haatamire chero nekuti kodhi yangu inotsanangura zvakajeka ikholamu yeCOL2 SEZVINODIWA (zvinova ndizvo zvandiri kuda).
Wakaedza mazano ako pane kodhi yangu?
0 Votes0 ·
EuroEager2008-7858 avatar image EuroEager2008-7858 · Dec 09 2020 pa 3:50 PM
Ini handina zano nei ndisingakwanise kuwana yako yazvino mhinduro mune ino tambo nebrowser. Maonero angu anoratidza kuti wapindura seizvi:
Mhoro @ EuroEager2008-7858, Ini ndinoona kuti yako modheni munda tambo, ndapota ita shuwa kuti haina kuseterwa nvarchar (MAX) kana varchar (MAX) muSQL Server. Uye yako mhando yeakasarudzika hunhu tambo dzese, saka waisa iyo MaxLength? Zvakanakisisa, Daniel Zhang
Mhinduro yangu: Chokwadi, kutama kunovimbisa kuti indekisi minda (COL1 neCOL2) ese ari maviri akagadzwa se nvarchar (450) neef core (mushure mekuvandudza-dhatabhesi). Zvimwe pane izvo, ini handinyatsonzwisisa zvaunoreva uchiti "Uye yako mhando yeakasarudzika hunhu tambo dzese, saka waisa iyo MaxLength?"
Iyo dhatabhesi yaive / inogadzirwa zvizere neef core, yakatanga nedrop-dhatabhesi uye haina kuibata "nemaoko"
0 Votes0 ·
DanielZhang-MSFT avatar image DanielZhang-MSFT EuroEager2008-7858 · Dec 10 2020 pa 1:30 PM
Mhoro @ EuroEager2008-7858,
Ndakaona kuti waisa iyo COL1 neCOL2 kuna nvarchar (450), saka ndakadzima chirevo changu chakaratidzwa neAptlook yako.
KUDZIDZISWA [PK_Entity] CHEMAZWI CHINOKOSHA CHAKAKOMBEDZWA
Chirevo ichi chinoshandiswa nei? Uye ini ndaita bvunzo neprojekti yako, ichi chirevo che sql chinotaura kukanganisa mune sql server.
COL2 inobvumira null, saka haigone kuiswa yekutanga kiyi. Saka ini ndinoshandura kuenda kuCONSTRAINT PK_HISTORY PRIMARY KEY (COL1)).
Shuwiro yakanaka,
Daniel Zhang