Derik Whittaker

Syndication

News


Images in this post missing? We recently lost them in a site migration. We're working to restore these as you read this. Should you need an image in an emergency, please contact us at imagehelp@codebetter.com
Linq2Sql and AutoIncrement on TinyInt

Can someone help me with this?  I was trying to insert a record into our DB where the data type was a TinyInt and received this error "The primary key column of type 'TinyInt' cannot be generated by the server. ".

I did a bit of Googling and found one post where it states the Linq does not support TinyInt for AutoIncrement columns. 

Is this true?

Is there a reason?

I was able to switch the data type to SmallInt and all was good.

Looking for feedback.

Till next time,


Posted 03-25-2008 3:15 PM by Derik Whittaker
Filed under:

[Advertisement]

Comments

Reflective Perspective - Chris Alcock » The Morning Brew #59 wrote Reflective Perspective - Chris Alcock » The Morning Brew #59
on 03-26-2008 4:07 AM

Pingback from  Reflective Perspective - Chris Alcock  » The Morning Brew #59

Shane wrote re: Linq2Sql and AutoIncrement on TinyInt
on 07-21-2008 10:55 AM

Just googled the error about tinyint, got to your site, changed to smallint and all now works well.

What did we do before google eh? :)

thanks for posting, thought it is a little worrying why this happens.

almny wrote re: Linq2Sql and AutoIncrement on TinyInt
on 10-26-2008 4:39 AM

i get the same error and try to search for the reson

About The CodeBetter.Com Blog Network
CodeBetter.Com FAQ

Our Mission

Advertisers should contact Brendan

Subscribe
Google Reader or Homepage

del.icio.us CodeBetter.com Latest Items
Add to My Yahoo!
Subscribe with Bloglines
Subscribe in NewsGator Online
Subscribe with myFeedster
Add to My AOL
Furl CodeBetter.com Latest Items
Subscribe in Rojo

Member Projects
DimeCasts.Net - Derik Whittaker

Friends of Devlicio.us
Red-Gate Tools For SQL and .NET

NDepend

SlickEdit
 
SmartInspect .NET Logging
NGEDIT: ViEmu and Codekana
LiteAccounting.Com
DevExpress
Fixx
NHibernate Profiler
Unfuddle
Balsamiq Mockups
Scrumy
JetBrains - ReSharper
Umbraco
NServiceBus
RavenDb
Web Sequence Diagrams
Ducksboard<-- NEW Friend!

 



Site Copyright © 2007 CodeBetter.Com
Content Copyright Individual Bloggers

 

Community Server (Commercial Edition)