Beginning SQL Server Modeling: Model-Driven Application Development in SQL Server 2008

✍ Scribed by Bart Weller

• Publisher: Apress
• Year: 2010
• Tongue: English
• Leaves: 257
• Edition: 1
• Category: Library

✦ Synopsis

File type: PDF Get ready for model-driven application development with SQL Server Modeling! This book covers Microsofts SQL Server Modeling (formerly known under the code name «Oslo») in detail and contains the information you need to be successful with designing and implementing workflow modeling. Beginning SQL Server Modeling will help you gain a comprehensive understanding of how to apply DSLs and other modeling components in the development of SQL Server implementations. Most importantly, after reading the book and working through the examples, you will have considerable experience using SQL Modeling components, because the book and accompanying source code take you through the steps of actually building solutions using the platform. Beginning SQL Server Modeling is the only book that comprehensively covers .NET application development using SQL Modeling. This book explains the critical concepts of SQL Server Modeling and model-driven development that every SQL Server developer should know. The book is simple and concise, giving readers an immediate return on their investment. After learning the lessons of this book, business process analysts and developers will be prepared to use SQL modeling for model-based design, development, and implementations.

✦ Table of Contents

Prelim......Page 1
Contents at a Glance......Page 6
Contents......Page 7
About the Author......Page 12
About the Technical Reviewer......Page 13
Acknowledgments......Page 14
Introduction......Page 15
Software Pre-Requisites......Page 17
Configuring SQL Server......Page 18
Downloading and Installing......Page 20
Checking the Installation......Page 23
If Something Goes Wrong…......Page 24
The Uninstall Option......Page 25
Summary......Page 28
Getting Started with Intellipad......Page 29
The File Menu......Page 30
The Edit Menu......Page 32
The Find Commands......Page 33
The Replace Command......Page 34
Behaviors......Page 35
The View Menu......Page 36
Full Screen......Page 37
Split Windows......Page 39
The Mini-Buffer......Page 40
Commands List......Page 41
View Title Banner Functions......Page 42
View Modes......Page 43
Some Caveats......Page 49
Where You Want to End Up......Page 50
Getting Started with the Intellipad DSL Grammar Mode Interface......Page 52
Broadening the Choices......Page 55
Interleaving (Ignoring) Whitespace......Page 56
Defining Tokens......Page 57
Enabling Multiple DSL Statements......Page 58
Moving Toward Structured Data......Page 61
Testing the Syntax......Page 64
Making the Syntax More Flexible......Page 68
The SandwichLanguage DSL MGraph......Page 69
Extending SandwichOrders to More Than One Main Ingredient......Page 70
Deployment......Page 72
Thinking Ahead......Page 94
Concluding Thoughts......Page 95
My Car: Creating a Simple Model in Quadrant......Page 97
Building the Car Model in Quadrant......Page 98
Deploying the Model to SQL Server......Page 101
Viewing the Model and Adding Data in the Explorer......Page 103
Customizing Column Views in Quadrant......Page 109
Viewing and Editing the Model in SQL Server......Page 111
Managing Changes to the Data in Quadrant......Page 113
Managing Conflicts in Quadrant......Page 115
Using the Quadrant Explorer Query Bar......Page 118
More on Customizing the View......Page 121
Summary......Page 130
Getting Started with M......Page 131
Modules......Page 132
Types......Page 133
Intrinsic and Derived Types......Page 134
M’s Built-Ins: The Intrinsic Types......Page 136
The Collection Type......Page 138
The Entity Type......Page 141
Modules Revisited: Import and Export Directives......Page 143
Extents......Page 145
Generating T-SQL Code for the Car Model......Page 147
Computed Values......Page 149
Overloading......Page 151
Summary......Page 152
SQL Server Modeling Services – The Folder Pattern......Page 153
The Modeling Services Folder Pattern......Page 154
Example: A Quality Control System for CarModel......Page 155
SQL Server Modeling Services – Security......Page 179
Setting Up – Installing the PatternApplication Sample......Page 180
Building on the CarModel......Page 181
Building the MfgComponentModel Project in Visual Studio......Page 184
Refining the Model to Include Security......Page 186
HasFolderAndAutoId......Page 191
Adding the PatternApplication Module......Page 192
Building the Project......Page 197
Deploying to the Database......Page 198
Creating the QC Folders......Page 203
Building the Sample Data......Page 206
Setting Up the QC Manager Test Users......Page 211
Configuring Test-User Permissions in SQL Server Management Studio......Page 214
Testing......Page 217
Summary......Page 221
Buffers......Page 223
The Mini-Buffer......Page 224
Customizing Intellipad......Page 225
Adding New Modes......Page 226
Compiled Components......Page 227
List of Available Modes......Page 228
Command-Line Options......Page 229
Intellipad Mini-Buffer Commands......Page 231
Intellipad Commands and Gestures......Page 233
The Quadrant Menu Tree......Page 241
Generated T-SQL for the Car Model Example......Page 245
. A......Page 251
. F......Page 252
. K......Page 253
.......Page 254
. V......Page 255
.......Page 256