Table of Contents

Class UserSqlModel

Namespace
OpenSettings.Domains.Sql.Entities
Assembly
OpenSettings.dll

Represents a user entity.

[Table("Users")]
public class UserSqlModel : EntityBase<Guid>
Inheritance
UserSqlModel
Inherited Members

Properties

AuthType

The authentication type used by the user (e.g., "Machine", "OpenIdConnect").

public AuthType AuthType { get; set; }

Property Value

AuthType

DisplayName

The display name of the user, which may be different from their username or full name.

public string DisplayName { get; set; }

Property Value

string

Email

The user's email address.

public string Email { get; set; }

Property Value

string

EmailLowercase

The lowercase version of the Email, typically used for case-insensitive comparisons.

public string EmailLowercase { get; set; }

Property Value

string

ExternalId

The unique identifier provided by the identity provider if any.

public string ExternalId { get; set; }

Property Value

string

FamilyName

The family name

public string FamilyName { get; set; }

Property Value

string

FamilyNameLowercase

The lowercase version of the FamilyName, typically used for case-insensitive comparisons.

public string FamilyNameLowercase { get; set; }

Property Value

string

FullName

The full name of the user.

public string FullName { get; set; }

Property Value

string

FullNameLowercase

The lowercase version of the FullName, typically used for case-insensitive comparisons.

public string FullNameLowercase { get; set; }

Property Value

string

GivenName

The given name of the user.

public string GivenName { get; set; }

Property Value

string

GivenNameLowercase

The lowercase version of the GivenName, typically used for case-insensitive comparisons.

public string GivenNameLowercase { get; set; }

Property Value

string

HashedPassword

The hashed password for authentication.

public string HashedPassword { get; set; }

Property Value

string

IdentityProvider

The identity provider name (e.g., "local", Google", "Facebook") if the user authenticated using external service.

public string IdentityProvider { get; set; }

Property Value

string

Initials

The user's initials, typically derived from their name. (using GetInitials(string) helper method)

public string Initials { get; set; }

Property Value

string

IsActive

Indicates whether the user account is active.

public bool IsActive { get; set; }

Property Value

bool

IsEmailVerified

public bool IsEmailVerified { get; set; }

Property Value

bool

LastLogin

The date and time when the user last logged in.

public DateTime LastLogin { get; set; }

Property Value

DateTime

Locale

public string Locale { get; set; }

Property Value

string

MiddleName

public string MiddleName { get; set; }

Property Value

string

PictureUrl

public string PictureUrl { get; set; }

Property Value

string

RowVersion

A concurrency token used for tracking changes.
Helps prevent conflicts during concurrent updates.

public byte[] RowVersion { get; set; }

Property Value

byte[]

Slug

An url friendly version of the user, generated by trimming, converting to lowercase,
and replacing spaces or special characters with hyphens (using ToSlug(string) extension method).

public string Slug { get; set; }

Property Value

string

UserClaimMappings

The collection of user-claim mappings assigned to the user.

public virtual ICollection<UserClaimMappingSqlModel> UserClaimMappings { get; set; }

Property Value

ICollection<UserClaimMappingSqlModel>

UserGroupMappings

The collection of user-group mappings assigned to the user.

public virtual ICollection<UserGroupMappingSqlModel> UserGroupMappings { get; set; }

Property Value

ICollection<UserGroupMappingSqlModel>

UserNotificationMappings

The collection of user-notification mappings associated with the user.

public virtual ICollection<UserNotificationMappingSqlModel> UserNotificationMappings { get; set; }

Property Value

ICollection<UserNotificationMappingSqlModel>

UserRoleMappings

The collection of user-role mappings assigned to the user.

public virtual ICollection<UserRoleMappingSqlModel> UserRoleMappings { get; set; }

Property Value

ICollection<UserRoleMappingSqlModel>

Username

The username of the user.

public string Username { get; set; }

Property Value

string

UsernameLowercase

The lowercase version of the Username, typically used for case-insensitive comparisons.

public string UsernameLowercase { get; set; }

Property Value

string