Entity Framework SQL Server Error Message Language

Question

I am working on an Application utilizing Entity Framework for Data Access. For some purposes it is neccessary to parse the SqlException Message for further information. I already found out that this Exception Message is directly coming from SQL Server. So to make that parsing process work i need to make sure the language is set to the same in every environment.

I am using to set the language

SET LANGUAGE English;

For test purposes I did following:

SET LANGUAGE English;
SELECT * FROM ABC;

ABC does not exist so it will obviously fail and i will get an error message. In Management Studio my ErrorMessage is showing this:

this is in English as supposed to.

Now when i try the same in C# i will get:

which is in german.

What am i missing? Any ideas anyone? Thanks very much...

I don't know much about EF but if it were to open & close the connection within the ExecuteSqlCommand method that would certainly explain it as SET LANGUAGE has session scope. — Alex K.
– Alex K., Commented May 29, 2019 at 15:42
Pretty sure ExecuteSqlCommand will start a new auto commit session. So your first SET LANGUAGE pretty much has no effect. — Steve
– Steve, Commented May 29, 2019 at 15:53
I think the "SET LANGUAGE" command is only used by the database engine for comparison rules etc. You need something at the EF level to set the local error message. Perhaps "CultureInfo.CurrentCulture = new CultureInfo("en-US");" — Steve Todd
– Steve Todd, Commented May 29, 2019 at 15:55
Changing the CurrentCulture wont work as the message is directly coming from SQLServer. But yes executing it in one command works. — Felix Almesberger
– Felix Almesberger, Commented May 29, 2019 at 15:57

Steve · Accepted Answer · 2019-05-29 15:55:24Z

3

instead of doing this in two ExecuteSqlCommand calls you should do this in one.

string command = "SET LANGUAGE English; SELECT * FROM ABC;";
ctx.Database.ExecuteSqlCommand(command);

ExecuteSqlCommand will start a new auto commit session. Your first SET LANGUAGE pretty much has no effect since the select is in another session.

answered May 29, 2019 at 15:55

Steve

12k7 gold badges48 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Felix Almesberger Over a year ago

Yes that is correct Thank you very much. Now i will need to find a way to change the language when querying the database with entity framework directly. So injecting the command before EF will execute the query.

Felix Almesberger Over a year ago

Ok so with this learn.microsoft.com/en-us/sql/database-engine/configure-windows/… I can set it permanently and that solved the issue. Thanks very much.

Collectives™ on Stack Overflow

Entity Framework SQL Server Error Message Language

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related