Databases and ADO.NET

Databases and ADO.NET

Most of the applications today uses some kind of data storage. Perhaps the sole applications I can imagine that doesn’t use some quite storage for its data are those small and really simple applications. An application can have many sorts of data sources like an easy document , an XML file, and a database. Databases are typically used when storing different kinds of data such as the name, address, age, gender, and occupation of a person, musics, pictures, and many more. A database may be a collection of various sorts of data structured into tables consisting of fields and records. Most real world applications today uses databases to store information.

Relational databases contain data which are organized and linked to each other. Relational databases contains one or more tables interconnected to each other. Tables consists of rows and columns. In a database, the rows represents each record. For example, on a database containing records of employee, one row represents a record of an employee. The columns represents the fields or attributes. For example, an Employee has a First Name field, a Last Name field, and an Age field. You can also create relations between multiple tables. For example, an Employee table could have a field called City_ID. Then another table called Cities contains fields City_ID and therefore the CityName. You can connect these two tables to make a relation.

Structured command language (SQL) is that the hottest and maybe the quality way of communicating to a database. It has commands you'll use for retrieving, updating, adding, and deleting data from the database. It also allows you to create and modify databases and tables and create relationships between different tables.