its library is a rich framework that retrieves and updates information in various relational databases, which include Microsoft SQL Server, Microsoft Access, Oracle, and XML.

ADO.NET

It is used for connecting in the database, recovering results, updating data, and executing commands.

Data Provider

Which statement is NOT TRUE about Data Provider?

It characterizes a local copy of related data tables.

DataSet

Which statement is NOT TRUE about DataSet

It manages the data for any entity. It contains zero or more rows of data, and each value shown in the data table is identified by the DataColumn.

It manages the data for any entity.

DataTable

Which statement is NOT TRUE about a DataTable?

It includes a data type declaration based on the kind of data saved.

DataColumn

It is used to link two (2) DataTable classes inside the DataSet class.

DataRelation

It is used to map a table name from the database to a DataTable within a DataSet.

DataColumnMapping

It is used to customize the view of the table or desired view of the rows in a DataTable.

DataView

It can run SQL commands and perform a stored procedure—accessing and manipulating data. Data management statements and SQL queries are wrapped in the Command object.

Command

From the data source, it allows users to connect and disconnect. Communications with the external data sources happen through the Connection object.

Connection

It transfers DataSets between the data source and the caller. It also acts as a connection between the data source and DataSet, where DataAdapters contain a connection and set of Command objects that help in fetching and updating data.

DataAdapters

ADO.NET contains classes for connecting or using an SQL command. It requires to add what namespace?

System.Data.SqlClient

Used as wrappers for SQL statements or stored procedure calls

SqlCommand, OleDbCommand, and ODBCCommand

Generate SQL commands for updating database tables Automatically generate SQL commands from a SELECT statement

SqlCommandBuilder, OleDbCommandBuilder, and ODBCCommandBuilder

Used to connect to the database

SqlConnection, OleDbConnection, and ODBCConnection

Handle interaction between DataSet and data source Help in executing different SQL commands to populate a DataSet and update the data source

SqlDataAdapter, OleDbDataAdapter, and ODBCDataAdapter

Used as a forward-only, read-only access to data using a cursor

SqlDataReader, OleDbDataReader, and ODBCDataReader

Define a parameter to a stored procedure

SqlParameter, OleDbParameter, and ODBCParameter

Represent transactions to be made in data source

SqlTransaction, OleDbTransaction, and ODBCTransaction

It includes all generic data access classes.

System.Data

It includes classes that are shared or overridden by individual data providers.

System.Data.Common

It includes Entity Framework classes.

System.Data.EntityClient

It includes LINQ to SQL provider classes.

System.Data.Linq.SqlClient

It includes ODVC provider classes.

System.Data.Odbc

It includes OLE DB provider classes.

System.Data.OleDb

It includes new base classes and connection factory classes.

System.Data.ProviderBase

It includes new generic interfaces and classes for SQL Server data access.

System.Data.Sql

It includes SQL Server provider classes.

System.Data.SqlClient

It includes SQL Server data types.

System.Data.SqlTypes

It is a server management console that is used for logging in to servers, opening data connections, and accessing databases

Server Explorer

It contains all the connections to the server and local databases. this node displays the list of tables, view, stored procedures, and functions. It can also be used to connect to a SQL Server Database.

Data Connections

It is used to design, connect to the available database, browse the schema, and create a query on its object

SQL Server Object Explorer

what is correct syntax for creating a database?

CREATE DATABASE db_name;

what is correct syntax for removing a database?

DROP DATABASE db_name;

what is correct syntax for creating a database table?

CREATE TABLE table_name ( column1 datatype, column2 datatype, column3 datatype,…);

What is the correct syntax for dropping a database table?

DROP TABLE table_name;

This class is used to open a connection using the Open() method. The connection can be closed by calling the Close() method.

SqlConnection

a property that is used to read or assign the connection string to be used by the SqlConnection class

ConnectionString

a read-only property that returns the name of the SQL Server instance

DataSource

a read-only property that returns the name of the database

Database

a read-only property that returns the current state of the connection.

State

Which is the correct syntax to establish a connection, specify the computer name to which you want to connect?

SqlConnection conn = new SqlConnection("Server=computer_name;")

This class is used to perform desired processing on the database. It allows executing any direct T-SQL or stored procedure on the server.

SqlCommand

In SqlCommand, This method executes the command but does not return output.

ExecuteNonQuery

In SqlCommand, This method executes the command and returns a DataReader object based on the SQL statement.

ExecuteReader

In SqlCommand, This object is forward-only and read-only cursor that can be iterated through to fetch the rows in it.

SqlDataReader

In SqlCommand, It executes the command and returns the SqlRecord object that contains a single returned row.

ExecuteRow

In SqlCommand, It executes the command and returns the first column of the first row in the result set

ExecuteScalar

in SqlCommand Properties, It gets or sets the SqlConnection class that can be used by the Command object.

Connection

in SqlCommand Properties, It gets or sets the stored procedure or the T-SQL statement.

CommandText

in SqlCommand Properties, It indicates the way the CommandText property should be interpreted.

CommandType

Which is the correct syntax for query for selecting all the data of the table?

SELECT * FROM table_name;

Which is the correct query for selecting specific columns of the table?

SELECT column1, column2, column3,… FROM table_name;

It refers to a collection of parameters that is connected with SqlCommand.

SqlParameterCollection

In SqlParameterCollection, Which method adds the specified SqlParameter object to the SqlParameterCollection and contains two (2) arguments: string paramaterName and SqlDbType.

Add()

In SqlParameterCollection, Which method adds a value to the end of the SqlParameterCollection and contains two (2) arguments, a string parameterName and an object, that includes the value of that parameter.

AddWithValue()

Which is the correct syntax for SqlParameterCollection.Add()?

public SqlParameter Add(string paramterName, SqlDbtype sqlDbType);

Which is the correct syntax for SqlParameterCollection.AddWithValue()?

public SqlParameter AddWithValue(string parameterName, object value);

Which is the correct syntax for query for inserting data for all the columns of the table?

INSERT INTO table_name VALUES(value1, value2, value3,… );

Which is the correct syntax for query for inserting data for specified column names?

INSERT INTO table_name (column1, column2, column3, … ) VALUES(value1, value2, value3, … );

It is used to modify or update an existing record. - It uses the WHERE clause to determine the number of records that will be updated.

SQL UPDATE

What is the correct syntax for Query for updating data?

UPDATE table_name SET column1 = value1, column2 = value2, column3 = value3 WHERE condition;