Hi Bob,

I have actually manually adjusted the code generated by the generator (I commented out the Set method on the entity and removed references to the field in the data access) and adjusted the stored procedures accordingly. This fixes the problem, until next time I generate. How do I fix this once and for all so that the generator does not generate this code?

>Frank,
>
>Check your Insert stored procedure (or SQL statement depending on what you use) for inserting into your base table and be sure you do not have a value that is passed in for this identity column. If you didn't regenerate the data access layer using the BLG, you would have a problem with this.
>
>
>Bob
>
>>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?
>>.