Hi Frank,

You shouldn't have to do anything for this. The problem (I believe) was not with the Set method but with the fact that you were attempting to explicitly save the identity column value in your data layer. I believe if you regenerate the object again (and be sure to regenerate the data access layer and redefine stored procedures) you will not have this problem.

To confirm this, check any other business objects you have that has an identity column. You will see that the properties for the identity column (in the Entity object) are as you have listed previously for your agent number.

Bob

>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?
>>>.