visual studio 2010 - Using CLR UDT in table gives `unresolved reference to Sql Type` on deploy -


i have created clr udt use sql server 2008, , trying use database project.

  • both clr udt project , database project in same solution in visual studio
  • both set deploy in solution deployment settings
  • they both configured in respective project settings deploy same database
  • i have added reference , confirmed resultant dependency database project clr udt project

still, when try "deploy solution", builds (note: not deploy anywhere) sql clr project, starts going through "validating project model" of database project , throws error sql03006: column [schema].[table].[column] has unresolved reference sql type [typeschema].[typename]. on database column use clr type.

i tried going tools -> options -> database tools -> schema compare -> microsoft sql server 2008 , under object types set ignore user-defined types (clr), had no apparent effect whatsoever.

if deploy clr udt project database, go database , declare variable of type through sql server management studio, works (as expected). pretty has visual studio's idea of model validity, rather actual problem deployed result if try (and things in correct order).

google distinctly unhelpful. missing?

i found answer, , simple when realized going on not quite obvious before then.

what needed add create type command item creation script in database project clr udt becomes known such sql server. visual studio automatically on assembly deployment, apparently not consider during database project model validation.

with create type in place, seems working expected, , no error ignores needed.


Comments