ADO.NET – Over 3 Hours of Premium Video Tutorials

Posted by on Saturday, August 29, 2009 · 4 Comments 

Get 5 Hours of FREE PREMIUM Videos:

LearnVisualStudio.NET Free Preview


LearnVisualStudio.NET Free Preview: Declaring Variables and Assigning Values

“ I am a lifetime member of LearnVisualStudio.net and a Premium Plus member of dotNetVideos.net.

LearnVisualStudio.net is awesome because it grows in value each year as more videos are added.

dotNetVideos.net is also great because it focuses a lot on MS Certifications and practical interview questions.
”

- Wade Harvey (IdealProgrammer.com)

LearnVisualStudio Premium Videos

Visual C# 2010 for Absolute Beginners C# for Absolute Beginners C# for Absolute Beginners Study Guide Visual Basic for Absolute Beginners
Visual Basic Express Edition Study Guide Visual Basic 9.0 Language Enhancements Entity Framework Linq To Sql
Windows Phone 7 Development Unit Testing ASP.NET MVC 3 (In Progress) ASP.NET MVC Hands On Project
ASP.NET For Absolute Beginners Visual Web Developer C# Study Guide Visual Web Developer VB.NET Study Guide ASP.NET Controls Series
ASP.NET AJAX ASP.NET Architecture Series ASP.NET Server Controls Silverlight 4.0
Windows Presentation Foundation Windows Forms Controls Visual Studio 2010 New Features Visual Studio Team System 2008
Visual Studio Team System Features Getting Started With Sql Server Express Edition


dotNetVideos Premium Video Catalog

Interview Questions & Answers Windows AzureASP.NET MVC 4Windows Phone 7 (3 Videos)
Visual Studio 2011 Application Lifecycle ManagementLightSwitchHTML 5SOLID
Visual Studio Add-OnsVisual Studio 2010 ALM Lab ManagementASP.NET 4 Deep Dive Microsoft Enterprise Library 5 with ASP.NET 4 (10 Videos)
Virtualization Techniques for Developer (5 Videos)Test Series - 70-519: Designing and Developing Web Applications Using Microsoft .NET Framework 4 (20+ Videos)Test Series - 70-519: Supplemental
70-513: Test Series (MCTS) Windows Communication Foundation 4 (20+ Videos)70-515:Web Applications Development with Microsoft .NET Framework 4 (20+ Videos)Test Series - 70-516: Accessing Data with Microsoft .NET Framework 4 (20+ Videos)Test Series: 70-432: Microsoft SQL Server 2008, Implementation and Maintenance (20+ Videos)
Test Series: 70-433: SQL Server AdministrationFrom Novice To Professional - C# (25 Videos)From Novice To Professional - VB.NET (25 Videos)


LearnVisualStudio 30% OFF
$140/Lifetime Membership »
Lynda Videos 7 Days Free
$25/Month »
IdealAutomate is a web-based code generator for ASPX Forms
$5/Month or $50/Lifetime Membership »


Premium (Not Free) Video Tutorials

Free Video Tutorials & Free Tools

Here is a collection of over 3 hours of premium video tutorials on ADO.NET by Learn Visual Studio. In order to view the videos, you need to become a member of Learn Visual Studio.

Background: ADO.NET is an outgrowth of ADO () technology. ADO relied on COM objects whereas ADO.NET is based on the .NET Framework. ADO.NET does not replace ADO for the COM programmer; rather, it provides the .NET programmer with access to relational data sources, XML, and application data.

Purpose: ADO.NET is used to access data and data services. The data is usually a relational database, but it does not have to be.

Architecture: ADO.NET is part of the Base Class Library. ADO.NET consists of two parts:

    • Data providers provide access to the data source. The data source can be: SQL Server, Oracle, or OLEDB (ex. Access). Each data source has its own set of provider objects, but they all include these common utility classes:

  • Connection – Provides a connection to the datasoure. It is like a phone line that connects the application to the database.
  • Command – Command is used to perform some action (add, update, delete, select, etc.) on the database.
  • Parameter – This is a variable in the command.
  • DataAdapter – The data adapter provides a bridge between the data source object and the data set object.
  • DataReader – Allows you to access records sequentially, one record at a time.

    • DataSets represent in-memory relational databases. Datasets represent a schema that can contain one or more tables and the relationships between the tables.

    • DataTable represents a single data table that is made up of rows and columns.
    • DataView is an overlay for a datatable that can contain a sort and a filter.
    • DataRelation is a relation between tables.
    • Constraint describes an enforced property of the database.

    A DataSet is populated from a database by a DataAdapter whose Connection and Command properties have been specified. A DataSet can save its contents to XML, or populate itself from XML, making it very useful for web services and distributed computing.

    ADO.NET

    SeriesTitleDatePresenterMin
    ADO.NETSQL Data Connection Object1/1/2003Bob Tabor 12
    ADO.NETSQL Data Command Object1/1/2003Bob Tabor 17
    ADO.NETUsing the Data Command's Parameter Collection1/1/2003Bob Tabor 13
    ADO.NETSql DataReader Object1/1/2003Bob Tabor 10
    ADO.NETSqlDataAdapter1/1/2003Bob Tabor 21
    ADO.NETDataset Concepts1/1/2003Bob Tabor 15
    ADO.NETStrongly Typed Datasets via DataAdapter1/1/2003Bob Tabor 8
    ADO.NETStrongly Typed Datasets via XML Schema Designer1/1/2003Bob Tabor 6
    ADO.NETCreating Untyped Datasets at Runtime1/1/2003Bob Tabor 8
    ADO.NETCreating Untyped Datasets using VS.NET Editors1/1/2003Bob Tabor 9
    ADO.NETUsing Access in ADO.NET1/1/2003Bob Tabor 8
    ADO.NETUnderstanding Concurrency1/1/2003Bob Tabor 14
    ADO.NETOptimistic Concurrency1/1/2003Bob Tabor 11
    ADO.NETA "Home Grown" Pessimistic Concurrency Example1/1/2003Bob Tabor 15
    ADO.NETPessimistic Concurrency Using Transactions1/1/2003Bob Tabor 15
    ADO.NETADO.NET Connection Pooling1/1/2003Bob Tabor 6
    ADO.NETADO.NET DataView1/1/2003Bob Tabor 7
    ADO.NETPersisting a Dataset to XML1/1/2003Bob Tabor 6
    ADO.NETOptimizing DataReader Data Access1/1/2003Bob Tabor 6
    ADO.NETUnderstanding DataRow States and Versions1/1/2003Bob Tabor 8
    ADO.NETDataColumns.Expression1/1/2003Bob Tabor 7
       Total 222

     

    Related posts:

    1. ADO NET Tutorial: (25 Hours) ADO.NET Step By Step Video Tutorial Microsoft's Lindsay Rutter and Glen Gordon present 25 hours of...
    2. .NET Remoting – 10 Premium Video Tutorials Here is a collection of 10 premium video tutorials on...
    3. .NET Framework Threading – 5 Premium Video Tutorials Here is a collection of 5 premium video tutorials on...
    4. ASP.NET MVC Storefront – (20 Hours of FREE Video Tutorials) Here are two tables with links to over 20 hours...
    5. Visual Studio 2010 – (Over 3 Hours of Video Tutorials) Here is a table with links to 10 Visual Studio...

    Related posts brought to you by Yet Another Related Posts Plugin.

    Filed under ASP.NET, C#, Videos, Visual Basic & VB.NET · Tagged with , , , , , ,

    Comments

    4 Responses to “ADO.NET – Over 3 Hours of Premium Video Tutorials”
    1. magnate says:
      September 27, 2009 at 5:06 pm

      hi!

      i am a learner for ASP.net. i want to develop my own asp.net that actually connected with xml (dtd & xsl files). means out put of the asp is xml when we publish the data which actually added in the asp.net application.

      please mail me for the if you want to need the same dtd or xsl file

      thanks in advance.

      Magnate W.

    2. Eliz says:
      October 27, 2010 at 6:53 pm

      Do NOT waste you money with LearnVisualStudio.net. After over 1 1/2 years, Bob has yet to deliver the new videos promised or the new design of his site. Questions posed in the forums go unanswered and the project seems to be all but abandoned. Only the site left up to steal money from those looking to learn, but finding nothing, but empty pockets.

    3. shravan says:
      December 17, 2010 at 2:01 am

      i want free of cost links for laerning

    4. Saurabh says:
      December 17, 2010 at 3:02 am

      please request in forums area.

      We can provide you best quality tutorials for free .

      Also subscribe to newsletter and keep updated

    Speak Your Mind

    Tell us what you're thinking...
    and oh, if you want a pic to show with your comment, go get a gravatar!

    Powered by WP Hashcash

    This blog uses the cross-linker plugin developed by Web-Developers.Net