Call: 080-42275527 / +91-9916056387

C# ADO.NET PROGRAMMING

  • The ADO.NET architecture and its components
  • Introduction to ADO.NET Components
  • Connected and disconnected environment
  • NET object model
  • Data sources, providers and connections
  • Commands and data readers
  • Data sets and data adaptors
  • Data tables, rows and columns
  • Constraints and relations
  • Data form wizard
  • Data Sources and .NET Data Providers
  • Data-centric applications
  • Connecting to a data source
  • SQL Server .NET data provider
  • OLE-DB .NET data provider
  • Connections and connection strings
  • SQL-Server integrated security
  • Connection pooling
  • NET exceptions
  • Accessing data in the connected environment
  • Commands
  • Creating and executing commands
  • Reading data using a data reader
  • Batch queries & single result queries
  • Parameterised queries (input & output parameters)
  • Adding, editing and deleting data
  • Stored procedures
  • Disconnected Data
  • Why using a disconnected enviroment?
  • DataSet and DataAdapter features
  • Filling data sets using data adapters
  • Read data using data tables, rows and columns
  • Batch queries and data sets
  • Table and column mappings
  • Visual Studio data tools
  • Editing data in data sets
  • Schema information
  • Adding, modifying and deleting rows
  • Working with null values
  • Merging changes back into the database
  • Rows states and column versions
  • Submitting updates using update, insert and delete commands
  • Using the command builder to generate commands
  • Concurrency
  • Pessimistic concurrency
  • Optimistic concurrency
  • Update strategies: Last in wins, all columns or timestamps
  • Detecting concurrency errors
  • Resolving update conflicts: Merge loose changes, merge keep changes, undo changes and re-insert deleted row
  • Validation and Constraints
  • Column level constraints: Read only, allow null, max length and unique constraints
  • Table level constraints: Foreign keys and unique values
  • Expression based columns
  • Auto increment columns and retrieving generated number
  • Submitting hierachical changes
  • Transactions
  • Connections and transactions
  • Beginning transactions
  • Commit transactions
  • Rollback transactions
  • Transactions with data adrapters and command builders
  • Relational Data
  • Join queries and separate queries
  • Relation data in data sets
  • Data relations
  • Navigating relations
  • Data relations and validations
  • Data relations and expressions
  • Data relations with Visual Studio
  • Sorting, Searching and Filtering
  • Searching in data sets
  • Find on primary keys
  • Searching on any column
  • Searching on row state
  • Wildcard searches
  • Sorting and filtering using data views
  • Searching in a data view
  • Strongly Typed DataSets
  • Advantages of strongly typed data sets
  • Creating strongly typed data sets
  • Creating XML schemas
  • Using strongly typed data sets
  • Adding rows
  • Working with null data
  • Hierarchical data
  • Strongly typed data sets in Visual Studio
  • Itroduction to XML Data
  • Reading and writing XML data to/from a data set
  • Nest relational data
  • Data as attributes or sub elements
  • XML namespaces and prefixes
  • Reading and writing XML schemas
  • XML data documents
  • XSLT transformations
  • Faqs
Scroll Up