Hii friends,Today one of my frend ask about what approach is better connected or disconnected architecture ..So let me explain more about this problem :-
As the nature of HTTP protocol,.Net web applications are always disconnected so your problem is about connected or disconnected data models.
"connected" data is always faster as compare to "disconnected" because of the internal optimizations provided by the data provider,data adopters and others like data tables but always remeber that fetch out the data when you need so disconnected data model is good.
Connected :-
**User can get the data from database in connection state using data reader,adaptor,data table.1 :- Using this communication will possible in between the front end & backend (UI and database).
2 :- This command object have some parameters and have some methods to execute stored procedure ExecuteNonQuery(),ExecuteReader(),ExecuteScalar(),
ExecuteXMLReader()
ExecuteNonQuery :- For executing DML statements.
ExecuteReader :- This method returns DataReader.
ExecuteScalar :- This method is used for executing those SQL statements which generates single value.
ExecuteXMLReader :- This method is mainly used for reading an XML file content.
Disconnected :-
** User can get the data from database in connectionless state using data set.
As the nature of HTTP protocol,.Net web applications are always disconnected so your problem is about connected or disconnected data models.
"connected" data is always faster as compare to "disconnected" because of the internal optimizations provided by the data provider,data adopters and others like data tables but always remeber that fetch out the data when you need so disconnected data model is good.
Connected :-
**User can get the data from database in connection state using data reader,adaptor,data table.1 :- Using this communication will possible in between the front end & backend (UI and database).
2 :- This command object have some parameters and have some methods to execute stored procedure ExecuteNonQuery(),ExecuteReader(),ExecuteScalar(),
ExecuteXMLReader()
ExecuteNonQuery :- For executing DML statements.
ExecuteReader :- This method returns DataReader.
ExecuteScalar :- This method is used for executing those SQL statements which generates single value.
ExecuteXMLReader :- This method is mainly used for reading an XML file content.
Disconnected :-
** User can get the data from database in connectionless state using data set.
Posts
