I am reviewing an example project using MVVM and Store Procedures for DB access in SQL Server. I wanted to know if there is a maximum number of fields that can be passed to a Store Procedure from C#.
In the example they put 6 fields, but if I have a table with 30 or 40 fields (invoice, reference guide), considering that the vast majority are entered by the user, is there a better way to send them to the table?
This is the example line of code.
dc.AddProduct(p.CategoryName, p.ModelNumber, p.ModelName, p.UnitCost, p.Description, ref newProductId);