From the doc's I tried to use the following via Self-Servicing and got the message: "The field ContainerId is read-only and can't be changed"

From the doc's the code below should work My Code: ContainerEntity ce = new ContainerEntity(); ce.ContainerId = 1; ce.IsNew = false; ce.UniqueId = _UniqueId; ce.Save();

Documentation Code: // [C#] CustomerEntity customer = new CustomerEntity(); customer.CustomerID="CHOPS"; customer.IsNew=false; customer.Phone = "(605)555-4321"; customer.Save();

Any thoughts?

Thanks

ContainerId field being an identity can't be updated and would be marked as read only in the designer. You could do this instead.

ContainerEntity ce = new ContainerEntity(1);
ce.UniqueId = _UniqueId;
ce.Save();

Right, but that causes a fetch, which I don't want. Thanks.

The following Note was copied from the LLBLGen Pro documentation "Using the generated code -> SelfServicing -> Using the entity classes -> Modifying an Entity"

If you want to set an identity primary key column, you'll notice you can't do that because it is marked as read-only. Use the method entityObject.Fields[fieldindex or fieldname].ForcedCurrentValueWrite(value). See the reference manual for details about this method (EntityField.ForcedCurrentValueWrite).

Oops, stopped reading after it didn't work

Will that force an identity_insert or does that just allow me to reference the field as the key? I'm not wanting to update the key, just use it as the identifier iin the update.

Thanks!

Never mind, found the info in the reference docs. Thanks for the heads up.

No joy:

Here's the SQL that's being executed: declare @P1 int set @P1=NULL exec sp_executesql N'INSERT INTO [dbo].[Container] ([ProcessCodeId]) VALUES (@ProcessCodeId);SELECT @ContainerId=SCOPE_IDENTITY()', N'@ContainerId int output,@ProcessCodeId int', @ContainerId = @P1 output, @ProcessCodeId = 24 select @P1

Here the setup for LLBL... ContainerEntity ce = new ContainerEntity(); ce.Fields["ContainerId"].ForcedCurrentValueWrite(Convert.ToInt32(aNode.Tag)); ce.ProcessCodeId = (int)grdMain.Selected.Rows[0].Cells["ProcessCodeId"].Value; ce.Save();

try this

ContainerEntity ce = new ContainerEntity();
ce.Fields["ContainerId"].ForcedCurrentValueWrite(Convert.ToInt32(aNode.Tag));
ce.ProcessCodeId = (int)grdMain.Selected.Rows[0].Cells["ProcessCodeId"].Value;
ce.IsNew = false;
ce.Save();

Worked like a champ! Thanks bclubb.