{"id":5303,"date":"2012-03-15T11:34:11","date_gmt":"2012-03-15T11:34:11","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/visualstudioalm\/2012\/03\/15\/the-code-index-sdk-part-2-bulk-indexing-assemblies-into-the-code-index\/"},"modified":"2019-02-14T17:59:34","modified_gmt":"2019-02-15T01:59:34","slug":"the-code-index-sdk-part-2-bulk-indexing-assemblies-into-the-code-index","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/devops\/the-code-index-sdk-part-2-bulk-indexing-assemblies-into-the-code-index\/","title":{"rendered":"The Code Index SDK \u2013 Part 2 \u2013 Bulk indexing assemblies into the code index"},"content":{"rendered":"

Note that this post was updated on June 5th to provide updates concerning the Visual Studio 2012 RC. The changes are highlighted<\/font>.<\/font><\/p>\n

In my last post<\/a>, I’ve introduced the Code Index, explaining why use it, and how to get it. This post is about the first scenario that I mentioned: bulk indexing assemblies into the code Index. This topic requires that you have installed the VsVmSdk, as explained already.<\/p>\n

3. How to bulk index assemblies in the Code Index ?<\/h3>\n

In  Visual Studio 11 Beta, the only way to bulk-index assemblies is by using MsBuild. The supported scenarios are:<\/p>\n

– index assemblies as part of a build outside Visual Studio.<\/p>\n

– index an arbitrary set of assemblies from the command line<\/p>\n

3.1 Bulk indexing of assemblies from the command line<\/h4>\n

3.1.1 Presentation<\/h5>\n

You can use MSBuild directly from the command line to load artifacts into a specified code index. By default, the database will be created if it does not already exist.<\/p>\n

As a minimum, you will need to specify the artifacts to be loaded. Optionally, the following parameters can also be specified: database name, SQL server name, connection string, and whether the database should be created if it does not exist. If the connection string is specified then the database name and SQL Server name parameters will be ignored.<\/p>\n

3.1.2 Examples<\/h5>\n

The following examples show how you can use MsBuild to index assemblies. For simplicity, here we suppose that we are running in a console window, and that the current path is the the folder where the MsBuild tasks are installed (See § 2.3<\/a>). If this is not the case, of course, you need to provide the full path for Microsoft.Repository.targets<\/strong>. Also note that the commands should really be on one line (but the blog page is too narrow for me to write everything on line, so I cut the command into 2 lines)<\/p>\n\n\n\n\n\n\n\n\n
\n

msbuild Microsoft.Repository.targets \/t:LoadFiles
\/p:LoadFileSpec=*.dll<\/font><\/p>\n

Effect: loads all matching files from the current directory into the default code index. A new database will be created if necessary<\/p>\n<\/td>\n<\/tr>\n

\n

msbuild Microsoft.Repository.targets \/t:LoadFiles            
\/p:LoadFileSpec=*.dll \/p:CreateRepository=false<\/font><\/p>\n

Effect: loads all matching files from the current directory into the default code index. The database<\/b> will not be created<\/b> if it does not already exist<\/p>\n<\/td>\n<\/tr>\n

\n

msbuild Microsoft.Repository.targets \/t:LoadFiles            
\/p:LoadFileSpec=“<\/font>***.dll;***.exe“<\/font><\/font><\/p>\n

Effect: loads all matching files from the current directory and sub-directories<\/b> into the default Repository (note the MsBuild syntax **<\/font> means “recursively”)<\/i><\/p>\n<\/td>\n<\/tr>\n

\n

msbuild Microsoft.Repository.targets \/t:LoadAFiles            
\/p:LoadFileSpec=*.dll \/p:RepositoryDb=MyCodeIndex<\/font><\/p>\n

Effect: loads all matching files from the current directory into the specified database<\/b> using the default SQL server<\/i><\/p>\n<\/td>\n<\/tr>\n

\n

msbuild Microsoft.Repository.targets \/t:LoadFiles            
\/p:LoadFileSpec=*.dll \/p:RepositoryServer=MyDivisionSqlServer<\/font><\/p>\n

Effect: loads all matching files from the current directory into the default database on the specified SQL server<\/b><\/i><\/p>\n<\/td>\n<\/tr>\n

\n

msbuild Microsoft.Repository.targets \/t:LoadFiles \/p:LoadFileSpec=*.dll
\/p:RepositoryServer=MyDivisionSqlServer \/p:RepositoryDb=MyCodeIndex<\/font><\/p>\n

Effect: loads all matching files from the current directory into the specified database on the specified SQL server<\/i><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

<\/font><\/p>\n

The command can be summarized as the following (between squared brackets I’ve represented optional commands)<\/p>\n

Msbuild
%ProgramFiles(x86)%MSBuildMicrosoftVisualStudiov11.0RepositoryMicrosoft.Repository.targets
[ \/t:LoadFiles ]
\/p:LoadFileSpec=Folder<\/i>*.dll | Folder<\/i>***.dll
[ \/p:CreateRepository=false ]
[ \/p:RepositoryServer=SqlServerInstanceName<\/i> ]
[ \/p:RepositoryDb=DatabaseName<\/i> ]<\/font><\/p>\n

3.2 Creating a standalone MsBuild project to index specific assemblies<\/h4>\n

Another way of indexing assemblies is by creating an MSBuild project that sets the configuration properties (e.g. files to index, connection string etc …) then invokes the new Repository tasks and targets directly. You will then be able to index the assemblies simply by building the project from the command line e.g. <\/p>\n

msbuild SampleProject.proj<\/font><\/p>\n

The following example (SampleProject.proj<\/font>) shows a custom project that will load all of the .exe and the .dll files which name starts with “Build” located in the same directory as the target file into a database folder named “TargetFolder” of a database called “MyTestDb”. This database will be created under S:SqlData<\/font>.<\/p>\n\n\n\n
\n

<?xml version=”1.0″ encoding=”utf-8″ ?>
<Project DefaultTargets=”LoadArtifacts”<\/strong> ToolsVersion=”4.0″
   xmlns=”http:\/\/schemas.microsoft.com\/developer\/msbuild\/2003″><\/font><\/p>\n

<\/font> <\/p>\n

<!– Custom project file to load all of the assemblies and executables in the same folder as the project file. Note that the “DefaultTargets” property has been set above to “LoadArtifacts”. –><\/font><\/p>\n

<\/font> <\/p>\n

<PropertyGroup><\/font><\/p>\n

<\/font> <\/p>\n

<!– Change the directory in which the database will be created. –>
<RepositoryDirectory<\/strong>>S:SqlData<\/RepositoryDirectory<\/strong>><\/font><\/p>\n

<\/font> <\/p>\n

<!– Change the database into which the data will be loaded. –>
<Repository<\/strong>>MyTestDb<\/Repository<\/strong>><\/font><\/font><\/p>\n

<\/font> <\/p>\n

<!—- Repository Folder into which the data will be loaded—>
<TargetFolder<\/strong>>LastVersion<\/TargetFolder<\/strong>><\/font><\/p>\n

<\/font> <\/p>\n

<\/PropertyGroup><\/font><\/p>\n

<\/font> <\/p>\n

<ItemGroup><\/font><\/p>\n

<\/font> <\/p>\n

<!– Specify the artifacts to load –>
<ArtifactsToLoad<\/strong> Include=”Build*.dll” \/>
<ArtifactsToLoad<\/strong> Include=”*.exe” \/><\/font><\/p>\n

<\/font> <\/p>\n

<\/ItemGroup><\/font><\/p>\n

<\/font> <\/p>\n

<!– Import the core Repository tasks and targets–><\/font><\/p>\n

<\/font> <\/p>\n

<Import Project=”$(MSBuildExtensionsPath)MicrosoftVisualStudiov11.0RepositoryMicrosoft.Repository.targets”\/><\/font><\/strong><\/p>\n

<\/font> <\/p>\n

<\/Project><\/font><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Note that, in the code index SDK Beta, the element describing the database used to be <RepositoryDb<\/strong>>MyTestDb<\/RepositoryDb<\/strong>>. <\/font>From Visual Studio 2012 RC, it is now <Repository<\/strong>>MyTestDb<\/Repository<\/strong>><\/font><\/font><\/p>\n

 <\/p>\n

3.3 Reference for the MsBuild tasks<\/h4>\n

I’ll recap here what you can use in your msbuild projects:<\/p>\n

3.3.1 MSBuild properties and item groups<\/h5>\n

The following properties and item groups can be used to configure the loading process.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n
\n

Item<\/b><\/p>\n<\/td>\n

\n

Description<\/b><\/p>\n<\/td>\n<\/tr>\n

\n

$(Repository)<\/font><\/p>\n

Used to be $(RepositoryDb) <\/font>in Beta<\/font><\/p>\n

        <\/td>\n

\n

Name of the database into which data should be loaded.<\/p>\n

Ignored if $(RepositoryConnectionString)<\/font> is specified.<\/p>\n

Default value:<\/b> Microsoft.VsCodeIndex<\/font><\/em><\/p>\n

Default value used to be Repository <\/i>in Beta<\/font><\/p>\n

        <\/td>\n<\/tr>\n

\n

$(RepositoryServer)<\/font><\/p>\n<\/td>\n

\n

Name of the SQL Server.<\/p>\n

Ignored if $(RepositoryConnectionString)<\/font> is specified.<\/p>\n

Default value:<\/b> (localdb)v11.0<\/i><\/p>\n<\/td>\n<\/tr>\n

\n

$(RepositoryConnectionString)<\/font><\/p>\n<\/td>\n

\n

Full connection string to database to use.<\/p>\n

Default value:<\/b> calculated using $(RepositoryDb)<\/font> and $(RepositoryServer)<\/font>.<\/p>\n<\/td>\n<\/tr>\n

\n

$(CreateRepository)<\/font><\/p>\n<\/td>\n

\n

Flag that indicates whether the specified Repository database will be created if it does not already exist.<\/p>\n

Default value:<\/b> True<\/i><\/p>\n<\/td>\n<\/tr>\n

\n

$(RepositoryDirectory)<\/font><\/p>\n<\/td>\n

\n

Operating system directory in which the new database will be created (in order to control where to locate the database files)<\/p>\n

Ignored if a new database is not created.<\/p>\n

Default value:<\/b> null<\/i><\/p>\n<\/td>\n<\/tr>\n

\n

@(ArtifactUris)<\/font><\/p>\n<\/td>\n

\n

The list of artifacts to load (See the MsBuild targets below)<\/p>\n

Default value:<\/b> null<\/i><\/p>\n<\/td>\n<\/tr>\n

\n

$(TargetFolder)<\/font><\/p>\n<\/td>\n

\n

The target code index folder into which the artifacts should be loaded. In the code index, the information about indexed assemblies is stored in folders, which are the unit of deletion. Several assemblies can be stored in the same folder. If this parameter is not provided, then the name of the folder is computed (from the assembly name and a GUID)<\/p>\n

Default value:<\/b> null<\/i><\/p>\n<\/td>\n<\/tr>\n

\n

$(LoadFileSpec)<\/font><\/p>\n<\/td>\n

\n

File specification of files to load. <\/p>\n

Examples of usage from the command line:<\/p>\n

\/p:LoadFileSpec=*.dll <\/font><\/p>\n

<\/font> <\/p>\n

\/p:LoadFileSpec=***.dll<\/font><\/p>\n

<\/font> <\/p>\n

\/p:LoadFileSpec=*.dll;*.exe<\/font><\/p>\n

Default value:<\/b> null<\/i><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

3.3.2 User-callable MSBuild targets<\/h5>\n

The following targets can be called<\/p>\n\n\n\n\n\n
\n

Target<\/b><\/p>\n<\/td>\n

\n

Description<\/b><\/p>\n<\/td>\n<\/tr>\n

\n

LoadArtifacts<\/font><\/p>\n<\/td>\n

\n

Low level task that provides maximum control of the execution of the loading process i.e. the user can specify all of the available configuration options. <\/p>\n<\/td>\n<\/tr>\n

\n

LoadFiles<\/font><\/p>\n<\/td>\n

\n

Wrapper around LoadArtifacts<\/font> to simplifying loading files from the command line. The user specifies the files to load using the $(LoadFileSpec)<\/i><\/font> property.<\/p>\n

The target uses this property to set @(ArtifactsToLoad)<\/font> and then calls the LoadArtifacts<\/font> target.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

Note that this post was updated on June 5th to provide updates concerning the Visual Studio 2012 RC. The changes are highlighted. In my last post, I’ve introduced the Code Index, explaining why use it, and how to get it. This post is about the first scenario that I mentioned: bulk indexing assemblies into the […]<\/p>\n","protected":false},"author":77,"featured_media":45953,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[226,1],"tags":[],"class_list":["post-5303","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ci","category-devops"],"acf":[],"blog_post_summary":"

Note that this post was updated on June 5th to provide updates concerning the Visual Studio 2012 RC. The changes are highlighted. In my last post, I’ve introduced the Code Index, explaining why use it, and how to get it. This post is about the first scenario that I mentioned: bulk indexing assemblies into the […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/posts\/5303","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/users\/77"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/comments?post=5303"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/posts\/5303\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/media\/45953"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/media?parent=5303"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/categories?post=5303"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/tags?post=5303"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}