Example #1
0
        private static void CreateAndAddInputParameterInternal(IDbCommand command,
                                                               TableInfo tableInfo, object entity, ColumnInfo columnInfo)
        {
            var parameter = command.CreateParameter();

            parameter.Direction     = ParameterDirection.Input;
            parameter.ParameterName = columnInfo.DataColumnName;
            parameter.DbType        = columnInfo.DbType;
            parameter.Value         = tableInfo.CoalesceValue(columnInfo.Column.GetValue(entity, null));

            TryAddParameterToCollection(command, parameter);
        }
Example #2
0
        public static void CreateAndAddInputParameterForPrimaryKeyValue(this IDbCommand command,
                                                                        TableInfo tableinfo, PrimaryKeyInfo primaryKeyInfo,
                                                                        object value)
        {
            var parameter = command.CreateParameter();

            parameter.Direction     = ParameterDirection.Input;
            parameter.ParameterName = primaryKeyInfo.GetPrimaryKeyName();
            parameter.DbType        = primaryKeyInfo.DbType;
            parameter.Value         = tableinfo.CoalesceValue(value);

            TryAddParameterToCollection(command, parameter);
        }