WorksheetsEvent-Driven FINALS
Total questions: 45
Worksheet time: 45mins
Stands for “Active Data Objects”
Is a rich framework that retrieves and updates information in various relational databases (Microsoft SQL Server, Microsoft Access, Oracle, and XML)
used for connecting in the database, recovering results, updating data, and executing commands
It gives data access on Microsoft SQL Server
System.Data.SqlClient
It is used for connecting OLE DB data source
System.Data.OleDb
- It characterizes a local copy of related data tables
- is composed of one or more DataTable objects that are manipulated and updated as per the requirements of the users or client
-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
-consists of primary key, foreign key, constraint, and relation information of different tables
DataTable
DataColumn
DataRelation
DataColumnMapping
It includes a data type declaration based on the kind of data saved
DataTable
DataColumn
DataRelation
DataColumnMapping
It is used to link two (2) DataTable classes inside the DataSet class
DataTable
DataColumn
DataRelation
DataColumnMapping
It is used to map a table name from the database to a DataTable within a DataSet
DataTable
DataView
DataRelation
DataColumnMapping
It is used to customize the view of the table or desired view of the rows in a DataTable
DataTable
DataView
DataRelation
DataColumnMapping
can run SQL commands and perform a stored procedure—accessing and manipulating data
Command
Connection
DataAdapters
DataReaders
From the data source, it allows users to connect and disconnect.
Communications with the external data sources happen through the Connection object
Command
Connection
DataAdapters
DataReaders
It transfers DataSets between the data source and the caller
It also acts as a connection between the data source and DataSet
Command
Connection
DataAdapters
DataReaders
- It is a read-only access to data using a server-side cursor
The DataReader object is gained by invoking the ExecuteReader method of the Command object
It requires closing the connection when using the DataReader object
Command
Connection
DataAdapters
DataReaders
It includes all generic data access classes
It includes classes that are shared or overridden by individual data providers
It includes Entity Framework classes
It includes LINQ to SQL provider classes
It includes ODVC provider classes
It includes OLE DB provider classes
It includes new base classes and connection factory classes
It includes new generic interfaces and classes for SQL Server data access
It includes SQL Server provider classes
It includes SQL Server data types
is a server management console that is used for logging in to servers, opening data connections, and accessing databases
Server Explorer
Data Connections
SQL Server Object Explorer
SqlConnection
-contains all the connections to the server and local databases
-data connection node displays the list of tables, view, stored procedures, and functions
-can also be used to connect to a SQL Server Database
Server Explorer
Data Connections
SQL Server Object Explorer
SqlConnection
It is used to design, connect to the available database, browse the schema, and create a query on its object
Server Explorer
Data Connections
SQL Server Object Explorer
SqlConnection
This class is used to open a connection using the Open() method. The connection can be closed by calling the Close() method
Server Explorer
Data Connections
SQL Server Object Explorer
SqlConnection
a property that is used to read or assign the connection string to be used by the SqlConnection class
ConnectionString
DataSource
Database
State
a read-only property that returns the name of the database
ConnectionString
DataSource
Database
State
a read-only property that returns the name of the SQL Server instance
ConnectionString
DataSource
Database
State
a read-only property that returns the current state of the connection
ConnectionString
DataSource
Database
State
- 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
ExecuteNonQuery
ExecuteReader
SqlDataReader
This method executes the command but does not return output
SqlCommand
ExecuteNonQuery
ExecuteReader
SqlDataReader
This method executes the command and returns a DataReader object based on the SQL statement
SqlCommand
ExecuteNonQuery
ExecuteReader
SqlDataReader
This object is forward-only and read-only cursor that can be iterated through to fetch the rows in it
SqlCommand
ExecuteNonQuery
ExecuteReader
SqlDataReader
It executes the command and returns the SqlRecord object that contains a single returned row
ExecuteRow
ExecuteScalar
Connection
CommandText
It executes the command and returns the first column of the first row in the result set
ExecuteRow
ExecuteScalar
Connection
CommandText
It gets or sets the SqlConnection class that can be used by the Command object
ExecuteRow
ExecuteScalar
Connection
CommandText
it gets or sets the stored procedure or the T-SQL statement
ExecuteRow
ExecuteScalar
Connection
CommandText
It indicates the way the CommandText property should be interpreted
CommandType
SqlParameterCollection
Add()
AddWithValue()
It refers to a collection of parameters that is connected with SqlCommand
CommandType
SqlParameterCollection
Add()
AddWithValue()
adds the specified SqlParameter object to the SqlParameterCollection and contains two arguments: string paramaterName and SqlDbType
CommandType
SqlParameterCollection
Add()
AddWithValue()
It adds a value to the end of the SqlParameterCollection
It contains two (2) arguments, a string parameterName and an object, that includes the value of that parameter
SQL UPDATE
SqlParameterCollection
Add()
AddWithValue()
- 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
SqlParameterCollection
Add()
AddWithValue()
