Đang chuẩn bị liên kết để tải về tài liệu:
Beginning SQL Server Modeling- P10

Tham khảo tài liệu 'beginning sql server modeling- p10', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | CHAPTER 7 SQL SERVER MODELING SERVICES - SECURITY 180 Figure 7-22. M code for the PatternApplication module left pane In the Solution Explorer right-click on References under MfgComponentModel and select Add Reference. This will bring up the Add Reference dialog box. Click the Browse tab and navigate to the location of the PatternApplication.dll file as shown in Figure 7-23 . If you installed the sample to the following path My Documents Oslo PatternApplication Then the path of the DLL file should be My Documents Oslo PatternApplication bin Debug PatternApplication.dll. Download from Wow eBook www.wowebook.com CHAPTER 7 SQL SERVER MODELING SERVICES - SECURITY Figure 7-23. Browsing to the PatternApplication.dll location If this resolves the error then save all files Ctrl-Shift-S and you should be ready to build and deploy to the database. Building the Project Right-click the project name and select the Build option see Figure 7-24 . Figure 7-24. Executing the build 181 Download from Wow eBook www.wowebook.com CHAPTER 7 SQL SERVER MODELING SERVICES - SECURITY If the build is successful you should see results similar to that shown in the Output window in Figure 7-25. Output X Show output from Build j _2_. 1 Build started Project M-FgComponentModelj Con-Figuration Debug Any CPU M-FgCoinponentModel - C K-FgComponentModel M-FgComponentModel M-FgComponentModel bin Debug M-FgComponentModel. dll 1 I V Figure 7-25. Successful build results shown in the Output window Deploying to the Database Once the build is accomplished you should be ready to deploy the model to SQL Server. First however you need to make sure you have a valid connection string to the database. Right-click again on the project name and select Properties which should be at the bottom of the context menu Figure 7-26 . Figure 7-26. Selecting the project Properties window in the drop-down context menu Select the M Deployment at the bottom-left of the Properties pane see Figure 7-27 . 182 Download from Wow eBook