Pada modul ini peserta akan mempelajari teknik pemrogramman akses dan manipulasi data dengan menggunakan class library yang telah disediakan didalam .net framework. Sumber data yang digunakan berupa database, flat files, binary file dan xml file.
Teknik akses dan manipulasi data yang dipelajari meliputi ADO.NET, LINQ dan Entity Framework. Dengan menguasai materi ini diharapkan peserta dapat membuat aplikasi yang berbasiskan akses dan manipulasi data dari berbagai macam sumber data yang beragam.
Durasi : 5 hari
1. Introduction to ADO.NET
- Understanding ADO.NET
- Moving from ADO to ADO.NET
- ADO.NET and the .NET Base Class Library
- Understanding ADO.NET Architecture
- SQL Server Data Provider
- OLE DB Data Provider
- ODBC Data Provider
2. Connection Object
- Introducing the Data Provider Connection Classes
- Connecting to SQL Server
- Debugging Connections to SQL Server
- Connection Pooling
- Improving Your Use of Connection Objects
- Connecting to SQL Server with OleDbConnection
3. Command Object
- Creating a Command
- Executing Commands
- Executing Commands with Multiple Results
- Executing Statements
- Command Parameters
4. DataReader Object
- Understanding Data Readers
- Using Ordinal Indexers
- Using Column Name Indexers
- Using Typed Accessor Methods
- Using Multiple Result Sets with a Data Reader
5. DataSet and DataAdapter
- Understanding the Object Model
- Datasets vs Data Readers
- Working with Datasets and Data Adapters
- Filtering and Sorting in a Dataset
- Using Data Views
- Modifying Data in a Dataset
- Propagating Changes to a Data Source
- Command Builders
- Concurrency
- Using Datasets and XML
- Understanding Typed and Untyped Datasets
6. Handling Exceptions
- Handling ADO.NET Exceptions
- Handling Database Exceptions
7. Working with Text and Binary Data
- Understanding SQL Server Text and Binary Data Types
- Storing Images in a Database
- Retrieving Images from a Database
- Working with Text Data
8. Introduction to LINQ
- Architecture of LINQ
- LINQ Project Structure
- Using LINQ to Objects
- Using LINQ to SQL
- Using LINQ to XML
9. Using ADO.NET 3.5
- Understanding ADO.NET 3.5 Entity Framework
- Understanding the Entity Data Model
- Working with the Entity Data Model