How To Use SqlParameterCache (Caching Sql Parameters)

Posted by Sameer on June 29, 2007 in .NET articles, SQL |

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!


Encryption and Decryption for Dummies in .NET

Posted by Sameer on June 27, 2007 in .NET articles, Deconstructing Subtext |

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 in C#

Posted by Sameer on June 27, 2007 in .NET articles, Software Engineering |

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.


Search Trigger Text SQL Server 2005

Posted by Sameer on June 26, 2007 in SQL |

How to search if a trigger contains certain text in SQL Server 2005:

FROM syscomments
WHERE [text] LIKE ‘%your_search_here%’ AND OBJECTPROPERTY(id, ‘IsTrigger’) = 1


Guid Or Int Primary Key?

Posted by Sameer on June 25, 2007 in SQL |

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.


Mock Objects for Dependencies

Posted by Sameer on June 23, 2007 in Software Engineering |

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 Insider’s Look at Microsoft’s Software Testing

Posted by Sameer on June 22, 2007 in Software Engineering |

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.


Creating Maintainable Database Queries In C# (with source code)

Posted by Sameer on June 15, 2007 in .NET articles, SQL |

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!


Our .NET articles

Posted by Sameer on June 13, 2007 in Programming |

Looking for the rest of our .NET C# articles? Look no further – Our articles are here


Visual Source Safe Pinning Feature

Posted by Sameer on June 12, 2007 in Visual SourceSafe |

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.

Copyright © 2007-2014 Agile Chai All rights reserved.
This site is using the Desk Mess Mirrored theme, v2.0.2, from BuyNowShop.com.