Пример #1
0
        public IPathNode SetItem(IContext context, string path, object value)
        {
            var factory = new DynamicParametersFactory(_context, _record.Table.TableName);

            //TODO: invert sql generation and parameter snooping to update only specified fields
            var cmd = factory.ToUpdate();

            context.WriteVerbose("UPDATE SQL: " + cmd.CommandText);
            
            factory.Parameterize(cmd, PrimaryKey, value, context.DynamicParameters as RuntimeDefinedParameterDictionary);

            cmd.ExecuteNonQuery();
            return GetNodeValue();
        }
Пример #2
0
        public IPathNode SetItem(IContext context, string path, object value)
        {
            var factory = new DynamicParametersFactory(_context, _record.Table.TableName);

            //TODO: invert sql generation and parameter snooping to update only specified fields
            var cmd = factory.ToUpdate();

            context.WriteVerbose("UPDATE SQL: " + cmd.CommandText);

            factory.Parameterize(cmd, PrimaryKey, value, context.DynamicParameters as RuntimeDefinedParameterDictionary);

            cmd.ExecuteNonQuery();
            return(GetNodeValue());
        }