Archive for the ‘Programmation’ Category

List of neighboring states for each US state

June 1st, 2014 No comments

I was searching for a list of neighboring/bordering/adjacent states for each USA state.

I asked on StackOverflow but I had no luck:

I wasn’t able to find any open data.

So, I finally decided to create my own list using the following sources:

=> Feel free to verify, contribute and reuse my file: neighbors-states.csv


  • The SQL script was created for SQL Server 2008.

Possible improvements:

  • Add a column called “IsApproximativeNeighbor” in the table “NeighborStates” to define properly the relation between Alaska and Washington state even if there is no common border.

Off topic:

Categories: Programmation Tags:

What’s new in .NET Framework 4.5

October 1st, 2012 No comments

Here is a nice poster to summarize what’s new in .NET Framework 4.5:

Concerning ASP.NET, I like:

  • New site template for ASPNET MVC 4
  • Built-in Javascript + CSS combining and minification
  • Strongly typed data binding in ASP.NET Web Forms
  • Multiple file upload component for ASP.NET Web Forms
  • IIS Express used by default (instead of Cassini)
Categories: Programmation Tags:

Difference between “Independent association” and “Foreign key association” in Entity Framework

September 11th, 2012 No comments

I begin to understand the difference between “Independent association” and “Foreign key association” in Entity Framework Code First thanks to this article :

Advice: use both (Independent associations and Foreign key associations):

“This saves on unnecessary DB lookups, allows lazy loaking, and allows you to easily see/set the ID if you know what you want it to be. Note that having both does not change your table structure in any way.”


Categories: Entity Framework Tags:

Which version of ASP.NET MVC is used in an existing Visual Studio project

September 11th, 2012 No comments

Question: how to find which version of ASP.NET MVC is used in an existing Visual Studio project?

Answer: via Reflection:

typeof (Controller).Assembly.GetName().Version 


Categories: ASP.NET MVC Tags:

Improve error feedback on ASP.NET applications using Health Monitoring

December 12th, 2011 1 comment

When I switched from PHP to ASP.NET, I searched an equivalent to error_reporting() function.

I wanted to monitor all errors that happened on our production server. I know production software should be bug free but in the real world, bugs happen in many unexpected ways : an unusual navigation of the user that you hadn’t thought, an external database result which contains something that you didn’t even imagine in your units tests (database mocking is another topic…).

Context : we have a lot ASP.NET applications in production (more than 100), so modifying every application wasn’t an appropriate option.

Here is the steps of my implementation :

1. Natively, DotNet Framework adds in Windows Event Log an warning event when an exception occurs in an ASP.NET application (Yellow Screen of Death).
This mechanism is configurable through System Health Monitoring.
Windows event log is purged automatically but I currently have 3 or 4 weeks of history so it’s enough (“By default, event logs are set with a maximum file size of 512 KB. Then, when a log reaches this limit, events older than seven days are overwritten to prevent the log from exceeding the maximum file size”).

2. I created an executable (C# console project) which reads the event log and send an email to the appropriate developper(s) :

  • I use a CSV file with correspondence between “ASP.NET application URL” and the “email’s developer”. Simple but effective to avoid any dependency of an external resource that could fail (such as database, which will prevents me from being notified of -the so-called failure).
  • In fact, I still depend on the mail server… (I could provide a fail over solution that uses the command "NET SEND", SNMP… It would be good but a bit luxury at the stage).

3. A Windows Scheduled Task is configured (every 5 minutes) on the machine running IIS to run the executable.

  • A text file contains the date and time of the last exception that was sent by mail.
    Exceptions are sent by email and only once regardless of how often the scheduled task is executed. If the scheduled task didn’t run for any reason, just restart it and it will send emails back where it left off.

4. Display a Custom Error Page with the opportunity for the user to enter a comment and then sent it by email to the appropriate developer.
This mechanism is configurable through Web.config file. I created an .aspx page as simple as possible (no external dependencies) with a textbox and a "send" button.
This helps to stimulate the user feedback and hide the error details (for security reasons).

=> Conclusion : the main advantage of this hand made tool is that it requires no change in source code of the other applications.

  • 90% of users don’t call (or don’t know how to call) the IT department when they encounter an exception.
  • A small number of exceptions that occur aren’t visible to the user (mainly session handling errors).
  • The most common exceptions are easy to reproduce and fix (80-20 rule ?).
  • Then it becomes increasingly difficult to diagnose the type of exception and the call stack isn’t sufficient to understand what happened (I need to know the data entered by the user).
    I also developed a web application to group, sort and filter the exceptions but this will be the subject of another article.

Possible improvements :

  • Collect user input data and send it to the developer.
  • Find a way to catch and report client side Javascript exceptions to the server. Any idea ?

References :

Fiabilité de l’installation de plusieurs versions d’Internet Explorer sur la même machine

December 1st, 2010 No comments

Question : Est ce que les solutions qui permettent d’installer plusieurs versions d’Internet Explorer sur la même machine sont fiables ?

Réponse : Non, les solutions du type IETester, IECollection ou Multiple IE ne sont pas stables (plantages relativement fréquents) et n’assure pas un comportement 100% identique à la version originale d’Internet Explorer.

Remarque : Je déconseille d’installer IECollection sur une machine avec IE6 car cela a corrompu de mon IE6 natif (mêmes symptomes que le commentaire suivant “multiple blank ie6 browser windows open and i can not use it“).

Source : Tester fiablement ses navigateurs | BrainCracking – Veille technologique sur les applications Web.

Connexions distantes avec ASP.Net Development Server (Cassini) = impossible

October 22nd, 2010 No comments

Question : Est ce qu’il est possible de configurer le serveur Web de développement de Visual Studio “ASP.NET Development Server” (également nommé “Cassini”) afin qu’il réponde aux requêtes HTTP d’une machine distante ?

Réponse : Non, il est prévu pour répondre uniquement aux requêtes provenant de la machine locale.

Source :

Categories: ASP.NET Tags: ,

Démo intégration diaporama Picasa dans WordPress

October 10th, 2009 No comments

Voici un petit test
d’intégration d’un
diaporama Picasa
dans un blog WordPress.

Fonctionnalités intéressantes :

Restrictions connues :

Fonctionnalités à vérifier : Aucune pour le moment

Source :

Categories: Démos, Développement Web Tags:

Memento des comparaisons de types et conversions en PHP

April 8th, 2009 No comments

Du fait de typage faible des variables en PHP, les comparaisons de variables de types différents produisent parfois des résultats inattendus.
Le lien suivant récapitule tous les cas possibles de conversions :

Et enfin un petit quiz pour vérifier que vous avez tout compris :

Categories: PHP Tags: ,