Mail : training@ecorptrainings.com
India : +91-8143-111-555
USA : +1-703-445-4802
Whats app : +91-8143-110-555
Facebook Twitter Google Plus Pinit Stumbleupon Youtube Blog

Workday HCM Demo New Batches Starting from Tuesday... 01-11-2016
Search Course Here




Live Chat
Support
ADO.NET C# online training

ADO.NET C# 2010

overview

ADO.NET is a group of libraries used to create powerful databases using various sources that include Microsoft SQL Server, Microsoft Access, Oracle, XML, etc. ADO.NET relies on the .NET Framework's various classes to process requests and perform the transition between a database system and the user. The operations are typically handled through the DataSet class.

While ADO.NET is the concept of creating and managing database systems, the DataSet class, as we have introduced it so far, serves as an intermediary between the database engine and the user interface, namely the Windows controls that the user uses to interact with the computer. Still, remember that a DataSet object is used to manage lists, any lists, not just those created using database environments such as Microsoft SQL Server or Microsoft Access.
prerequisties
  • All attendees should have a basic knowledge of SQL and of programming the .NET Framework using C#. Students should also understand the fundamentals of XML and be able to write simple Windows Forms applications. A working knowledge of SQL Server is desirable.
Duration
Online
  • It is a 12 days program and extends up to 2hrs each.
  • The format is 40% theory, 60% Hands-on.

Corporate
  • It is a 3 days program and extends up to 8hrs each.
  • The format is 40% theory, 60% Hands-on.
Classroom
    Private Classroom arranged on request and minimum attendies for batch is 4.
course content
  • Introduction to ADO.NET
    • Microsoft Data Access Technologies
    • From ADO to ADO.NET
    • ADO.NET Architecture
    • Namespaces and Classes
    • Interfaces
    • DataSets and Disconnected Access
    • First ADO.NET Programs
    • Acme Computer Case Study
  • ADO.NET Connections
    • .NET Data Providers
    • IDbConnection
    • Connection Classes
    • Connection Strings
    • Connection Pooling
    • Connection Events
    • Error Handling
  • ADO.NET Commands
    • IDbCommand
    • Command Objects
    • Creating Commands
    • Executing Commands
    • Parameterized Queries
    • Command Types
    • Using Stored Procedures
    • Batch Queries
  • DataReaders and Connected Access
    • DataReaders
    • IDataReader
    • IDataRecord
    • Type-Safe Accessors
    • Null Columns
    • ExecuteReader Options
    • Multiple Result Sets
    • Obtaining Schema Information
  • Data Sets and Disconnected Access
    • DataSet
    • DataAdapter
    • Command Objects
    • DataTable
    • DataColumn
    • DataRow
    • Row States and Versions
    • Accept or Reject Changes
    • DataTable Events
    • Updating a Database from a DataSet
    • Command Builders
  • More About DataSets
    • Filtering DataTables
    • Multiple Table DataSets
    • Schema
    • Constraints
    • Relations
    • Navigating a DataSet
    • DataMapping
    • Creating a DataSet Programmatically
  • XML and ADO.NET
    • Strong Coupling Between ADO.NET and XML
    • Rendering XML from a DataSet
    • Controlling XML Output
    • Reading XML into a DataSet
    • XML Schema and DataSets
    • Typed DataSets
    • Table Adapters
    • Synchronizing DataSets and XML
    • XML Serialization
  • Concurrency and Transactions
    • DataSets and Concurrency
    • Optimistic Concurrency
    • Pessimistic Concurrency
    • Handling Concurrency Violations
    • ADO.NET Transactions
    • Database Transactions
  • Additional Features
    • Asynchronous Database Operations
    • Multiple Active Result Sets
    • Bulk Copy
  • LINQ and Entity Framework
    • Language Integrated Query (LINQ)
    • Bridging Objects and Data
    • Using Object Relational Designer
    • Filtering, Ordering and Aggregation
    • Inserts, Deletes and Updates
    • LINQ to SQL
    • LINQ to DataSet
    • ADO.NET Entity Framework
    • LINQ to Entities
  • Conclusion
Videos
ADO.NET C# 2010 Videos will be updated Soon
To Watch More Videos Click Here

Flash News


AngularJS New Batch Start From 09th OCT & 10th OCT.


Hadoop Dev New Batch Start From 10th OCT & 11th OCT.


IBM COGNOS TM New Batch Start From 11th OCT & 12th OCT.


Informatica Dev New Batch Start From 12th OCT & 13th OCT.


Mean Stack New Batch Start 13th OCT & 14th OCT.

SAP BODS new Batch Starting From 14th OCT & 15th OCT.

SAP S/4 HANA New Batch Start From 15th OCT & 16th OCT
.

Tableau New Batch Start From 16th OCT & 17th OCT

PUBLIC DEMO

(1) Workday Technical Demo Training

Demo Schedule : 09:30A.M EST / 08:30A.M CST / 6:30A.M PST on 13th OCT & 07:00A.M IST on 14th OCT

(2) SAP MII Demo Training

Demo Schedule : 09:30A.M EST / 08:30A.M CST / 6:30A.M PST on 13th OCT & 07:00A.M IST on 14th OCT

SOLVE YOUR QUERIES ONLINE
Email :
Rediff Bol :
ecorptrainings@rediffmail.com
Google Talk :
ecorptrainings@gmail.com
MSN Messenger :
ecorptrainings@hotmail.com
Yahoo Messenger :
ecorptrainings@yahoo.com
Skype Talk :
ecorptrainings