I am not sure whether to ask this question here. I have a requirement where I have to validate a product code entered by a user on a page. Client will provide product data in
CSV format and that will be in thousands.
My question is: what is the best way to achieve this?
I thought to dump a csv file in some folder and then write .net code to read it. However this solution is supposed to be global and will be used by more than one site.
I thought to create WEB API/WCF Service which will read the Product data and verify against user product code. However I am not sure where should I store product data?
I also came across
oData but not sure whether to use it for this solution.
My main concern is, where should the Product data be stored?