Hey Frans -

How do I create an entity on a non-key field? I.e.

NewEntity entity = new NewEntity(non_key_field_value);

Do I have to go through an intermediate step like this:

int keyFieldValue = 0;
int nonKeyFieldValue = 100;
int KeyFieldValue = RetrieveProcedures.GetKeyValueFromTable(nonKeyFieldValue, ref keyFieldValue)
NewEntity entity = new NewEntity(KeyFieldValue);

Thanks!

Jeff

Is it a unique constriant?

You can use this from the docs if it is.

// [C#] CustomerEntity customer = new CustomerEntity(); customer.FetchUsingUCCompanyName("Chop-suey Chinese");

You could simply add a static method to the entity that uses an EntityCollection to do a search, which would return one result, and you could return that entity.

Good ideas! Thanks.