MOC 10265 MS Visual Studio 2010 - Developing Data AccessVecomp Software - PCSNET Nordest
- Villafranca di verona
- 35 ore di lezione
Domande più frequenti
La comprensione delle tecniche di problem-solving che si applicano allo sviluppo di software Una conoscenza di base delle tecniche di scripting e qualche esperienza pratica nella loro scrittura Una conoscenza generale della funzione scope, e le caratteristiche NET Framework Esperienza nell'utilizzo di Visual Studio 2008 Esperienza nella progettazione e sviluppo object oriented Esperienza nella progettazione e sviluppo di applicazioni N-Tier Esperienza di accesso ai dati in applicazioni Windows
Cosa impari in questo corso?
Developing Data Access
Visual Studio 2010
Module 1: Architecture and Data Access TechnologiesData Access TechnologiesData Access ScenariosLab : Analyzing Data Access ScenariosIdentifying Data Access TechnologiesDescribe the key data access technologies available to .NET Framework developers.Assign appropriate data access technologies to common data access scenarios.Module 2: Building Entity Data ModelsIntroduction to Entity Data ModelsModifying the Entity Data ModelCustomizing the Entity Data ModelLab : Using Entity Data ModelsGenerating an EDM from the AdventureWorks DatabaseAdding Entities and AssociationsUsing the Generate Database WizardMapping Entities to Multiple TablesImplementing an Inheritance HierarchyUsing Stored ProceduresCreating a Complex TypeDescribe and create an Entity Data Model.Modify an Entity Data Model by using the Entity Designer.Customize a model to meet their business requirements.Module 3: Querying Entity DataRetrieving Data by Using LINQ to EntitiesRetrieving Data by Using Entity SQLRetrieving Data by Using EntityClient ProviderRetrieving Data by Using Stored ProceduresUnit Testing YourÂ Data Access CodeLab : Querying Entity DataRetrieving All Contact EntitiesRetrieving Contact Entities by Using a FilterRetrieving RewardsClaimed EntitiesQuerying the Rewards Family of EntitiesExecuting a Stored ProcedureRetrieve data by using LINQ to Entities.Retrieve data by using the Entity SQL language.Retrieve data by using the EntityClient Provider.Retrieve data by using stored procedures in the entity model.Create unit tests for their data access code.Module 4: Creating, Updating, and Deleting Entity DataUnderstanding Change Tracking in the Entity FrameworkModifying Data in an Entity Data ModelLab : Creating, Updating, and Deleting Entity DataMaintaining Contact and Reward DataMaintaining RewardsClaim DataDescribe how the Entity Framework implements change tracking.Describe how to modify data in the entity model, and persist the changes to the database.Module 5: Handling Multi-User Scenarios by Using Object ServicesHandling Concurrency in the Entity FrameworkTransactional Support in the Entity FrameworkLab : Handling Multi-User Scenarios by Using Object ServicesHandling Concurrency of Rewards Claimed DataUpdating the RewardsClaimed and ArchivedRewardsClaimed Information by Using a TransactionDescribe the optimistic concurrency model that the Entity Framework uses.Manage transactions in applications that use the Entity Framework.Module 6: Building Optimized Solutions by Using Object ServicesThe Stages of Query ExecutionChange Tracking and Object MaterializationUsing Compiled QueriesUsing Design-Time Generated Entity Framework ViewsMonitoring PerformancePerforming Asynchronous Data ModificationsLab : Building Optimized Solutions by Using Object ServicesImproving the Performance of Query OperationsImproving the Performance of Update OperationsExplain how the Entity Framework executes queries.Understand the impact of tracking and object materialization on query performance.Describe how to use compiled queries.Describe how to use design-time generated views.Describe how to monitor query performance.Describe how to perform asynchronous data modifications.Module 7: Customizing Entities and Building Custom Entity ClassesOverriding Generated ClassesUsing Templates to Customize EntitiesCreating and Using Custom Entity ClassesLab : Customizing Entities and Building Custom Entity ClassesUsing a Template to Add Custom Functionality to Entity ClassesCreating Custom Entity ClassesUse partial classes and methods to add business logic to generated code.Create and use templates to customize code generation.Modify existing business classes to take advantage of entity functionality.Module 8: Using POCO Classes with the Entity FrameworkRequirements for POCO ClassesPOCO Classes and Lazy LoadingPOCO Classes and Change TrackingExtending Entity TypesLab : Using POCO Classes with the Entity FrameworkUsing POCO ClassesExtending Your POCO ClassesList the requirements that their POCO classes must meet.Create POCO entities that support automatic lazy loading.Create POCO entities that support automatic change tracking.Describe the options for using interfaces and inheritance to create custom entity objects.Module 9: Building an N-Tier Solution by Using the Entity FrameworkDesigning an N-Tier SolutionDefining Operations and Implementing Data Transport StructuresProtecting Data and OperationsLab : Building an N-Tier Solution by Using the Entity FrameworkCreating the Contacts and Orders Data Access TierProtecting Data Access OperationsDescribe the issues and strategies that are relevant to building n-tier applications.Understand the key components that they must create in order to implement an n-tier application.Describe how to protect operations and data in an n-tier application.Module 10: Handling Updates in an N-Tier Solution by Using the Entity FrameworkTracking Entities and Persisting ChangesManaging Exceptions in an N-Tier SolutionLab : Handling Updates in an N-Tier Solution by Using the Entity FrameworkHandling Updates in the Data Access TierDetecting and Handling Order ConflictsDescribe strategies that they can adopt for tracking changes in the client application, and persisting those changes in the database.Describe how to trap and handle update and concurrency exceptions in the an n-tier solution.Module 11: Building Occasionally Connected SolutionsOffline Data Caching by Using XMLUsing the Sync FrameworkLab : Building Occasionally Connected SolutionsModifying the Orders Application to Use Offline XML DataModifying the Orders Application to Synchronize Locally Cached DataCache data in local XML files by using LINQ to XML.Implement an occasionally connected application by using the Microsoft Sync Framework.Module 12: Querying Data by Using WCF Data ServicesIntroduction toÂ WCF Data ServicesCreating a WCF Data ServiceConsuming a WCF Data ServiceProtecting Data and Operations in a WCF Data ServiceLab : Creating and Using WCF Data ServicesExposing Order Data as a WCF Data ServiceConsuming a WCF Data ServiceRestricting Access to Data Exposed by a WCF Data ServiceImplementing a Business Operation in a WCF Data ServiceDescribe the purpose and features of WCF Data Services.Expose data by using a WCF Data Service.Implement a client application that can consume a WCF Data Service.Grant and restrict access to resources exposed by a WCF Data Service.Module 13: Updating Data by Using WCF Data ServicesCreating, Updating, and Deleting Data in a WCF Data ServicePreventing Unauthorized Updates and Improving PerformanceUsing WCF Data Services with Nonrelational DataLab : Updating Data by Using WCF Data ServicesUpdating Entities by Using a WCF Data ServiceCreating and Deleting Entities by Using a WCF Data ServiceRestricting Create, Update, and Delete RequestsCreate, update, and delete entities by using a WCF Data Service.Control access to data modification functionality, and improve performance by batching commands together.Use WCF Data Services to access and modify nonrelational data.Module 14: Using ADO.NETRetrieving and Modifying Data by Using ADO.NET CommandsRetrieving and Modifying Data by Using DataSetsManaging Transactions and Concurrency in Multiuser ScenariosLab : Using ADO.NETUsing ADO.NET to Retrieve Read-Only Information Quickly and Perform Simple Data ModificationsDeveloping the Product List Web ApplicationEnabling Data ModificationsRetrieve and update dataÂ by using ADO.NET commands and stored procedures.Retrieve and update dataÂ by using DataSet objects.Implement transactions andhandle concurrency exceptions.Module 15: Using LINQ to SQLImplementing a Logical Data Model by Using LINQ to SQLManaging Performance and Handling ConcurrencyLab : Using LINQ to SQLUsing LINQ to SQL to Build a Data Access LayerUpdating aÂ Database by Using aÂ Stored ProcedureBuilding a Custom Entity ClassDesign a logical data model by using LINQ to SQL.Manage performance by using LINQ to SQL, and handle concurrency.