Table of Contents

Class CompatibilitySchema.Language

Namespace
LinqToDB.Tools.DataProvider.SqlServer.Schemas
Assembly
linq2db.Tools.dll

sys.syslanguages (Transact-SQL)

Applies to: √ SQL Server (all supported versions) √ Azure SQL Database √ Azure SQL Managed Instance √ Azure Synapse Analytics √ Analytics Platform System (PDW)

Contains one row for each language present in the instance of SQL Server.


See sys.syslanguages.

[Table(Schema = "sys", Name = "syslanguages", IsView = true)]
public class CompatibilitySchema.Language
Inheritance
CompatibilitySchema.Language
Extension Methods

Properties

Alias

Alternative language name, for example, French.

[Column("alias")]
[NotNull]
public string Alias { get; set; }

Property Value

string

DateFormat

Date order, for example, DMY.

[Column("dateformat")]
[NotNull]
public string DateFormat { get; set; }

Property Value

string

Datefirst

First day of the week: 1 for Monday, 2 for Tuesday, and so on through 7 for Sunday.

[Column("datefirst")]
[NotNull]
public byte Datefirst { get; set; }

Property Value

byte

Days

Comma-separated list of day names in order from Monday through Sunday, with each name having up to 30 characters.

[Column("days")]
[Nullable]
public string? Days { get; set; }

Property Value

string

LangID

Unique language ID.

[Column("langid")]
[NotNull]
public short LangID { get; set; }

Property Value

short

Lcid

Microsoft Windows locale ID for the language.

[Column("lcid")]
[NotNull]
public int Lcid { get; set; }

Property Value

int

Months

Comma-separated list of full-length month names in order from January through December, with each name having up to 20 characters.

[Column("months")]
[Nullable]
public string? Months { get; set; }

Property Value

string

MsgLangID

Database Engine message group ID.

[Column("msglangid")]
[NotNull]
public short MsgLangID { get; set; }

Property Value

short

Name

Official language name, for example, Français.

[Column("name")]
[NotNull]
public string Name { get; set; }

Property Value

string

ShortMonths

Comma-separated list of short-month names in order from January through December, with each name having up to 9 characters.

[Column("shortmonths")]
[Nullable]
public string? ShortMonths { get; set; }

Property Value

string

Upgrade

Reserved for system use.

[Column("upgrade")]
[Nullable]
public int? Upgrade { get; set; }

Property Value

int?