none
Design of SQL database connection in C#

    Question

  • Hellol, people.

     

    I am trying to create a sql database in C# using SQL Express.

     

    I can make a connection to the database and select, update, and delete.

     

    However, i am not sure if it is design of SQL database connection.

     

    I just use dataset and adapter for it.

     

    The connection is permanently connected to database if they dont close it.

     

    The current situation is that i want to create a database that can manage client, product, address, stock information.

     

    If anyone knows the best of of desiging SQL connection, please tell me.

     

    Best regards.

    Monday, January 21, 2008 10:42 AM

Answers

  • Hi,

    When you are using dataset and adapter for sql connection. You should remember that the disconnected layer represents a local copy of any number of related data tables, each of which contain a collection of rows and column. Using the DataSet, the calling assembly (such as a web page or desktop executable) is able to manipulate and update a DataSet’s contents while disconnected from the data source, and send any modified data back for processing using a related data adapter. The disconnected layer helps quickly free up connections for other callers and goes a long way to increasing the scalability of your systems.

     

     

    Regards

    Jing

     

    Tuesday, July 22, 2008 11:31 AM

All replies