How to implement Unique Attribute in property/field

[harifenny]

In any condition we have to unique for property in database

https://www.w3schools.com/sql/sql_unique.asp

How to implement in Serenity? I just use [Unique] attribute but can not work

Thanks & Regars,
Hari Setyawan

[minhhungit]

It has UniqueConstraint attribute, put it on your row class, like this

[UniqueConstraint(new[] { "SupplierId", "OemNumber", "StockNumber", "YardLocation" })] 
public sealed class InventoryStoreRow : Row, IIdRow, INameRow { 
  [DisplayName("Id"), Identity] 
  public Int32? Id { 
    get { return Fields.Id[this]; } 
    set { Fields.Id[this] = value; } 
  }
}

[harifenny]

Hi minhhungit, thanks for your reply. From your suggestion, I just modify with add

[UniqueConstraint(new[] { "ItemCode"})]

In ItemRow class, and create unique constraint in database with this script

Alter Table Item Add CONSTRAINT ItemCode UNIQUE (ItemCode)

But, I got an error like this

How to fix it?

[harifenny]

I am also trying to modify with this link Handling unique key constraints #3395 but I got still an error

[minhhungit]

After adding the attribute, it will prevent user insert duplicate row. The error said that you row with ItemCode 001 is existed, so that is expected

[minhhungit]

You might need to check your database and remove duplicated row

[harifenny]

Finally, I just copy paste like in UserRepository.cs to implement my problem.

Thanks a lot

[harifenny]

Finally, I copy paste like in UserRepository.cs to implement my problem. Thanks a lot