Is it possible to use an ID other than the Primary Key to identify database records in ASP.NET MVC?
We're currently looking at updating an old system into .NET, and the original database structure has two IDS:
sqlID and then page ID. At the moment, the website pages are called from a database based on a page ID, so they don't change if the database is migrated etc, whilst the sqlID can change as and when needed based on database migrations and such.
So, my question is, when doing an Edit action for example, rather than clicking "Edit" in a table and the ID it uses to find that record being a primary key, is there a way to do it based on another column?