This article describes how to cache your SqlParameters. Using the SqlParameterCache allows you to increase efficiency of calling stored procedures and even on executing regular SQL queries!
Monthly Archives: June 2007
Here is some code that demonstrates a very easy way to Encrypt and Decrypt using Rinjdael’s (AES) algorithm. Also explains how to use a symmetric key, how to generate a Key and IV value, and real source code you can use in your application.
Positive and negative testing complement each other. Positive testing is testing that code does what it should. Negative testing is testing that code doesn’t do what it shouldn’t. Together, you get a holistic view of your code! Come explore these concepts with us, as we deal with the well-known greatest common factor algorithm.
How to search if a trigger contains certain text in SQL Server 2005:
WHERE [text] LIKE ‘%your_search_here%’ AND OBJECTPROPERTY(id, ‘IsTrigger’) = 1
GROUP BY OBJECT_NAME(id)
When designing a database, and creating the tables and schema, we have to choose carefully what we want our primary key to be. There are many different aspects to this. This article discusses the benefits of using a GUID over an Integer primary key.
When you use automated testing, the question arises: how can you write tests that are independant, and don’t depend on other components (eg. database, login, etc.) working? The answer is: with mock objects.
An inside look at how Microsoft tests their code. For testing ASP.NET 2.0 and Visual Web Developer, they have ~105,000 test cases and ~505,000 functional test scenarios covered. Their team has approximately 1.4 testers for every 1 developer. Why? Because, They take quality pretty seriously at Microsoft, and because they have a lot of very hard requirements that necessitate careful planning and work to ensure high quality.
7 tips on how to create maintainable database queries. Create a data object, avoid stored procedures, build with stringbuilder, keep it together, code SQL over C#, use a SqlParameter Array, and Trust your judgement!
Looking for the rest of our .NET C# articles? Look no further – Our articles are here
A summary of how to use Visual Source Safe (VSS) Pinning. Pinning is a feature that can be used to set a certain version as releasable, and when you run ‘Get latest version’ it will give you the pinned version, rather than the latest one, which may not be suitable for release yet. It also can be used in conjunction with Visual Source safe branching and sharing.