LightSwitch Tutorial on Data Design
LightSwitch uses an entity model to describe the data design. Folks with relational database experience need to understand how an entity model differs from a relational model. Folks with little or no database experience tend to design databases that look more like an Excel spreadsheet than a decent data design. This tutorial is intended to address both of these issues.
For Relational Database Folks
When you create your data model in LightSwitch, you are working with an entity model. LightSwitch and the Entity Framework work in the background to store the data in a relational database.
Those familiar with relational databases and relational models need to understand how they differ from entity models. This set of videos is designed to highlight the differences so that the relational database person can feel comfortable working with entity models.
For Non-Database Folks
You are a business domain expert and do not have training in designing a database. LightSwitch can help you with this task. However, there are a few basic concepts that you need to understand in order to minimize redundancy and keep data consistent.
This set of videos is designed to help you understand where you might go wrong and provides direction on avoiding the main design problems that can creep into a design. It is really important that you understand the issues covered in this tutorial and avoid them through careful design.
Enjoy … bill