Microsoft Visual Studio 2010: Developing Data Access Solutions With
Microsoft Visual Studio 2010 (.NET Framework 4 Data Access )

Product Description

After completing this course, students will be able to: Evaluate business cases & select an appropriate combination of data access technologies & tools for each case. Use the tools that the Entity Framework provides to map the conceptual model that the business logic of an application uses to the logical data model that the database provides. Query an Entity Data Model (EDM) by using common methods such as LINQ to Entities, Entity SQL, & the classes in the Entity Client namespace. Perform data modification tasks through an EDM by using LINQ to Entities, Entity SQL, & the classes in the Entity C Iient namespace.

Describe the optimistic concurrency model in the Entity Framework & manage transactions in Entity Framework applications. Describe the best practices for designing & building a scalable, optimized data access layer by using Object Services. Customize & extend entities with their own business logic & use advanced mappings to shape the data model to their business & application requirements. Reuse existing plain-old CLR object (P0CC) business classes in a data access layer that is built by using the Entity Framework. Address the architectural issues that can arise when you build an n-tier enterprise application by using the Entity Framework. Build extensible solutions that can update data in an n-tier enterprise application by using the Entity Framework.

Access offline data or data that has limited availability in client applications. Design, develop, & consume a simple data service. Use WCF Data Services to update & delete data & handle multi-user concerns. Develop high-performance, scalable ADO.NET applications that can query & update data. Use LINQ to SQL to develop against a logical model that abstracts the low- level details of querying ADO.NET tables & result sets.

This training may be available onsite; please contact us if you are interested.