Ado.Net - UTPA Faculty Web

abashedwhimsicalSoftware and s/w Development

Nov 2, 2013 (3 years and 9 months ago)

108 views

ADO.Net

>

What is Ado.Net?


Microsoft
A
ctiveX
D
ata
O
bjects


Programming interface to access data in a database and
update, manipulate or retrieve information


Automatically installed as Part of Microsoft .NET Framework


Simply
-
Set
of Classes or
Frameworks


Library for accessing Databases



How Do To Get ADO.Net


Part of .Net framework provided by Microsoft


Part of Visual Basic

Types of .Net Apps


Can connect to a database using ADO.NET to execute, run,
retrieve and modify information:


ASP.NET Web Application


Windows Application


Console Application

Goal



Leverage


Integrated XML support


Program


Create Tables


Build Applications

What Makes Up .Net

Core


Connection


Command


DataReader


DataAdapter


DataSet

Additional


Transaction


CommandBuilder


ConnectionStringBuilder


Parameter


Exception


Error


ClientPermission

Connect to Database Providers


Oracle


SQL


Open Database Connectivity (ODBC)


Object Linking and Embedding Database (OLEDB)


EntityClient Provider


SQL Server Compact 4.0

How to Connect to a Database


Create

an ADO connection to a database


Open

the database connection


Create

an ADO
dataset


Open

the
dataset


Extract
the data you need from the
dataset


Close

the
dataset


Close

the connection

Connection

Syntax

.xxxFile


Import/using

System.Data.SqlClient


Import/using

System.Data.OracleClient


Import/using

System.Data.OleDb

Compile and Run ADO.Net

http://msdn.microsoft.com/en
-
us/library/dw70f090(v=vs.71).aspx




Import/using

System.Data.Odbc


Import/using

System.Data.EntityClient


Import/using

System.Data.SqlServerCe

Helpful Links


w
3
s
chools


http
://
www.w3schools.com/ADO/ado_ref_co
nnection.asp


Microsoft


http://msdn.microsoft.com/en
-
us/library/h43ks021(v=vs.71).
aspx


http://msdn.microsoft.com/en
-
us/library/32c5dh3b(v=vs.71).aspx