07 Event Driven FInals

ADO

stands for "Active Data Objects"

ADO.NET

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 relies on the .NET Framework's various classes to process requests and transition between a database system and the user

Data Provider

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

DataSet

It characterizes a local copy of related data tables

DataTable

It manages the data for any entity

DataColumn

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

DataRelation

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

DataColumnMapping

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

DataView

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

Command

It can run SQL commands and perform a stored procedure—accessing and manipulating data

Connection

From the data source, it allows users to connect and disconnect

DataAdapters

It transfers DataSets between the data source and the caller

DataReaders

It is a read-only access to data using a server-side cursor

System.Data

It includes all generic data access classes

System.Data.Common

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

System.Data.EntityClient

It includes Entity Framework classes

System.Data.Linq.SqlClient

It includes LINQ to SQL provider classes

System.Data.Odbc

It includes ODVC provider classes

System.Data.OleDb

It includes OLE DB provider classes

System.Data.ProviderBase

It includes new base classes and connection factory classes

System.Data.Sql

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

System.Data.SqlClient

It includes SQL Server provider classes

System.Data.SqlTypes

It includes SQL Server data types

Server Explorer

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

Data Connections

It contains all the connections to the server and local databases

SQL Server Object Explorer

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

Step 1

What step is this in accessing data from the database? Create a connection to the specified server

Step 2

What step is this in accessing data from the database? Open a connection using the SqlConnection object

Step 3

What step is this in accessing data from the database? Create a command using the SqlCommand object

Step 4

What step is this in accessing data from the database? Use and create a DataReader or DataAdapter object

Step 5

What step is this in accessing data from the database? Call the Close() method to close the connection and release the resources

SqlConnection

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

ConnectionString

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

DataSource

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

Database

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

State

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

Server

To establish a connection, specify the computer name to which you want to connect.

Database / Initial Catalog

The attribute is used to specify the database to access the specified server

Trusted_Connection / Integrated Security

This attribute implements the secure connection with the database

Username

To specify the username used in a connection after assigning false or no to the Integrated Security attribute, use the User ID attribute and assign a valid username to it

Password/Pwd

When establishing a secure connection to a database, in addition to a valid username, this is needed

SqlCommand

This class is used to perform desired processing on the database

ExecuteNonQuery

This method executes the command but does not return output

ExecuteReader

This method executes the command and returns a DataReader object based on the SQL statement

SqlDataReader

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

ExecuteRow

It executes the command and returns the SqlRecord object that contains a single returned row

ExecuteScalar

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

Connection

It gets or sets the SqlConnection class that can be used by the Command object

CommandText

It gets or sets the stored procedure or the T-SQL statement

CommandType

It indicates the way the CommandText property should be interpreted

SqlParameterCollection

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

Add()

It adds the specified SqlParameter object to the SqlParameterCollection and contains two (2) arguments: string paramaterName and SqlDbType

AddWithValue()

It adds a value to the end of the SqlParameterCollection and contains two (2) arguments: string parameterName and an object, that includes the value of that paremeter.

SqlDbType

It specifies the SQL Server data type of a field and property

SQL UPDATE

it is used to modify or update an existing record