1 files changed, 13 insertions, 0 deletions
diff --git a/docker/crupest-api/CrupestApi/CrupestApi.Commons/DatabaseHelper.cs b/docker/crupest-api/CrupestApi/CrupestApi.Commons/DatabaseHelper.cs
new file mode 100644
index 0000000..9eb6a08
--- /dev/null
+++ b/docker/crupest-api/CrupestApi/CrupestApi.Commons/DatabaseHelper.cs
@@ -0,0 +1,13 @@
+namespace CrupestApi.Commons;
+
+
+public static class DatabaseHelper
+{
+    public static string GenerateUpdateColumnString(this IEnumerable<string> updateColumnList, IEnumerable<KeyValuePair<string, string>>? paramNameMap = null)
+    {
+        paramNameMap = paramNameMap ?? Enumerable.Empty<KeyValuePair<string, string>>();
+        var paramNameDictionary = new Dictionary<string, string>(paramNameMap);
+
+        return string.Join(", ", updateColumnList.Select(x => $"{x} = @{paramNameDictionary.GetValueOrDefault(x) ?? x}"));
+    }
+}
+\ No newline at end of file