ADO.NET Database Programming (C# or VB.NET)
|Meets:||On Demand - 5 days or two 3 day classes|
There are still openings remaining at this time.
Online registration is not available at this time. Please contact our office for more information.
Support Person: SummaSource at Auburn Montgomery Phone: 334-244-3080 Email: firstname.lastname@example.org
Section 1: Introduction to ADO.NET programming
This section explains the background concepts and skills that you need for database programming with ADO.NET. If you’re new to database programming, this section is essential to getting started right.
Section 2: How to use data sources and datasets for RAD
This section shows you how to use data sources and datasets for prototyping and Rapid Application Development (RAD). These are the skills that will help you quickly develop working versions of database applications so they can be reviewed and enhanced.
Section 3: Three-layer Windows applications
This section shows you how to develop 3-layer applications that use presentation, business, and database classes. This is the approach that many professionals use because it applies a logical structure to database applications. You’ll also learn how to use object data sources in this section, because they can make this approach to application development even more effective.
Section 4: ADO.NET for web applications
Here, you’ll learn how to use ASP.NET data controls to develop web applications. That includes controls for both SQL and object data sources as well as controls that present data, like the GridView and DetailsView controls. These controls help you develop database-driven web applications faster and better than ever. And object data sources give you complete control over how the database processing is done.
Section 5: Advanced database programming skills
Last, you’ll learn advanced skills that every ADO.NET programmer should be aware of. These include how to work with XML, how to use the Report Designer to create reports, how to use the ReportViewer control to display reports in both Windows and web applications, how and why to use LINQ instead of SQL to query a database, and how to use the Entity Framework in combination with LINQ so you can work with objects and let the framework handle the database operations.
Who Should Attend?
This course assumes that you have basic Visual Studio and C# or VB.NET skills, the kind you should get from any core .NET programming course. If you don’t have all the core skills for developing real-world applications, we recommend you attend our C# or VB.NET programming course.