Class DatabaseMailSchema.MailAttachment

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

sysmail_mailattachments (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

Contains one row for each attachment submitted to Database Mail. Use this view when you want information about Database Mail attachments. To review all e-mails processed by Database Mail use sysmail_allitems (Transact-SQL).

See dbo.sysmail_mailattachments.

[Table(Database = "msdb", Schema = "dbo", Name = "sysmail_mailattachments", IsView = true)]
public class DatabaseMailSchema.MailAttachment

Inheritance

object

DatabaseMailSchema.MailAttachment

Extension Methods

Map.DeepCopy<T>(T)

Properties

Attachment

The content of the attachment.

[Column("attachment")]
[NotNull]
public byte[] Attachment { get; set; }

Property Value

byte[]

AttachmentID

Identifier of the attachment.

[Column("attachment_id")]
[NotNull]
public int AttachmentID { get; set; }

Property Value

int

FileName

The file name of the attachment. When attach_query_result is 1 and query_attachment_filename is NULL, Database Mail creates an arbitrary filename.

[Column("filename")]
[NotNull]
public string FileName { get; set; }

Property Value

string

FileSize

The size of the attachment in bytes.

[Column("filesize")]
[NotNull]
public int FileSize { get; set; }

Property Value

int

LastModDate

The date and time of the last modification of the row.

[Column("last_mod_date")]
[NotNull]
public DateTime LastModDate { get; set; }

Property Value

DateTime

LastModUser

The user who last modified the row.

[Column("last_mod_user")]
[NotNull]
public string LastModUser { get; set; }

Property Value

string

MailItemID

Identifier of the mail item that contained the attachment.

[Column("mailitem_id")]
[NotNull]
public int MailItemID { get; set; }

Property Value

int