What is ado.net

-


Ado.net is a set of software components that expose data access service for .net framework programmers. Basically it is a part of the base class library in .net framework. Programmers used this for creating database driven applications.

Ado.net has two primary parts.
  • Data provider
  • Data set


What is the data provider?


It is a set of related components work together to provide data in an efficient manner. Data provider means providing data from a data base. Here we use two types of databases.
  • SQL : used for SQL server
  • OLEDB : used for oracle, My SQL, Access


Data provider consist 4 main components.
  • Connection object
  • Command object
  • Data reader object
  • Data adapter object


What is Data set?

This is a disconnected, in memory representation of data. The data is data set can be loaded from any valid data source. Data set is made my data adapter.it has two components as Data table and Data relation.
A dataset object represent a schema (either an entire database or a subset of one).Data set has the data table. A data table object represents a single table in the database.it has a name rows and columns.


Components of data provider


Connection object

This provide the connection to the database.it has ConnectionString property that contains all the information which required to connect the database.


Command object

Use to perform some action on the data source, such as reading, updating, or deleting relational data.it containing some execution methods such as ExecuteNonQuery, ExecuteScalar and ExecuteReader.

Data reader object

It provides a forward-only, read-only, connected record set from a database. Since it is connected to the database throughout its life time, it requires exclusive use of connection object.

Data adapter object

Facilitating all communication between the database and a dataset and used to fill a data table or data set with data from the database with its fill method.



Comments

Post a Comment

Popular posts from this blog

What is Rapid Application Development

-
Image
Rapid Application Development (RAD) is a software development life-cycle designed to give; much faster development and higher-quality results than those achieved with the traditional life-cycle High speed, High quality, low lost are the three main goals of rapid application development. We use RAD to Takes advantage of automated tools and techniques because it allows organizations to build software applications faster, better, and cheaper. RAD Model The process of writing the software itself involves the planning required for developing the product is known as Rapid Application Development Model. It consist main five phases. Business Modeling In here information flow among business functions is defined. That means the complete business analysis is done to understand the business. Business functions are defined by answering questions like what information drives the business process, what information is generated and who generated it, where does the info
Read more
-
Image
We all know operating systems are designed to help us in normal tasks which done by a compute such as Managing files, Loading programs, Printing documents etc. But developers are creating new programs to enhance or extend the operating system’s capabilities. Those are calls utility software. Simply utility programs provide new features which are not supported by an operating system. Now there are thousands of different utility software and we can find them on internet for free or with little price. Although we cannot take a definite list of utility software categories some common types are, Disk and file management programs Internet security Op customization tools Antivirus utilities A virus is a parasitic, scramble files or replicate itself until the host disk is full. Viruses can be transmitted in numerous ways such as while transforming files from one to another, downloading files over the internet or reusing old diskettes etc. So we use antiv
Read more

OOP Concepts

-
Image
today we are going to study about OOP concepts. Object oriented programming language is based on the concept of objects. Object oriented concepts are, Object Class Inheritance Polymorphism Encapsulation object an entity which has state(properties) and behavior is known as an object. it may be anything and may be logical or physical.Object is an instance of a class. ex :- dog,pen,tree,car,mother,...etc. as we told state and behavior let's discuss it with an example class class is a blue print or template of object. Which is a group of objects have similar properties. inheritance when one object acquires all or some properties of another object it is inheritance. That may the child will acquire their parents properties. as an example let's take the supper class as vehicle. A vehicle has colour,brand,speed,auto/manual etc. Car may be a sub class of above supper class. That means car has common properties in vehicle class and there may
Read more