Intentional Thinking

Let’s focus on Exam 70-516 this time. This exam is TS: Accessing Data with Microsoft .NET Framework 4.

Additional Resources:

http://msdn.microsoft.com/en-us/data/cc300162.aspx#entity

The exam objectives are:

Modeling Data

Map entities and relationships by using the Entity Data Model	http://msdn.microsoft.com/en-us/library/ee382825.aspx http://msdn.microsoft.com/en-us/library/cc716685.aspx http://msdn.microsoft.com/en-us/library/bb399596.aspx
Map entities and relationships by using LINQ to SQL	http://msdn.microsoft.com/en-us/library/bb386976.aspx
Create and customize entity objects	http://msdn.microsoft.com/en-us/library/bb738695.aspx
Connect a POCO model to the Entity Framework	http://msdn.microsoft.com/en-us/library/dd456853.aspx
Create the database from the Entity Framework model	http://msdn.microsoft.com/en-us/library/dd456817.aspx http://msdn.microsoft.com/en-us/library/dd456821.aspx http://msdn.microsoft.com/en-us/library/bb399785.aspx
Create model-defined functions	http://msdn.microsoft.com/en-us/library/bb896279.aspx

 

Managing Connections and Context

Configure connection strings and providers	http://msdn.microsoft.com/en-us/library/ms254978.aspx http://msdn.microsoft.com/en-us/library/a6cd7c08.aspx
Create and manage a data connection	http://msdn.microsoft.com/en-us/library/32c5dh3b.aspx
Secure a connection	http://msdn.microsoft.com/en-us/library/ecb3hak0.aspx
Manage the DataContext and ObjectContext	http://msdn.microsoft.com/en-us/library/cc668193.aspx http://msdn.microsoft.com/en-us/library/bb738465.aspx
Implement eager loading	http://msdn.microsoft.com/en-us/library/bb896272.aspx http://msdn.microsoft.com/en-us/library/dd456846.aspx http://bit.ly/a8rIJv
Cache data	http://bit.ly/iIq5ie http://bit.ly/dEaEgH
Configure ADO.NET Data Services	http://msdn.microsoft.com/en-us/library/ee358710.aspx http://bit.ly/lEpfnk

 

Querying Data

Executing a SQL query	http://msdn.microsoft.com/en-us/library/bb738694.aspx
Create a LINQ query	http://msdn.microsoft.com/en-us/library/bb397942.aspx http://msdn.microsoft.com/en-us/library/bb397919.aspx http://msdn.microsoft.com/en-us/library/bb387098.aspx http://msdn.microsoft.com/en-us/library/bb882640.aspx
Create an Entity SQL (ESQL) query	http://msdn.microsoft.com/en-us/library/bb896297.aspx http://msdn.microsoft.com/en-us/library/bb399367.aspx http://msdn.microsoft.com/en-us/library/bb386964.aspx
Handle special data types	http://msdn.microsoft.com/en-us/library/87z0hy49.aspx http://msdn.microsoft.com/en-us/library/cc716724.aspx http://msdn.microsoft.com/en-us/library/bb675163.aspx
Query XML	http://msdn.microsoft.com/en-us/library/bb387098.aspx
Query data by using ADO.NET Data Services	http://msdn.microsoft.com/en-us/library/cc668796.aspx

 

Manipulating Data

Create, update, or delete data by using SQL statements	http://msdn.microsoft.com/en-us/library/tyy0sz6b.aspx http://msdn.microsoft.com/en-us/library/tf579hcz.aspx
Create, update, or delete data by using DataContext	http://msdn.microsoft.com/en-us/magazine/cc700340.aspx
Create, update, or delete data by using ObjectContext	http://msdn.microsoft.com/en-us/library/bb386870.aspx
Manage transactions	http://msdn.microsoft.com/en-us/library/bb896325.aspx http://msdn.microsoft.com/en-us/library/bb738523.aspx
Create disconnected objects	http://msdn.microsoft.com/en-us/library/ff407090.aspx http://msdn.microsoft.com/en-us/library/bb896271.aspx http://msdn.microsoft.com/en-us/library/zb0sdh0b.aspx http://msdn.microsoft.com/en-us/library/7zt3ycf2(v=VS.100).aspx

 

Developing and Deploying Reliable Applications

Monitor and collect performance data	http://msdn.microsoft.com/en-us/library/cc853327.aspx
Handle exceptions	http://msdn.microsoft.com/en-us/library/orm-9780596520281-01-21.aspx
Protect data	http://msdn.microsoft.com/en-us/library/ecb3hak0.aspx
Synchronize data	http://bit.ly/jo73i5
Deploy ADO.NET components	http://msdn.microsoft.com/en-us/library/bb896268.aspx http://msdn.microsoft.com/en-us/library/gg258442.aspx