Design of SQL database connection in C#


  • 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


  • 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.






    Tuesday, July 22, 2008 11:31 AM

All replies