Translate.md

SqlConversions.Translate method (1 of 3)

namespace: Serenity.Data   assembly: Serenity.Net.Data

Translates the command text to 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 dialect from.

Return Value

Translated query.

See Also

• interface IQueryWithParams
• class SqlConversions

---

SqlConversions.Translate method (2 of 3)

namespace: Serenity.Data   assembly: Serenity.Net.Data

Translates the command text to 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

Translated query.

See Also

• class SqlConversions

---

SqlConversions.Translate method (3 of 3)

namespace: Serenity.Data   assembly: Serenity.Net.Data

Translates the command text to 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

Translated query.

See Also

• interface ISqlDialect
• class SqlConversions