O'Reilly logo

Microsoft SQL Server 2008 R2 Master Data Services by Jeremy Kashel, Tim Kent, Martyn Bullerwell

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

MDS assemblies

As discussed previously, the WCF service is not the only way to access MDS programmatically. Using the MDS Assemblies requires the DLLs to be available to the machine that is executing the code. This needs to be taken into consideration when building distributed applications. Direct use of the assemblies is predominantly used for administrative processes, such as:

  • Cloning models
  • Creating model deployment packages
  • Creating model update packages
  • Deploying packages
  • Deploying update packages
  • Deleting models

For this example, we will be creating a simple console application to demonstrate how to retrieve a list of Models from our MDS database. The project and source code for the following example is available in the file called 0509_09_HelloMDSAssemblies.csproj ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required