Posts
  • yingqin

    Column mappings in SqlBulkCopy are case sensitive

    • 0 Comments
    When you use SqlBulkCopy and set the ColumnMappings property, the column names are case sensitive regardless of the case sensitivity setting in target DB. A general error message "The given ColumnMapping does not match up with any column in the source...
  • yingqin

    Be Careful when using Table-Valued Parameter

    • 0 Comments
    Recently we found two implicit traps when using Table-Valued Parameter, which may easily lead to unexpected behaviors. First is that it needs additional precision/scale information when passing decimal type data, otherwise the decimal data would be...
  • yingqin

    Build warning msb3247 and msb3276 and msb3277

    • 1 Comments
    Frequently we may meet build warnings if a project indirectly reference same assembly with different versions. Recently I just noticed that such conflict version assembly may cause three similar/different build warnings: msb3247, msb3276 and msb3277....
  • yingqin

    Use PsTools to view certificate installed by System account

    • 0 Comments
    If you want to view certificates installed by System account in an Azure VM, directly remote to the VM cannot view the certificates as you are login in as a remote account. I just found an easy way to accomplish this purpose by using PsTools. Download...
  • yingqin

    Use Data-Driven Test for Parameterized Tests

    • 0 Comments
    In daily development, we usually have a requirement to write paramterized test cases. I used to use the following two simple methods Method 1 and Method 2 to accomplish such requirments, but their short comings are obvious. The first method works for...
  • yingqin

    A quite efficient compression algorithm: Blosc

    • 2 Comments
    Recently I just learnt about a new compression algorithm Blosc ( http://www.blosc.org/trac ). It has amazing performance, but with poor compression ratio (by design). I have done a performance comparison between the Blosc and the .Net built in Deflate...
  • yingqin

    Preliminary findings to get good performance of SqlBulkCopy

    • 0 Comments
    We want to develop a C# application which needs load data into local DB quickly, and found the initially implemented SqlBulkCopy has poor performance (only 14 MB/S). Here are the findings when I try to improve the performance. Test BaseLine: ...
  • yingqin

    Study Notes of "Pattern-Oriented Design"

    • 0 Comments
    Here are the study notes of my recently attended training "Pattern-Oriented Design". The lecturer is Amir Kolsky. Six Do's Do the right thing Process/PMs Do it right Understanding Do it efficiently Do it safely ...
  • yingqin

    Azure Storage Blobs: the API DownloadToStream is always faster than OpenRead

    • 0 Comments
    An interesting finding when using the Azure Storage is that the API ICloudBlob.DownloadToStream is always over 35% faster than ICloudBlob.OpenRead, no matter the Blob is page Blob or block Blob. The Storage Client Library we use is 2.0.0. Here is the...
  • yingqin

    Cancellation over .Net 4.0

    • 0 Comments
    To implement cancellation over .Net 4.0 is kind of convenient. See the following articles for reference: Cancellation in Managed Threads .NET 4 Cancellation Framework
  • yingqin

    Integrate native C++ project with managed C# projects

    • 2 Comments
    Scenario: recently our team need to use a compression algorithm which is implemented in native C++ codes, while our product codes are C#. This article introduces my end-to-end experience of integrating the C++ project with C# projects. Preliminary...
Page 1 of 1 (11 items)