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 : http://visualstudiogallery.msdn.microsoft.com/366ad100-0003-4c9a-81a8-337d4e7ace05 Install via Extension Manager (Tools/Options) Install via Visual Studio Gallery.com (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 : http://alinconstantin.blogspot.be/2012/09/using-color-themes-with-visual-studio.html How to change Icons : http://vsip.codeplex.com/

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… http://exportsqlce.codeplex.com/ Among creating “scripts”, the add-in adds the following menu items to the table context […]