I am in charge of design an application (.NET) that has these features:
My doubts/questions are:
A)I want to put all the logic inside the app, avoiding the use of stored procedures in the database. I don´t like he fact they can not get tested and thei appearance of being a black-box outputting data. I am right? I prefer to have them implemented in Linq or other approach you think could fit. Do you see some disadvantage on that? Probably memory issues? ( The managed data contains thousands of records)
B) The queries logic should go in the domain layer. Which will be a good pattern/approach to store them?
C) Do you know a nice approach to unit test the queries in LINQ? Fake data, moqs, etc? Some advice on that?