The table in the SQL database has a MessageID column which is a BigInt with primary key (NOT NULL IDENTITY 1 1) no Default.
The field looks like this in the designer file to the dbml:
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_MessageId", AutoSync=AutoSync.OnInsert, DbType="BigInt NOT NULL IDENTITY", IsPrimaryKey=true, IsDbGenerated=true)] public long MessageId { get { return this._MessageId; } set { if ((this._MessageId != value)) { this.OnMessageIdChanging(value); this.SendPropertyChanging(); this._MessageId = value; this.SendPropertyChanged("MessageId"); this.OnMessageIdChanged(); } } }
So the problem is that null cannot be assigned... right. But I'm not passing null! How can I be? I'm using a long (a value type so can't be null by nature).
One workaround I found was making this field nullable but this feels like a hack since it should never be null. Anyway this just moves the problem to the ID not AutoSyncing OnInsert. (AutoSync=OnInsert is set).
Great blog. Thank you! I put your feed on my RSS reader!
ReplyDeleteThesis Writing
Are you looking for Cheap and best Essay Writing Service, stand out from our competition as the prime essay service provider.
ReplyDeleteMore to visit:http://www.academicessaywritingservices.org/
Informative blog with good useful information.
ReplyDeleteessaywriting-uk.co.uk
Very interesting posts, it is really informative to read these posts Keep posting.
ReplyDeleteAffordable Essay Writing Services UK | UKEssayPapers
Such an interesting blog. Thank you for sharing such post. visit my website to see my works.
ReplyDeleteAwesome post about also check it Blog! Cider apk download Diskdigger download Mi account unlock tools
ReplyDeleteSuch a nice blog and I appreciate your all efforts about your thoughts. it’s really good work. well done. I would like to share something really helpful for education.
ReplyDeletecoursework writing service