How to connected Architecture

Connected Architecture

Definition :

                As the name suggests, connected architecture refers to the fact that the connection is established for the full time between the database and application. For e.g. we make a program in C# that is connected with the database for the full time, so that will be connected architecture.

Connection architecture :

              Connectivity architecture connects main functional blocks or entities of a system with well-defined interfaces enabling interoperability, fluent data flows and information sharing in timely manner. Local connectivity architecture defines e.g. the architecture inside an autonomous ship.

Working with connected Architecture:web Technology >Asp. Net

             Connection Oriented architecture is achieved by the use of Connection, Command and DataReader object.

SqlCommand cmd=new SqlCommand("SQL query or stored proceducer ",conn);

Connected Architecturearchit. NET:

The architecture of ADO.net, in which connection must be opened to access the data retrieved from database is called as connected architecture. Connected architecture was built on the classes connection, command, datareader and transaction.

ADO. NET architecture cconnection : in connected architecture also the purpose of connection is to just establish a connection to database and it self will not transfer any data.

DataReader: DataReader is used to store the data retrieved by command object and make it available for .net application. Data in DataReader is read only and within the DataReader you can navigate only in forward direction and it also only one record at a time.

To access one by one record from the DataReader, call Read() method of the DataReader whose return type is bool. When the next record was successfully read, the Read() method will return true and otherwise returns false.