Data Access

Data access is the key aspect of the application where the data moves from the application to a persisted data storage. Many aspects have to be considered in this part of the application stack including security, concurency, transactions, scalabity, throughput... the list goes on. It is true that many parts of the application stack need to consider these aspects, however we have found that so often they tend to be seriously overlooked in this cruical layer. To remove many of the complexities of data access many architectural design take advantage of ORM's or code generation which help manage these concerns. which ever your choice ADO.Net is at the foundation of it all and if you are up to the task, direct ADO.Net calls cobined with well structured Stored Proceedures can be the cleanest & fastest way to manipluate data, especially on data that may poorly map to the OO world.

Development

Full Stack has extensive commercial experience in pure ADO.Net, NHibernate and CodeSmith with (modified) NetTiers DAL generation. Other DAL frameworks used inlcude ActiveRecord from the Castle Project, LLBGen Pro, Base4.Net and a personal favourite SubSonic (formerly action pack).

Along with proper data base design, the implementation of a well designed DAL can transform the performance of the application and greatly reduce time spent on the "plumbing" associated with data persistance, freeing developers up to focus on business problems at hand.