May 29, 2008

Customized SqlServer Project Type

This is 'bout a C# projectype which Niels has created to help facilitate SQLServer projects.
Link: http://nielsb.wordpress.com/sqlclrproject/sqlclrdl/





FeatureSQLCLRProjectBuilt-in
Specific VS project type and item templatesYesYes
Automatic deployment of assemblies and creation of T-SQL objectsYesYes
Debugging support objectsYesYes
Automatic creation of T-SQL deployment scriptsYes-
Automatic creation of T-SQL DML scripts for testing of the created objectsYes-
Create objects in a non-default schemaYes-
Define parameters in the .NET methods to have default values in T-SQLYes-
Define parameters in .NET to be created with different names in T-SQL
Yes-
Redeploying an UDT without manually dropping tables/columns depending on the UDTYes-

May 25, 2008

Vs.Net IDE Designer view Error : Object of Type "Xcannot be converted to type "X""




If this error occurs the Designer won't be able to show the controls of the form but will be able to show them at runtime, to eradicate this problem, close the designer view from the IDE, delete the .resx file associated with the .cs file of the form, then clean and rebuild the project.

The designer view will now be able to be loaded in the IDE.
Sometimes, even after the designer loads the UI, the resx file is missing, to correct this, just change any value of any control in the designer view and then change it back to the original value (like the text of a label)