I'm opening the generated Add-page from my own page. The primary key column of the table is not an Identity column, so the key value is always set to zero on save, instead of auto number. Obviously this only works once. Do the generated CRUD pages assume that the table's primary key is an identity column? The add page does not include the key column so I can't set it manually. Have I got to convert the table so it has an identity column? Or can I somehow auto generate a key value myself that is one more than the largest current key?
Northwind Customers primary key (CustomerID) is not identity and Radzen properly creates editor for Add page:
Does Radzen normally generate an ID field in the Add/Edit page if the ID is not an Identity, as in the Customers example? (The Orders table in Northwind does not generate an ID field in the CRUD pages, and that does have an Identity). But this did not seem to happen for me. None of my tables generated an ID field on the pages: three have no Identity, the others have an Identity). If it's not the Identity flag, what criteria does Radzen use when deciding whether to include the primary key on the forms?
Actually my preference would be to have the ID TextBox generated on the CRUD pages for this table, since the ID numbers have contextual significance, so should probably not be auto-number. I can just add it, but it would be a nuisance to have to repeat that if I regenerate the CRUD pages.
Yes.
Indeed OrderID in Northwind Orders is identity field
Radzen/Radzen Blazor Studio will not generate primary key editor for Add page if the field is database generated (identity, default value, etc.). There is no editor for Guid or byte also.
Ah, there were default value settings (incorrect) on the three tables involved, so that was what prevented generation of the ID field. I have removed them and it's OK now. Thanks for your help.