A post to keep track of interesting bits of information regarding .NET development. Latest notes on backing up SQL Server 2005 databases from .NET code and creating / managing compressed filed from .NET code.
Backing up a SQL Server 2005 Database in C#: Use the Smo interface as demonstrated here: http://www.geekpedia.com/tutorial180_Backup-and-restore-SQL-databases.html. However if you need to do this on an x64 server then you need to download the x64 DLL: http://www.microsoft.com/downloads/details.aspx?familyid=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en (see general IT article for extracting without installing).
Creating and Managing Compressed Files in C#: This open source library certainly does the trick: http://www.icsharpcode.net/OpenSource/SharpZipLib/Default.aspx
Dynamic Proxy Classes in C#.NET: I recently came to use a dynamic proxy class in .net having previously used them in Java and found to my surprise that they are quite complex to implement in .net. Follows is a solution for .net however I ended up using an open source solution, Castle.DynamicProxy.