asp.net mvc 3 - What is the best strategy for calling Stored procedure in MVC? -


i using repository pattern in asp.net mvc3. extracting data through stored procedure.

should create different repository each stored procedure or create single repository class procedures?

i can't embed them in table classes few of them gets data 2 or more tables.

so can best option per repository pattern?

repositories should handle model , it's aggregates. doesn't matter of use plain sql or sp fetch those.

in other words: method used fetch objects not important. can sql statements, stored procedures, web services or whatever.

what's important group objects belong , put them in same repository class. classical example order , orderline.


Comments

Popular posts from this blog

c# - SharpSVN - How to get the previous revision? -

c++ - Is it possible to compile a VST on linux? -

url - Querystring manipulation of email Address in PHP -