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

AuthScheme

The authentication scheme used by the user (e.g., "OAuth", "BasicAuth").

public string AuthScheme { get; set; }

Property Value

string

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

HashedPassword

The hashed password for authentication.

public string HashedPassword { 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

LastLogin

The date and time when the user last logged in.

public DateTime LastLogin { get; set; }

Property Value

DateTime

Name

The name of the user.

public string Name { get; set; }

Property Value

string

NameLowercase

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

public string NameLowercase { get; set; }

Property Value

string

OAuthProvider

The OAuth provider name (e.g., "Google", "Facebook") if the user authenticated using OAuth.

public string OAuthProvider { get; set; }

Property Value

string

ProviderId

The unique identifier provided by the authentication provider.

public string ProviderId { 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