Data Access Layers with Table Adapters RRS feed

  • Question

  • hi,

    i'm creating a  Data Access Layer component for a number of tables to perform CRUD operations including the custom Select,Insert ,update and Delete depending upon the stored procedures.
    While designing this in terms of performance management,is it nice to
    1.create table adapter for  each table and associating the procedures for each and every table  or
    2.Create a custom class which maintains the connection to create and close and also calling the execute scalar  ,execute non query etc to perform the same by using the Enterprose library from Microsoft.Practices.Enterprise。

    Also how can we implement the transaction ,committing and roll baclk with the  table adapter

    What are the disadvantages of Table adapter ?


    Thanks in advance.


    Thursday, January 3, 2008 10:10 AM

All replies