Class DataTableToSql

Inheritance
Object
DataTableToSql
Inherited Members
Namespace: DotNetHelper.ObjectToSql.Services
Assembly: DotNetHelper.ObjectToSql.dll
Syntax
public class DataTableToSql

Constructors

| Improve this Doc View Source

DataTableToSql(DataBaseType, Boolean)

Declaration
public DataTableToSql(DataBaseType type, bool alwaysUseParamerizedSql = true)
Parameters
Type Name Description
DataBaseType type
Boolean alwaysUseParamerizedSql

Properties

| Improve this Doc View Source

AlwaysCreateParamaterizedSql

Declaration
public bool AlwaysCreateParamaterizedSql { get; set; }
Property Value
Type Description
Boolean
| Improve this Doc View Source

DatabaseType

Declaration
public DataBaseType DatabaseType { get; }
Property Value
Type Description
DataBaseType
| Improve this Doc View Source

SqlSyntaxHelper

Declaration
public SqlSyntaxHelper SqlSyntaxHelper { get; }
Property Value
Type Description
SqlSyntaxHelper

Methods

| Improve this Doc View Source

BuildDbParameterList<T>(DataRow, Func<String, Object, T>)

Builds the SQL parameter list.

Declaration
public List<T> BuildDbParameterList<T>(DataRow row, Func<string, object, T> getNewParameter)

    where T : DbParameter
Parameters
Type Name Description
DataRow row
Func<String, Object, T> getNewParameter
Returns
Type Description
List<T>

List<DbParameter>.
Type Parameters
Name Description
T
| Improve this Doc View Source

BuildQuery(DataTable, ActionType)

Declaration
public string BuildQuery(DataTable dataTable, ActionType actionType)
Parameters
Type Name Description
DataTable dataTable
ActionType actionType
Returns
Type Description
String
| Improve this Doc View Source

BuildQuery(DataTable, ActionType, String)

Declaration
public string BuildQuery(DataTable dataTable, ActionType actionType, string tableName)
Parameters
Type Name Description
DataTable dataTable
ActionType actionType
String tableName
Returns
Type Description
String
| Improve this Doc View Source

BuildQueryFromRowState(DataRow)

Declaration
public string BuildQueryFromRowState(DataRow dataRow)
Parameters
Type Name Description
DataRow dataRow
Returns
Type Description
String
| Improve this Doc View Source

BuildQueryFromRowState(DataRow, String)

Declaration
public string BuildQueryFromRowState(DataRow dataRow, string tableName)
Parameters
Type Name Description
DataRow dataRow
String tableName
Returns
Type Description
String