Here are pure open source based web map and geo location database resources. Google map or Bing map is wonderful, but they require business contract for commercial use. It is said that Foursquare recently switched their map tool from Google map to open source based Leaflet API which looks like the picture below. This map… Continue reading Open sources for web map and geo location
Author: rocker8942
Bulk data import to MSSQL
I was about to upload 2 million record of data using NHibernate’s default save method, which will transact every record independently. It estimated almost 2 days to upload all data. In this mass data upload, bulk import utility, bcp is pretty useful. It takes 10 minutes for 2 million record to import. Related well written article. http://lostechies.com/jimmybogard/2010/06/24/bulk-processing-with-nhibernate/ And… Continue reading Bulk data import to MSSQL
Resources for reading and writing photo meta tag like EXIF
http://social.msdn.microsoft.com/Forums/en-US/windowswic/thread/fdbcd8f4-5d75-4c33-8bed-97ef03a65c70 http://stackoverflow.com/questions/2755000/inplacebitmapmetadatawriter-trysave-returns-true-but-does-nothing http://www.andrewdothay.net/blog/2010/08/16/HowToEditMetaDataInsideJPGFilesWithC.aspx http://www.dreamincode.net/code/snippet3144.htm http://www.sno.phy.queensu.ca/~phil/exiftool/TagNames/EXIF.html http://www.sno.phy.queensu.ca/~phil/exiftool/TagNames/XMP.html#exif
C# Library for JSON
Namespace: Newtonsoft.Json.Linq Download: http://json.codeplex.com/
C# Library for QR code
There are several c# project about QR code. Among them, http://code.google.com/p/zxing/ looks one of the best as of now. Tip 1. When reading QR code from jpg file, the image size should be relatively small. I thought that big image of QR code is better to read, but it was wrong. Small QR code image… Continue reading C# Library for QR code