SharpDeveloper
From the monthly archives: June 2007
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!
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:
SELECT OBJECT_NAME(id)
FROM syscomments
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.
-
Articles
- January 2011
- April 2010
- March 2010
- February 2010
- January 2010
- August 2009
- July 2009
- June 2009
- May 2009
- April 2009
- February 2009
- December 2008
- November 2008
- October 2008
- July 2008
- June 2008
- May 2008
- April 2008
- March 2008
- February 2008
- December 2007
- November 2007
- October 2007
- September 2007
- August 2007
- July 2007
- June 2007
- May 2007
-
Meta
