I have a situation where I am passing lots of data from frontend page to the SQL Server using variable type tables.
My question is should I pass actual character values as selected by users from dropdowns or check boxes to the backend to store into normalized database after using lookups to find their ids and store them into tables
Should I find the Id values beforehand for the string values selected from the dropdowns or for the radio buttons and pass these Ids to store into SQL Server tables.
During the first insert of the record it adds record to Master tables so it has to populate master table then populate child tables.
Which approach is better?
Your comments and suggestions are appreciated.