SqlConversions.Translate method (1 of 3)

Translates the command text to the target connection dialect by replacing brackets ([]) and parameter prefixes (@). If the query already has a dialect set, it uses that instead of the connection one.

public static string Translate(IQueryWithParams query, IDbConnection connection)

parameter	description
query	The SQL query.
connection	The connection to get the dialect from.

Return Value

The translated query.

See Also

• interface IQueryWithParams
• class SqlConversions

---

SqlConversions.Translate method (2 of 3)

Translates the command text to the target connection dialect by replacing brackets ([]) and parameter prefixes (@).

public static string Translate(string commandText, IDbConnection connection)

parameter	description
commandText	The command text.
connection	The connection.

Return Value

The translated query.

See Also

• class SqlConversions

---

SqlConversions.Translate method (3 of 3)

Translates the command text to the target dialect by replacing brackets ([]) and parameter prefixes (@).

public static string Translate(string commandText, ISqlDialect dialect)

parameter	description
commandText	The command text.
dialect	The dialect.

Return Value

The translated query.

See Also

• interface ISqlDialect
• class SqlConversions