Today I downloaded RhinoMocks and referenced in my test project (Microsoft Visual Studio Testing Environment) and executed my unit tests.
My tests failed with the same error (for all tests). Visual Studio was kind enough to find that the RhinoMocks.dll which I downloaded is not trusted and cannot be deployed in a test environment!
(click to enlarge)
It appears to be that any dll you download from the Internet or get it via email, some extra information called AES gets attached. This cautions the user that it was downloaded from Internet and needs attention. More info on this here
To resolve this issue, just open the properties of the file and Unblock it :)
This corresponds if you have Windows XP SP2, Windows Server SP1 or higher
Today I had the need to have optional parameters in my SQL stored procedure. And It wasn't that complex to implement :)
Below is the code:
ALTER PROCEDURE [dbo].[GetSampleRequests]
@Org varchar(50),
@Type varchar(50),
@From DateTime,
@To DateTime
AS
BEGIN
SELECT
Organisation,
ServiceType,
COUNT(DataStatus) AS DataStatusCount
FROM
SampleLog
WHERE
((@From IS NULL OR @To IS NULL) OR
TransactionDateTime BETWEEN @From and @To) AND
(@Org IS NULL OR Organisation = @Org) AND
(@Type IS NULL OR ServiceType = @Type)
GROUP BY
Organisation,
ServiceType
ORDER BY
Organisation,
ServiceType
END
The magic happens when we check whether the parameter is IS NULL :)
Recently I had the necessity to do cross-tab report with the SQL Server data. First thin that comes into everybody's mind is to use the PIVOT functionality in SQL Server. But, being a programmer, I am not that fluent in writing and managing complex queries. I was looking out for some .NET implementation and found an excellent article here which helped me accomplish this task :)
I think this is a lot easier for me than writing SQL queries ;)
And here is performance comparison of .NET CrossTabs and SQL Server CrossTabs