private void ConstructBody() { CSBlock usingBlock = new CSBlock("using (SqlCommand sqlCommand = new SqlCommand())"); string sqlString = $"{Quotes}{SqlDeleteBuilder.DeleteByColumn(datatable, datacolumn)}{Quotes};"; string parameterName = $"{Quotes}@{datacolumn.ColumnName.Replace(" ","")}{Quotes}"; string parameterValue = ProperVarName.Get(datacolumn.ColumnName.ToLower()); usingBlock.Statements.Add($"sqlCommand.CommandText = {sqlString}"); if (datacolumn.AllowDBNull) { parameterValue += " ?? (object)DBNull.Value"; } usingBlock.Statements.Add($"sqlCommand.Parameters.AddWithValue({parameterName}, {parameterValue});"); usingBlock.Statements.Add($"table.DbAccess.Commands.Add(sqlCommand);"); this.Statements.Add(usingBlock.ToString()); }
private void ConstructBody() { VBBlock usingBlock = new VBBlock(VBBlockStatement.Using, "Using sqlCommand As New SqlCommand()"); string sqlString = $"{Quotes}{SqlDeleteBuilder.DeleteByColumn(datatable, datacolumn)}{Quotes}"; string parameterName = $"{Quotes}@{datacolumn.ColumnName.Replace(" ", "")}{Quotes}"; string parameterValue = ProperVarName.Get(datacolumn.ColumnName.ToLower()); usingBlock.Statements.Add($"sqlCommand.CommandText = {sqlString}"); if (datacolumn.AllowDBNull) { parameterValue = $"If({parameterValue}, CType(DBNull.Value, Object))"; } usingBlock.Statements.Add($"sqlCommand.Parameters.AddWithValue({parameterName}, {parameterValue})"); usingBlock.Statements.Add($"table.DbAccess.Commands.Add(sqlCommand)"); this.Statements.Add(usingBlock.ToString()); }