How can i obtain an Sql Language name from a .Net Culture.

Question

Hello i'm using SQL server full-text search. when i use the FreeText predicate it need the language as parameter, but sql parameters name is different from .net culture names. So my question is How can i obtain an Sql Language name from a .Net Culture.

Answer 1

The LCID in the SYS.SYSLANGUAGES view of SQL Server is the same Windows Locale ID returned by the CultureInfo.LCID property in .NET. You can use this LCID as the language_term in your FREETEXT search.