Share via


DbMigration.Sql(String, Boolean, Object) Method

Definition

Adds an operation to execute a SQL command or set of SQL commands.

Entity Framework Migrations APIs are not designed to accept input provided by untrusted sources (such as the end user of an application). If input is accepted from such sources it should be validated before being passed to these APIs to protect against SQL injection attacks etc.

protected internal void Sql (string sql, bool suppressTransaction = false, object anonymousArguments = null);
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Naming", "CA1719:ParameterNamesShouldNotMatchMemberNames", MessageId="0#")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Design", "CA1026:DefaultParametersShouldNotBeUsed")]
protected internal void Sql (string sql, bool suppressTransaction = false, object anonymousArguments = null);
member this.Sql : string * bool * obj -> unit
Protected Friend Sub Sql (sql As String, Optional suppressTransaction As Boolean = false, Optional anonymousArguments As Object = null)

Parameters

sql
String

The SQL to be executed.

suppressTransaction
Boolean

A value indicating if the SQL should be executed outside of the transaction being used for the migration process. If no value is supplied the SQL will be executed within the transaction.

anonymousArguments
Object

Additional arguments that may be processed by providers. Use anonymous type syntax to specify arguments e.g. 'new { SampleArgument = "MyValue" }'.

Attributes

Applies to