Hi,
I'm new to entity & nop, and I'm working on a project which is based on v1.9 and was developed by someone else.
Now, I need add a customization for the product. when buyer select a product, we need the buyer fill in some questions, then let him check out.
the question is saved in a new table, following
https://www.nopcommerce.com/boards/t/6968/i-need-help-in-adding-extra-product-fields-in-database.aspx?p=3
I was able to add the new table, create a new service, and query the data using the new service. However, I realized that I may have to use store procedure. How can I do it? is there a step-by-step tutorial, just like the above one?
I created the sp in database, updated the NopModel.edmx, then what else?
I also read from a post, a team member said that nop tries to get away from store procedure, is there any reason for that? or, I misunderstood it?
thanks
reader