ADO Net What is Ado Net Microsoft Active
- Slides: 10
> ADO. Net
What is Ado. Net? • Microsoft Active. X Data Objects • 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 • Data. Reader • Data. Adapter • Data. Set Additional • Transaction • Command. Builder • Connection. String. Builder • Parameter • Exception • Error • Client. Permission
Connect to Database Providers • • • Oracle SQL Open Database Connectivity (ODBC) Object Linking and Embedding Database (OLEDB) Entity. Client 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 connection
Connection Syntax. xxx. File • Import/using System. Data. Sql. Client • • Import/using System. Data. Oracle. Client • • Import/using System. Data. Ole. Db • Import/using System. Data. Odbc Import/using System. Data. Entity. Client Import/using System. Data. Sql. Server. Ce Compile and Run ADO. Net http: //msdn. microsoft. com/enus/library/dw 70 f 090(v=vs. 71). aspx
Helpful Links • w 3 schools • http: //www. w 3 schools. com/ADO/ado_ref_co nnection. asp • Microsoft • http: //msdn. microsoft. com/enus/library/h 43 ks 021(v=vs. 71). aspx • http: //msdn. microsoft. com/enus/library/32 c 5 dh 3 b(v=vs. 71). aspx