SQL Azure FederationsVersion: 2.0 DescriptionSQL Azure Federations is an integrated capability of SQL Azure Database that dramatically simplifies database sharding implementations. In this hands-on Lab, you will learn how to create a database with federations and develop applications that interacts with federated tables using both ADO.NET and Entity Framework. OverviewOne of the key value propositions of Windows Azure is the ability to achieve elastic scale by adapting dynamically to changes in demand. A single SQL Azure Database has limited capacity in terms of size and transactional throughput. To add more capacity you must partition your data across multiple SQL Azure databases. To release capacity, you must consolidate multiple SQL Azure databases into one. This approach is known as database sharding. SQL Azure Federations is an integrated capability of SQL Azure Database that dramatically simplifies database sharding implementations. ObjectivesIn this Hands-On Lab, you will learn how to:
PrerequisitesYou must have the following items to complete this lab:
Using the Code SnippetsThroughout the lab document, you will be instructed to insert code blocks. For your convenience, most of that code is provided as Visual Studio Code Snippets, which you can use from within Visual Studio 2010 to avoid having to add it manually. If you are not familiar with the Visual Studio Code Snippets, and want to learn how to use them, you can refer to the Setup.docx document in the Assets folder of the training kit, which contains a section describing how to use them. ExercisesThis Hands-On Lab contains the following exercises:
Note: The source code that accompanies this hands-on lab includes in each folder an End folder where you can find a Visual Studio solution with the code as if you completed the steps in each exercise. You can use this solution as a guide if you need additional help working through the exercises.If you’re running the End solutions without following the lab, notice that some may require manual configuration. To do this, please follow the instructions on each README.txt file located in the same folder of the End solution. Estimated time to complete this lab: 60 minutes |
