How can we put unique on two columns in mvc4

Question

Hi I have to use unique key constraint on two columns in mvc4. how can we do this please help.

Kuldeep Katiyar · Answer

Hi this is started from 6.1 onwards. but i want to use in 5. please tell inmvc

Nishant Mittal · Answer

Take a look of this as well http://www.codeproject.com/Articles/797444/ASP-NET-MVC-Edit-Primary-Key-Values-for-Composite

Nishant Mittal · Answer

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.

Rahul Chavan · Answer

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