SQL 71501 has an unresolved assembly reference
<p>We are using SSDT tools with Visual Studio 2015 and Target Platform set to SQL Server 2008. We are stuck with this function which is throwing an error and need assistance on what we can do to fix it.</p>

<pre><code> SQL71501: Function: [dbo].[GetFormattedAddress] has an unresolved reference to Assembly [AddressFormatting]


 CREATE FUNCTION [dbo].[GetFormattedAddress]
 (@AddressID INT, @CompleteAddress BIT)
RETURNS NVARCHAR (4000)
AS
EXTERNAL NAME [AddressFormatting].[AddressFormatting.UserDefinedFunctions].[GetFormattedAddress]

GO
</code></pre>

<p>--UPDATE</p>

<p>Under the Assemblies folder, for AddressFormatting.dll, i set the BuildAction to Build and then under the References i managed to see the Model Aware property which i have now set to True. After this now i get the following error:</p>

<p>SQL46010: Incorrect syntax near<a href="https://i.stack.imgur.com/8MIeY.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8MIeY.png" alt="enter image description here"></a></p>

<p>The file where it's pointing the error is AddressFormatting.dll</p>