Is there a working example with a 'different database, same server' project reference?

[stijnherreman]

I have two databases (Foo and Bar) on the same server and create a project for each. Next, in the Bar project I add a Database Reference to the Foo project.

• Reference type: Project
• Database project: Foo
• Location: Different database, same server
• Database name: Foo
• Database variable: Foo
• Suppress errors caused by unresolved references in the project: No (default)

This adds the following content to Bar.sqlproj:

  <ItemGroup>
    <SqlCmdVariable Include="Foo">
      <DefaultValue>Foo</DefaultValue>
      <Value>$(SqlCmdVar__1)</Value>
    </SqlCmdVariable>
  </ItemGroup>
  <ItemGroup>
    <ProjectReference Include="..\Foo\Foo.sqlproj">
      <Name>Foo</Name>
      <Project>{10CF52FB-97C5-4E77-B533-803D6D0A86C5}</Project>
      <Private>True</Private>
      <SuppressMissingDependenciesErrors>False</SuppressMissingDependenciesErrors>
      <DatabaseSqlCmdVariable>Foo</DatabaseSqlCmdVariable>
    </ProjectReference>
  </ItemGroup>

Now I try to create a view, but all of these variations fail to compile with SQL71561 errors:

create view Test as select Id, Name from [Foo].dbo.Widgets
create view Test as select Id, Name from [$SqlCmdVar__1].dbo.Widgets
create view Test as select Id, Name from [$(SqlCmdVar__1)].dbo.Widgets

I've tried this method for existing databases that are in use and for newly created databases. I've also tried removing the <DatabaseSqlCmdVariable>Foo</DatabaseSqlCmdVariable>.

Is there a working example available?