1 files changed, 41 insertions, 0 deletions
diff --git a/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/DynamicParametersExtensions.cs b/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/DynamicParametersExtensions.cs
new file mode 100644
index 0000000..956206d
--- /dev/null
+++ b/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/DynamicParametersExtensions.cs
@@ -0,0 +1,41 @@
+using System.Data;
+using System.Diagnostics;
+using Dapper;
+
+namespace CrupestApi.Commons.Crud;
+
+public static class DynamicParametersExtensions
+{
+    private static Random random = new Random();
+    private const string chars = "abcdefghijklmnopqrstuvwxyz";
+
+    public static string GenerateRandomKey(int length)
+    {
+        lock (random)
+        {
+            var result = new string(Enumerable.Repeat(chars, length)
+                .Select(s => s[random.Next(s.Length)]).ToArray());
+            return result;
+        }
+    }
+
+    public static string GenerateRandomParameterName(DynamicParameters parameters)
+    {
+        var parameterName = GenerateRandomKey(10);
+        int retryTimes = 1;
+        while (parameters.ParameterNames.Contains(parameterName))
+        {
+            retryTimes++;
+            Debug.Assert(retryTimes <= 100);
+            parameterName = GenerateRandomKey(10);
+        }
+        return parameterName;
+    }
+
+    public static string AddRandomNameParameter(this DynamicParameters parameters, object? value)
+    {
+        var parameterName = GenerateRandomParameterName(parameters);
+        parameters.Add(parameterName, value);
+        return parameterName;
+    }
+}