Linq Exception - Update without primary key

Search Options	close
Search the following clips: All Clips

news science politics food economy art
technology health internet religion psychology

Sign Up Install Learn More Login


	Linq Exception - Update without primary key

robertdondo

8-13-2009 5:09 AM

207 views

robertdondo says:

I was getting this error because I have a table without a primary key in the db, but need key in linqdatasrc. Sln was to set Auto-Sync to OnInsert as described in this clip.

Add a Comment

Login to Comment. Not a member yet? Sign up

Today's Top Clips

visit the Top Clips page

View the Top Clips from August 13, 2009

Embed This Clip In Your Site...

<div style="margin: 12px 0px; font-family: arial; color: #333333; background: #ffffff; border: solid 4px #e5e5e5; width: 100%; clear: left;"><div class="CM_CTB_Content_Wrap" style="margin: 0px; padding: 0px;background-color: #ffffff;"><div style="border-bottom: solid 1px #dcdcdc; white-space: nowrap; margin-bottom: 8px; background-color: #eeeeee ;background-image: url(http://clipmarks.com/images/source-bg.gif); background-repeat: repeat-x; height: 24px; line-height: 24px; vertical-align: middle; padding-bottom: 4px; color: #666666; font-size: 10px;" ><a href="http://clipmarks.com/clip-to-blog/" title="see clips that are hot right now"><img src="http://content.clipmarks.com/blog_embed/25a73220-e94d-4c03-baa1-7d48f85dd20a/1973FDC2-2167-4FBA-B708-6F1E1A930E11/" alt="" width="19" height="19" border="0" style="vertical-align: middle; margin: 0px 4px; display: inline; border: none; float:none;" /></a>clipped from <a title="http://stackoverflow.com/questions/358821/linq-to-sql-error-with-identitiy-increment-field" href="http://stackoverflow.com/questions/358821/linq-to-sql-error-with-identitiy-increment-field" style="font-size: 11px;">stackoverflow.com</a></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://stackoverflow.com/questions/358821/linq-to-sql-error-with-identitiy-increment-field"><H2><A class="question-hyperlink" href="http://stackoverflow.com/questions/358821/linq-to-sql-error-with-identitiy-increment-field">Linq to sql error with identitiy increment field</A></H2></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://stackoverflow.com/questions/358821/linq-to-sql-error-with-identitiy-increment-field"><P>I've just started to use linq to sql and have run into a problem with inserting a record with an auto incrementing field.</P></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://stackoverflow.com/questions/358821/linq-to-sql-error-with-identitiy-increment-field"><P>I have created a new instance of a company object defined by linq. it has initialised an auto incrementing field 'companyID' to 0.
InsertOnSubmit() fails with the following invalidOperationException.</P></blockquote><div style="border-bottom: solid 1px #dcdcdc; white-space: nowrap; margin-bottom: 8px; background-color: #eeeeee ;background-image: url(http://clipmarks.com/images/source-bg.gif); background-repeat: repeat-x; height: 24px; line-height: 24px; vertical-align: middle; padding-bottom: 4px; color: #666666; font-size: 10px;" ><a href="http://clipmarks.com/clip-to-blog/" title="see clips that are hot right now"><img src="http://content7.clipmarks.com/images/clip-icon.gif" alt="" width="19" height="19" border="0" style="vertical-align: middle; margin: 0px 4px; display: inline; border: none; float:none;" /></a>clipped from <a title="http://stackoverflow.com/questions/358821/linq-to-sql-error-with-identitiy-increment-field/358921#358921" href="http://stackoverflow.com/questions/358821/linq-to-sql-error-with-identitiy-increment-field/358921#358921" style="font-size: 11px;">stackoverflow.com</a></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://stackoverflow.com/questions/358821/linq-to-sql-error-with-identitiy-increment-field/358921#358921"><P>Found the answer. It was to do with primary keys. In the linq designer the primary keys were setup as they should be. In the database the relevant fields were not set as primary keys. I fixed the keys in the databse and this resolved the problem.</P></blockquote><div style="border-bottom: solid 1px #dcdcdc; white-space: nowrap; margin-bottom: 8px; background-color: #eeeeee ;background-image: url(http://clipmarks.com/images/source-bg.gif); background-repeat: repeat-x; height: 24px; line-height: 24px; vertical-align: middle; padding-bottom: 4px; color: #666666; font-size: 10px;" ><a href="http://clipmarks.com/clip-to-blog/" title="see clips that are hot right now"><img src="http://content8.clipmarks.com/images/clip-icon.gif" alt="" width="19" height="19" border="0" style="vertical-align: middle; margin: 0px 4px; display: inline; border: none; float:none;" /></a>clipped from <a title="http://stackoverflow.com/questions/358821/linq-to-sql-error-with-identitiy-increment-field/358852#358852" href="http://stackoverflow.com/questions/358821/linq-to-sql-error-with-identitiy-increment-field/358852#358852" style="font-size: 11px;">stackoverflow.com</a></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://stackoverflow.com/questions/358821/linq-to-sql-error-with-identitiy-increment-field/358852#358852"><DIV class="post-text"><P>What is the data-type? int? (int both TSQL and in C#?)</p> <P>What auto-sync setting do you have? For a primary key, it should be "OnInsert"</p> </DIV></blockquote><div style="border-bottom: solid 1px #dcdcdc; white-space: nowrap; margin-bottom: 8px; background-color: #eeeeee ;background-image: url(http://clipmarks.com/images/source-bg.gif); background-repeat: repeat-x; height: 24px; line-height: 24px; vertical-align: middle; padding-bottom: 4px; color: #666666; font-size: 10px;" ><a href="http://clipmarks.com/clip-to-blog/" title="see clips that are hot right now"><img src="http://content9.clipmarks.com/images/clip-icon.gif" alt="" width="19" height="19" border="0" style="vertical-align: middle; margin: 0px 4px; display: inline; border: none; float:none;" /></a>clipped from <a title="http://stackoverflow.com/questions/358821/linq-to-sql-error-with-identitiy-increment-field" href="http://stackoverflow.com/questions/358821/linq-to-sql-error-with-identitiy-increment-field" style="font-size: 11px;">stackoverflow.com</a></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://stackoverflow.com/questions/358821/linq-to-sql-error-with-identitiy-increment-field"><P>Incorrect autosync specification for
  member 'companyID'</P></blockquote></div><div style="margin: 0px 6px 6px 4px;"><table style="font-size: 11px;border-spacing: 0px;padding: 0px;" cellpadding="0" cellspacing="0" width="100%"><tr><td style="background:transparent;border-width:0px;padding:0px;">&nbsp;</td><td align="right" style="background:transparent;border-width:0px;padding:0px;width:107px" width="107"><a href="http://clipmarks.com/share/1973FDC2-2167-4FBA-B708-6F1E1A930E11/blog/" title="blog or email this clip"><img src="http://content6.clipmarks.com/images/c2b-foot.png" border="0" alt="blog it" width="107" height="17" style="border-width:0px;padding:0px;margin:0px;" /></a></td></tr></table></div></div>

New from the makers of Clipmarks: Amplify.com - Don't just share the news...Amplify it!

Clipmarks: Home; New Clips; Top Clips; Dashboard

Popular Topics: News; Life; Science; Technology; Entertainment

Get Started: Sign Up; Install Clipping Tool; How Clipping Works; Clip-to-Blog™; ClipSearch

Tools and Resources: FAQ; ClipWeek; Top Clippers; Top Tags; Site Map

About Clipmarks: About Us; Contact; Copyright; Privacy; EULA

Search Options

Today's Top Clips