ADO.NET for Web Applications Using C# (VS 2012) Training in Petaluma

Enroll in or hire us to teach our ADO.NET for Web Applications Using C# (VS 2012) class in Petaluma, California by calling us @303.377.6176. Like all HSG classes, ADO.NET for Web Applications Using C# (VS 2012) may be offered either onsite or via instructor led virtual training. Consider looking at our public training schedule to see if it is scheduled: Public Training Classes
Provided there are enough attendees, ADO.NET for Web Applications Using C# (VS 2012) may be taught at one of our local training facilities.

Answers to Popular Questions:

 
Yes, this class can be tailored to meet your specific training needs.
Yes, we provide C# consulting services.
Yes, group discounts are provided.

Course Description

 
This three-day intensive course teaches the essential elements of ADO.NET for Web applications such that at the end of the course the programmer is able to utilize its tremendous database manipulation powers to build effective database applications. The course includes a major case study demonstrating the use of ADO.NET in a realistic setting. It is current to .NET4.5, Visual Studio 2012 and SQL Server 2012
Course Length: 3 Days
Course Tuition: $1190 (US)

Prerequisites

A basic knowledge of SQL and of programming the .NET Framework using C#. The student should also understand the fundamentals of XML. To get full benefit from the examples in the course the student should be able to write simple Windows Forms applications. A working knowledge of SQL Server is also desirable.

Course Outline

 

1. Introduction to ADO.NET
Microsoft Data Access Technologies
ODBC
OLE DB
ActiveX Data Objects (ADO)
Accessing SQL Server before ADO.NET
ADO.NET
ADO.NET Architecture
.NET Data Providers
Programming with ADO.NET Interfaces
.NET Namespaces
Connected Data Access
SQL Express LocalDB
SqlLocalDB Utility
Visual Studio Server Explorer
Queries
SQL Server Management Studio
ADO.NET Class Libraries
Connecting to an OLE DB Data Provider
Using Commands
Creating a Command Object
Execute Non Query
Using a Data Reader
Disconnected Datasets
Data Adapters
Buy Computer
Model
Component
Part
PartConfiguration
System
SystemId as Identity Column
SystemDetails
StatusCode
Relationships
Stored Procedure

2. ADO.NET Connections
ADO.NET Block Diagram
.NET Data Providers
Namespaces for .NET Data Providers
Basic Connect (version 1)
Using Interfaces
IDbConnection Properties
Connection String
SQL Server Connection String
OLE DB Connection String
SQL Server Security
IDbConnection Methods
BasicConnect (version 2)
Connection Life Cycle
BasicConnect (version3)
Database Application Front-ends
Connection Pooling
Pool Settings for SQL Server
Connection Events
ADO.NET Exception Handling

3. ADO.NET Commands
Command Objects
Creating Commands
Executing Commands
Dynamic Queries
Parameterized Queries
Command Types
Stored Procedures
Testing the Stored Procedure
Stored Procedures in ADO.NET
Batch Queries
Transactions

4. DataReaders and Connected Access
DataReader
Using a DataReader
Closing a DataReader
IDataRecord
Type-Safe Accessors
GetOrdinal()
Null Data
Testing for Null
ExecuteReader Options
Returning Multiple Result Sets
DataReader Multiple Results Sets
Obtaining Schema Information

5. Data Sets and Disconnected Access
DataSet
DataSet Architecture
Why DataSet?
DataSet Components
DataAdapter
Data Access Class
Retrieving the Data
Filling a DataSet
Accessing a DataSet
Updating a DataSet Scenario
Adding a New Row
Searching and Updating a Row
Deleting a Row
Row Versions
Row State
BeginEdit and CancelEdit
DataTable Events
Updating a Database
Insert Command
Update Command
Delete Command
Exception Handling
Command Builders

6. More About DataSets
Filtering DataSets
Using a Single DataTable
Multiple Tables
DataSet Architecture
Schema in the DataSet
Relations
Navigating a DataSet
Using Parent/Child Relation
Inferring Schema
AddWithKey
Adding a Primary Key
TableMappings
Identity Columns
Creating a Dataset Manually
Manual DataSet Code

7. XML and ADO.NET
ADO.NET and XML
Rendering XML from a DataSet
XmlWriteMode
Reading XML into a DataSet
DataSets and XML Schema
ModelSchema.xsd
Reading XML Schema
XmlReadMode
Writing Data as Attributes
XML Data in DataTables
Typed DataSets
Table Adapter
Using a Typed DataSet
Synchronizing DataSets and XML
Using XmlDataDocument
Windows Client Code
Web Client Code
XML Serialization
Default Constructor

8. Concurrency and Transactions
DataSets and Concurrency
Handling Concurrency Violations
Pessimistic Concurrency
Transactions
Programming ADO.NET Transactions
ADO.NET Transaction Code
Using ADO.NET Transactions
DataBase Transactions
Transaction in Stored Procedure
Testing the Stored Procedure
SQL Server Error

9. Additional Features
AcmePub Database
Connected Database Access
Long Database Operations
Asynchronous Operations
Multiple Active Result Sets
Bulk Copy

10. LINQ and Entity Framework
Language Integrated
Query (LINQ)
LINQ to ADO.NET
Bridging Objects and Data
Object Relational Designer
IntelliSense
Basic LINQ Query Operators
Obtaining a Data Source
Filtering
Ordering
Aggregation
Obtaining Lists and Arrays
Deferred Execution
Modifying a Data Source
Performing Inserts via LINQ to SQL
Performing Deletes via LINQ to SQL
Performing Updates via LINQ to SQL
LINQ to DataSet
Using the Typed DataSet
ADO.NET Entity Framework
Exploring the EDM
AcmePub Tables
AcmePub Entity Data Model
XML Representation of Model
Entity Data Model Concepts
Conceptual Model
Storage Model
Mappings
Querying the EDM
Class Diagram
Context Class
List of Categories
List of Books
Entity Framework in a Class Library
Data Access Class Library
Client Code

11. Appendix A–Acme Computer Case Study

12. Appendix B–SQL Server 2012 Express
SQL Server Express
SQL Server 2012 Express LocalDB
AttachDBFileName
Database
Moving from LocalDB to SQL Server

13. Appendix C –Learning Resources

Course Directory [training on all levels]

Upcoming Classes
Gain insight and ideas from students with different perspectives and experiences.

C# Uses & Stats

C# is Used For:
Windows Applications Business Enterprise Applications Software Development Web Applications
Difficulty
Popularity
Year Created
2000
Pros
In Demand: 
C# along with Java is one of the top languages in demand for employers. 
 
.Net Library:
C# is integrated with the .Net Library thereby providing access to a vast archive of functionality and support. 
 
Team Friendly:
Multiple developers can easily work together on a project. 
 
Compiled Language:
The code that is stored on a public-facing server is in binary form. In other words, if your server gets hacked, the hacker doesn't automatically have access to your source code. 
 
Transferable:
C# roots are derived from C which means that the structure is transferable to other languages like Java, Objective C, PHP and C++. 
Cons

Steep Learning Curve:
For beginners, C# is not the easiest program to start with. 

Windows Application Exclusively:
Any .NET application needs a Windows platform to execute which means that companies using Linux servers would need Windows hosting to run a .Net application. 
 
Lack of Support for Older .NET:
Many enterprise organizations keep older operating systems because of the many problems that an upgrade can bring to the platform. Microsoft stops supporting older .NET frameworks after a few operating systems upgrades. 
C# Job Market
Average Salary
102000
Job Count
32916
Top Job Locations

New York City 
Mountain View
San Francisco 

Complimentary Skills to have along with C#

Since the .NET development ecosystem spans a wide array of capabilities and tools, it is difficult for .NET developers to know which .NET development skills and training to pursue in order to increase their marketability — and earning potential.  For that reason, learning supplemental languages such as Java, JavaScript, Python, C/C++, and others is expected in today’s competitive skill-set driven playing field.

Interesting Reads Take a class with us and receive a book of your choosing for 50% off MSRP.