I'm comparing the CLR functions from a pair of SSDT projects to a database. The only difference shown in the comparison is on two properties: IsDeterministic and DataAccess
The compare shows that the project has a NULL value for these properties, while the database shows the properties equal to false and 0, respectively.
The actual C# code for the functions does assign values to these properties. After updating the database and re-running the compare, the differences still show up.
How do I make the database compare exclude these differences?
How do I make the SSDT projects recognize the properties in the C# code when comparing?
I use this tool to generate change scripts, and it makes the process very difficult when I have to exclude these objects everytime.
My solution contains two projects- one with the C# code for the CLR assembly (with 'Generate DLL turned off), and the other with the T-SQL objects, including the DLL for the functions.