Greg Low recently presented at Sql Server and Dont Net Usergroup in Perth. He was brilliant. This encouraged me to view his webcasts from Teched 2007. The first being DAT210 where he presented on DBA guide to Clr integration.
In turn this screencast reminded me that I have not blogged about the Sql Datatypes before. Sql Clr introduced new datatypes for example SqlString, SqlBoolean etc. These datatypes are found in the System.Data.SqlTypes namespace. The difference between a SqlString and a String is that the SqlString is Nullable. That is it has a string value and also if it is null or not.
Greg suggestion is that all interfaces to Sql Server should use the Sql datatypes. In other words everytime you expose something that will be seen by Sql Server or Tsql use the Sql datatypes (inputs, types of methods, return values etc). Internal to your code does not need to do this.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment