ZAP: a Tool for Generating ASP.NET Websites Automatically

ZAP - a small tool is very useful for coding reuse. It is a free tool that you can use to generate ASP.NET websites automatically. The tool generates a user interface, business logic, and data access layer automatically based on a configuration file.

Transferring Data Using SqlBulkCopy Class

Good article shows how to use SqlBulkCopy Class: Transferring Data Using SqlBulkCopy Class

Creating Publisher Certificates For ClickOnce

Just found a very useful article for ClickOnce: Creating Publisher Certificates For ClickOnce.

Some quoting from this article:

There is a good article - “Configuring ClickOnce Trusted Publishers“ by Brian Noyes published on MSDN.

Framework SDK contains tool MakeCert. Here is the command line to make a certificate similar to one created by VS:

makecert -r -pe -a sha1 -n "CN=yourcompany" -b 01/01/2000 -e 01/01/2036 -eku 1.3.6.1.5.5.7.3.3 -ss My

The -b and -e option specify the time period when certificate is valid. The -eku option specifies the certificate is intended for code signing. The -a sha1 option is to set the same algorithm that VS uses.

It's important to use the -pe option which allows to export the private key from the certificate. To do this use CertMgr (another tool from Framework SDK). The new certificate will be installed in your personal store. Select it and click on the Export button. Click Next on the first page, and on the second select to export the private key. On the next one you can select some additional options; if not sure just leave on default. After that you will be asked to type password for the file; can be left blank. On the last one specify the file name and location. Finish the wizard and you should get a .pfx file that can be used in VS or imported on user machines.