How can we put unique on two columns in mvc4

Hi,

this is started from 6.1 onwards.

but i want to use in 5.

please tell inmvc

Take a look of this as well

http://www.codeproject.com/Articles/797444/ASP-NET-MVC-Edit-Primary-Key-Values-for-Composite

Is this question related to MVC or SQl server.

Anyways choose any two column which will provide unique result.

In a table , Primary Key that provide unique result with a combination of two or more column is Composit Key.

Please share your column details.

Refer below Code:

[Index("IX_BlogIdAndRating", 2)]

public int Rating { get; set; }

[Index("IX_BlogIdAndRating", 1)]

public int BlogId { get; set; }

Reference: https://msdn.microsoft.com/en-us/data/jj591583.aspx#IndexMulti