從 PL/SQL Developer、SQL Developer 複製單欄查詢結果 (每行一值) 後,需快速轉為 C# 字典初始化語法:{1, "值1"}, {2, "值2"}, ...。本文提供一個小工具方法處理換行、空白、逸出。
public static string ConvertColumnToDictionaryInit(string rawColumnText, string keyPrefix = "", string valueQuote = "\"")
{
if (string.IsNullOrWhiteSpace(rawColumnText)) return string.Empty;
var lines = rawColumnText.Split(new[] { "\r\n", "\r", "\n" }, StringSplitOptions.RemoveEmptyEntries);
var sb = new StringBuilder();
for (int i = 0; i < lines.Length; i++)
{
string val = lines[i].Trim();
if (string.IsNullOrEmpty(val)) continue;
// 逸出雙引號、反斜線
val = val.Replace("\\", "\\\\").Replace(valueQuote, "\\" + valueQuote);
sb.Append($"{{{keyPrefix}{i + 1}, {valueQuote}{val}{valueQuote}}},");
}
if (sb.Length > 0) sb.Length--; // 移除最後逗號
return sb.ToString();
}
string plsqlOutput = @"
陳大文
林小美
王建國
";
string dictInit = ConvertColumnToDictionaryInit(plsqlOutput);
// 結果: {1, "陳大文"},{2, "林小美"},{3, "王建國"}
// 直接貼上程式碼
var dict = new Dictionary
{
{1, "陳大文"},
{2, "林小美"},
{3, "王建國"}
};
public static string ConvertToCollectionInit(
string rawText,
Func keySelector,
Func valueSelector,
string keyFormat = "{0}",
string valueFormat = "\"{0}\"")
{
var lines = rawText.Split(new[] { "\r\n", "\r", "\n" }, StringSplitOptions.RemoveEmptyEntries);
var sb = new StringBuilder();
for (int i = 0; i < lines.Length; i++)
{
string val = lines[i].Trim();
if (string.IsNullOrEmpty(val)) continue;
var key = keySelector(i + 1, val);
var value = valueSelector(val);
sb.Append($"{{{string.Format(keyFormat, key)}, {string.Format(valueFormat, value)}}},");
}
if (sb.Length > 0) sb.Length--;
return sb.ToString();
}
// 使用:Key 為 Guid、Value 為 int
string result = ConvertToCollectionInit(
rawText,
(idx, val) => Guid.NewGuid(),
val => val.GetHashCode(),
keyFormat: "Guid.Parse(\"{0}\")",
valueFormat: "{0}"
);
&PL/SQL 欄位轉字典cmd.exe/c powershell -sta -command "add-type -assemblyname System.Windows.Forms; $t=[System.Windows.Forms.Clipboard]::GetText(); $r=$t -split '[\r\n]+' | where{$_.Trim()} | select -first 1000 | %{'{'+(++$i)+',\"'+$_.Trim().Replace('\"','\\\"')+'\"},'}; [System.Windows.Forms.Clipboard]::SetText(($r -join '').TrimEnd(','))"複製 PL/SQL 結果 → 點選工具 → 貼上即得字典初始化碼。