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
Post a Comment