Beginning SQL server modeling : model-driven appplication development in SQL server 2008

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. 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 The author includes all the information one needs to be successful with designing and implementing workflow modeling using the Microsoft Oslo platform. Original. Bart Weller. Description Based On Print Version Record. Sql Server Modeling And The Oslo Framework Revealed--cover. Includes Index.