Removed new() constraint for P

7k8m · 7k8m · commit dc8d8e0a52d9 · 2020-08-09T19:19:59.000+09:00
diff --git a/DirectSQL/Database.cs b/DirectSQL/Database.cs
@@ -60,8 +60,7 @@ public delegate void ReadSqlResult<R,CMD,T,C,P>(SqlResult<R,CMD,T,C,P> result)
         where R : IDataReader 
         where T : IDbTransaction 
         where C : IDbConnection 
-        where P : IDataParameter,
-        new();
+        where P : IDataParameter;
 
     /// <summary>
     /// Database class is entry point of DirectSQL library.
@@ -76,8 +75,7 @@ public abstract class Database<C,T,CMD,R,P>
         where T : IDbTransaction 
         where CMD : IDbCommand 
         where R : IDataReader 
-        where P : IDataParameter,
-        new()
+        where P : IDataParameter
     {
         /// <summary>
         /// Asynchronous process with a connection
@@ -781,12 +779,20 @@ private static (String sql, (String,Object)[] parameters) ExtractSqlAndParam(For
 
         public static P CreateParameter(string name, object value)
         {
-            return new P() { ParameterName = name, Value = value };
+            var paramType = typeof(P);
+            var constructor = paramType.GetConstructor(new Type[0]);
+            P param = (P) constructor.Invoke(new object[0]);
+            param.ParameterName = name;
+            param.Value = value;
+
+            return param;
         }
 
         public static P CreateParameter(string name, object value, DbType type)
         {
-            return new P() { ParameterName = name, Value = value, DbType = type };
+            var param = CreateParameter(name,value);
+            param.DbType = type;
+            return param;
         }
 
         public static P[] ConvertToDbParameter((String name,Object value)[] tuples)
diff --git a/DirectSQL/SqlResult.cs b/DirectSQL/SqlResult.cs
@@ -22,8 +22,7 @@ public class SqlResult<R,CMD,T,C,P>:EnumerableObject<dynamic>,IDisposable
         where CMD : IDbCommand 
         where T : IDbTransaction 
         where C : IDbConnection 
-        where P : IDataParameter, 
-        new()
+        where P : IDataParameter
     {
         private R _reader;
         private CMD _command;
