Category: News

[HowTo] LINQ filter : Ignore accented letters (Diacritics) in string comparison ?

Here is a small extension method that will do the job (Warning : do not use for Linq To Sql): public static string RemoveDiacritics(this string text) { string formD = text.Normalize(NormalizationForm.FormD); StringBuilder sb = new StringBuilder(); foreach (char ch in formD) { UnicodeCategory uc = CharUnicodeInfo.GetUnicodeCategory(ch); if (uc != UnicodeCategory.NonSpacingMark) { sb.Append(ch); } } return […]

Visual Studio 2012 Color Theme

First thing first, here is the tool : Install via Extension Manager (Tools/Options) Install via Visual Studio (download and open directly or save then double-click) Install via “xcopy” into %appdata%\Local\Microsoft\VisualStudio\10.0\Extensions For Visual Studio 2012 Express, check this link : How to change Icons :

SQL Compact data and schema script utility

When using a “normal” MsSql database (whatever the version), the management tool allow us to create a “database generation script”. This option does not exists for SqlCE Databases (soooo sad). Here is a little third-party tools that woes the trick… Among creating “scripts”, the add-in adds the following menu items to the table context […]