Use CodeSmith project + generated nettiers the data access layer DAL feel good effect, reduces the amount of simple duplication.
However, in the course of CodeSmith can not fully meet the needs of the project, mainly reflected in two aspects:
1, Data.DataRepository.TableProvider.GetPaged method can not be entered with parameters conditions, the call must be performed before the SQL stitching,
This may lead to SQL injection attacks.
2, DataRepository.Provider.ExecuteDataSet can not be paged query

In order to solve the above problem, I made the following additional code generated DAL. These codes can be used outside the DAL can also modify netTiers
Templates, built-in to the DAL.

Last edited Apr 3, 2014 at 6:47 AM by ryanxu, version 2