Support generating NULL sql parameters for null properties

developer82 · developer82 · commit 1450fb60e5f9 · 2017-02-11T23:04:55.000+02:00
diff --git a/Poco.Sql.NetCore/ValuesObject.cs b/Poco.Sql.NetCore/ValuesObject.cs
@@ -48,7 +48,14 @@ PropertyInfo propertyInfo in
                         if (propertyInfo.PropertyType == typeof (DateTime) && (DateTime) val == DateTime.MinValue)
                             val = (DateTime) System.Data.SqlTypes.SqlDateTime.MinValue;
 
-                        objDic.Add(propertyInfo.Name, val);
+                        if (val == null)
+                        {
+                            objDic.Add(propertyInfo.Name, DBNull.Value);
+                        }
+                        else
+                        {
+                            objDic.Add(propertyInfo.Name, val);
+                        }
                     }
                 }
             }

Original file line number	Diff line number	Diff line change
`@@ -48,7 +48,14 @@ PropertyInfo propertyInfo in`
`48`	`48`	`if (propertyInfo.PropertyType == typeof (DateTime) && (DateTime) val == DateTime.MinValue)`
`49`	`49`	`val = (DateTime) System.Data.SqlTypes.SqlDateTime.MinValue;`
`50`	`50`
`51`		`- objDic.Add(propertyInfo.Name, val);`
	`51`	`+ if (val == null)`
	`52`	`+ {`
	`53`	`+ objDic.Add(propertyInfo.Name, DBNull.Value);`
	`54`	`+ }`
	`55`	`+ else`
	`56`	`+ {`
	`57`	`+ objDic.Add(propertyInfo.Name, val);`
	`58`	`+ }`
`52`	`59`	`}`
`53`	`60`	`}`
`54`	`61`	`}`