Jul 21, 2010 at 4:22 AM
Edited Jul 21, 2010 at 4:23 AM
We are building a custom framework which supports the database operations and returns the results specific to our requirement.
The requirement is in some cases we may need to support transactions and in other cases we may not.
We have our custom datamanager which supports the operations we need. Currently it does not support Transactions.
How will I have my custom framework support this i.e. When will I create a transaction and when will i commit. How will I define the scope.
2. Returning Multiple result set:
Currently the way framework is desinged is developer calls a framework method say GetList<T>, framework executes the command and parses the result set and send the list of entity of Type T.
Framewrok GetList method:
List<T> entityList =
using (IDataReader reader = Database.ExecuteReader(command))
entityList.Add(entityBuilder.Construct(reader)); //We build the entity here
But how will I support returning multiple result set?