Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Handling Identities
Message
 
 
To
12/03/2010 14:43:26
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Miscellaneous
Thread ID:
01454212
Message ID:
01454216
Views:
46
You can not set identity field (it's generated automatically by SQL Server).

Only if you have SET IDENTITY_INSERT ON for the table you would be able to update identity field.

>Hi,
>
>I have changed a varchar column to a smallint identity column, regenerated using the Business Layer Generator, but when I run my application I get this error:
>
>Column 'AgentNumber' is read only.
>
>in my AgentEntity class on this code:
>
>
>		public Int16 AgentNumber
>		{
>			get
>			{
>				if (this.Row != null)
>					return (Int16)mmType.GetNonNullableDbValue(this.Row["AgentNumber"], "System.Int16");
>				else
>					return this._agentNumber;
>			}
>			set
>			{
>				if (this.Row != null)
>					this.Row["AgentNumber"] = value; 
>				this._agentNumber = value;
>				this.OnPropertyChanged(new PropertyChangedEventArgs("AgentNumber"));
>			}
>		}
>		private Int16 _agentNumber;
>
>The error occurs on this.Row["AgentNumber"] = value;
>
>What have I done wrong/missed out here?
>.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform