In this course, experienced developers who know the basics of data access (CRUD) in Windows client and Web application environments will learn to optimize their designs and develop better performing data access code by using the ADO.NET Entity Framework, LINQ, WCF Data Services, the Sync Framework, and ADO.NET.
Before attending this course, students must have:an understanding of the problem-solving techniques that apply to software development, including the following principles of software development:Modern software development modelsTypical phases of a software development lifecycleConcepts of event-driven programmingConcepts of object-oriented programmingCreating use-case diagramsDesigning and building a user interfaceDeveloping a structured applicationA basic understanding of the following scripting techniques and some hands-on experience writing scripts:Web scripting techniquesMacro scripting techniquesWindows scripting techniquesA general understanding of the purpose, function, and features of following .NET Framework topics:Common Language Runtime.NET Framework class libraryCommon Type SystemComponent interoperationCross-language interoperabilityAssemblies in the Common Language RuntimeApplication domainsRuntime hosts supported by the .NET FrameworkExperience using Visual Studio 2008 in the following task areas:Declaring and initializing typed variables using the Camel case naming conventionUsing arithmetic, relational, and logical operators in code statementsUsing branching statements to control code executionUsing looping statements to iterate through collections or repeat steps until a specified condition is metCreating classes and methods to establish the basic structure of an applicationUsing methods and events to implement the programming logic of an applicationIdentifying syntax and logic errorsAccessing and managing data from a data sourceExperience in object oriented design and development as follows:Creating and accessing classes and class propertiesCreating and accessing methods and overloaded methodsImplementing inheritance, base classes, and abstract classesDeclaring, raising, and handling eventsResponding to and throwing exceptionsImplementing interfaces and polymorphismImplementing shared and static membersImplementing genericsCreating components and class librariesExperience in N-Tier application design and development as follows:Managing a software development processControlling input at the user interface level in Windows client and Web applicationsDebugging, tracing, and profiling .NET applicationsMonitoring and logging .NET applicationsImplementing basic testing best practicesPerforming basic data access tasks with LINQBasics of LINQ to XMLBasics of LINQ to EntitiesBasics of LINQ to SQLImplementing basic security best practices in .NET ApplicationsBasics of Code Access SecurityBasics of Role-Based SecurityBasics of Cryptography ServicesImplementing basic service calls Basics of creating and consuming XML Web ServicesBasics of creating and consuming WCF ServicesUsing .NET Configuration FilesDeploying .NET Framework Applications using ClickOnce and the MS InstallerData access experience in Windows client application development as follows:Connect to a data sourceImplement data bindingImplement data validation at the UI layerData access experience in Web application development as follows:Connect to a data sourceImplement dynamic dataImplement data validation at the UI layer
5 Days/Lecture & Lab
This course is intended for professional .NET software developers who use Microsoft Visual Studio in a team-based, medium-sized to large development environment. They will have experience implementing data access and data binding within their Web and/or Windows client applications and are interested in learning to optimize data access code in their applications by using the Entity Framework, LINQ, and ADO.NET. Members of the audience are experienced users of Microsoft Visual Studio 2008 SP1 or newer releases of the Visual Studio product. The audience has some experience using Visual Studio 2010 for either Windows client or Web application development.Typically, this audience has the following knowledge/experience:Experience developing n-tier applications that access various data sourcesExperience implementing data binding within their applicationsSome experience using LINQ and ADO.NETA conceptual understanding of the Entity Framework