Ado.Net is set of classes given as part of .Net Framework by Microsoft. These classes allow us to manipulate and update the data from different-different data sources. It is the upgraded version of previous ADO technology.Ado.Net can be the component of any .net Application like
Windows Application ,web Application or xml web Service Application which is a part of .net framework.
Ado.Net stands for ActiveX Data Objects. It includes five objects like Connection,Command,DataReader,DataAdapter and DataSet. This Object model has been categorized under two different models.
1)Ado.Net Connected Model
2)Ado.Net Disconnected Model
Connection, Command and DataReader is used in Connected Model where explicit opening and closing of connection is required.Connection object is used to establish the connection to server with name of server,credentials as per authentication and database name. Command object is used to fire DML operations against database with prior information about connection object. DataReader is used to read the stream of data in read and forward only manner.
Disconnected Model is used with DataSet object without need of explicit opening and closing of connection object. Connection,Command,DataAdapter,DataSet objects are used in disconnected model.
Where DataAdaper is used to fill the DataSet and update the DataBase of actual DataBase server.
DataSet is used as cursor area at client side or server side as temporary cache memory. DataSet is used to work with different type of DataSources at a time.
This blog by Visual Coder (Division of SQUAD Infotech Pvt. Ltd.)
About Visual Coder (Division of SQUAD) :-
Visual Coder(Division of SQUAD) is Mumbai s first dedicated Professional Training Center for Software Training and English communication. The strong foundation of Visual Coder(Division of SQUAD) is laid by Corporate Training Professionals, having mission to provide highly skilled and trained Software Professionals to IT companies.
Visual Coder (Division of SQUAD) is Professional Training Center, not an institute / class. Visual Coder(Division of SQUAD) conducts career oriented, Professional Training-***-Placement programs (courses) .
About SQUAD:- We impart training JAVA/.Net /Software Testing/PHP/Digital Marketing and English Improvement program, imparting training to fresh graduates and offer them placements in various IT companies. We offer free placements, open to all candidates. All career aspirants who wish to pursue their career in IT, having possessed the technical skills, can approach us for their career path/growth and placement. ? For Training and 100% placement call / whatsapp: 7718819172
SQUAD Specializes in:
? Training under Corporate trainers. ? International Certification Preparation. ? Get an exposure to REAL project testing. ? Weekend sessions for working professionals.
? Audio/video lectures.? 100% Job Assistance / Guarantee until you get placed. ? Technical & HR Interview Preparation. ? Free Demo Lecture available prior to the commencement of new batch. ? Group Discount Available. ? Session for Personality Development and Communication Skill. ? Free Reading material.
For More Contact Us:
Nerul Office :
B - 117, 1stFloor, Nerul Railway Station Complex, Nerul (E), Navi Mumbai,
Maharashtra - 400 706
------------------- -------------------------------------------------- -------------------------------------------------
Thane Office :
Shop No. 1 and 2ndFloor Terrace Office, Siddharth Tower, Thane(W),
Maharashtra -400 601