SqliteConnectionStringBuilder.ForeignKeys Property

  • Reference

Definition

Namespace:
Microsoft.Data.Sqlite
Assembly:
Microsoft.Data.Sqlite.dll
Package:
Microsoft.Data.Sqlite.Core v3.0.0
Package:
Microsoft.Data.Sqlite.Core v3.1.0
Package:
Microsoft.Data.Sqlite.Core v5.0.0
Package:
Microsoft.Data.Sqlite.Core v6.0.0
Package:
Microsoft.Data.Sqlite.Core v7.0.0
Package:
Microsoft.Data.Sqlite.Core v8.0.0

Gets or sets a value indicating whether to enable foreign key constraints. When true, PRAGMA foreign_keys = 1 is sent immediately after opening the connection. When false, PRAGMA foreign_keys = 0 is sent. When null, no pragma is sent. There is no need to enable foreign keys if, like in e_sqlite3, SQLITE_DEFAULT_FOREIGN_KEYS was used to compile the native library.

public bool? ForeignKeys { get; set; }
member this.ForeignKeys : Nullable<bool> with get, set
Public Property ForeignKeys As Nullable(Of Boolean)

Property Value

Nullable<Boolean>

A value indicating whether to enable foreign key constraints.

Applies to