Hello, i am new in the MS dev tools, bu i have a problem which i think lot of people faced before...
I am dveloping ecommerce application with simple cart within. Cart is created as a List<String>, where
strings are GUIDs. I need to show the content of the cart. Content is stored in the MSSQL database.
I am looking for an easy way how to retrieve data according the guids from the database.... I have a problem
passing multiple GUIDs (idproject) as a parameters into the query which looks like >
select * from projects where (idproject in (@projects));
parameter idprojects should be a multiple GUIDs, because i want to show more than one item from the cart.
I would like to have sql statement like .... select * from projects where (idproject in ('F8F0CDF9-2EBD-F0B3-2B77-A15A239EA388', 'F8F0CDF9-2EBD-F0B3-2B77-A15A239EA3ss'));
Can you help me?< ...
Go to the complete details ...