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
Post a Comment