public static string UpdateByPrimaryKey(DataTable dataTable)
{
var columns = SqlUpdateHelper.ArrangeColumns(dataTable);
var tableName = dataTable.TableName;
return($"UPDATE [{tableName.Trim()}] SET {columns.Trim()} WHERE {SqlPrimaryKeyStringHelper.ArrangeColumnsWithParam(dataTable)};");
}
public static string SelectByPrimaryKey(DataTable dataTable)
{
var columns = SqlSelectHelper.ArrangeColumnsWithComma(dataTable);
var tableName = dataTable.TableName;
return($"SELECT TOP 1 {columns.Trim()} FROM [{tableName.Trim()}] WHERE {SqlPrimaryKeyStringHelper.ArrangeColumnsWithParam(dataTable)};");
}
public static string DeleteByPrimaryKey(DataTable dataTable)
{
var tableName = dataTable.TableName;
return($"DELETE [{tableName.Trim()}] WHERE {SqlPrimaryKeyStringHelper.ArrangeColumnsWithParam(dataTable)};");
}
public static string UpdateColumnByPrimaryKey(DataTable dataTable, DataColumn dataColumn)
{
var tableName = dataTable.TableName;
return($"UPDATE [{tableName.Trim()}] SET {dataColumn.ColumnName.Trim()}=@{dataColumn.ColumnName.Trim()} WHERE {SqlPrimaryKeyStringHelper.ArrangeColumnsWithParam(dataTable)};");
}