The course will provide a fundamental understanding of the ADO environment, a knowledge of the set of interacting objects, and the knowledge necessary to build data applications. Suitable for: This course is intended for developers and others who need to use ADO.NET in building applications. The class is delivered at version 2005 or 2008 depending on the delegates needs.
Facilities
Location
Start date
Bath
(Somerset)
See map
11 Kingsmead Square, BA1 2AB
Start date
On request
About this course
Those attending should have a basic understanding of the .NET Framework and Microsoft Visual Studio and be competent in Microsoft VB.net. A basic understanding of relational databases and how they are structured and some knowledge of SQL syntax will be an advantage.
Questions & Answers
Add your question
Our advisors and other users will be able to reply to you
We are verifying your question adjusts to our publishing rules. According to your answers, we noticed you might not be elegible to enroll into this course, possibly because of: qualification requirements, location or others. It is important you consult this with the Centre.
Thank you!
We are reviewing your question. We will publish it shortly.
Or do you prefer the center to contact you?
Reviews
Have you taken this course? Share your opinion
Course programme
SUMMARY: This class is also available with C#.net - please ask for details.
AUDIENCE: This course is intended for developers and others who need to use ADO.NET in building applications.
PREREQUISITES: Those attending should have a basic understanding of the .NET Framework and Microsoft Visual Studio and be competent in Microsoft VB.net. (Or C#.net if required.) A basic understanding of relational databases and how they are structured and some knowledge of SQL syntax will be an advantage.
DURATION: 3 days. Hands on.
OBJECTIVES: Delegates will:
- Get a basic introduction to databases, SQL, and ADO.NET
- Quickly be prototyping database applications using Rapid Application Development (RAD) tools like data sources.
- Learn how to build 3-layer applications the ways the pros do, with presentation, business, and database classes. This is where you'll get into ADO.NET coding to create your own database classes.
- Look at LINQ (Language-Integrated Query), a .NET 3.5 feature that lets you handle all types of data using a query language that's integrated into Visual Basic and that saves you a lot of ADO.NET coding. That means you'll learn how to:
Use LINQ to DataSet to query the data in typed or untyped datasets.
Use LINQ to SQL, which allows you to generate an object model from the objects in a SQL Server database that can then be used to access and update the database data...a feature that offers you some of the same benefits as the Entity Framework.
- Use LINQ to XML to manipulate XML data much more easily than you can using the Document Object Model.
- Use LINQ data source controls with web applications.
- Learn to work with the ADO.NET Entity Framework...another way to let .NET generate the code you need and do more of the work for you. Using this feature, you create an Entity Data Model that defines a conceptual model for the business objects used by an application, a storage model for the objects in a database, and mappings that relate the two. Then:
You can use LINQ or a special form of SQL to retrieve data into the business objects. You can work with the business objects and save changes to the database using generated code. You can use Entity data source controls with web applications.
COURSE CONTENT: An introduction to ADO.NET programming
An introduction to database programming
An introduction to ADO.NET 3.5
How to use data sources and datasets for Rapid Application Development
How to work with data sources and datasets
How to work with bound controls and parameterized queries
How to use the Dataset Designer
Three-layer Windows Forms applications
How to work with connections, commands, and data readers
How to work with parameters and stored procedures
How to work with transactions
How to work with object data sources
A complete Payable Entry application
How to use LINQ
An introduction to LINQ
How to use LINQ to DataSet
How to use LINQ to SQL
How to use LINQ data source controls with web applications
How to use LINQ to XML
How to use the Entity Framework
How to create an Entity Data Model
How to use LINQ to Entities
How to use Entity SQL
How to use Entity data source controls with web applications