Getting connection user's language (culture) for the entityConnection RRS feed

  • Question

  • Hi,

    I'd like to know if it is possible to detect at runtime which language (culture) is using the session I am currently using to connect to the database using entity framework.

    That is, I have a user in my connection string which I use to stablish an entityConnection against a database; I'd like to know which is the culture of that user in SQL Server, so that I get to know which datetime format is using.

    I need this because I am executing an stored procedure to do an insert-select in DB, and one of the values of that select is a datetime, which I need to specify in the correct format, depending on the user that is executing my applications.

    Thanks a lot and regards,

    Igor Mendizabal

    Thursday, October 18, 2012 6:24 PM