private object ExecuteLinqNonQuery(EntitySession session, LinqCommand command, DataConnection conn) { var sql = SqlFactory.GetLinqSql(command); var fmtOptions = command.Options.IsSet(QueryOptions.NoParameters) ? SqlGenMode.NoParameters : SqlGenMode.PreferParam; var cmdBuilder = new DataCommandBuilder(this._driver); cmdBuilder.AddLinqStatement(sql, command.ParamValues); var dataCmd = cmdBuilder.CreateCommand(conn, DbExecutionType.NonQuery, sql.ResultProcessor); ExecuteDataCommand(dataCmd); return(dataCmd.ProcessedResult ?? dataCmd.Result); }
protected void AddScheduledCommands(IList <LinqCommand> commands) { if (commands == null || commands.Count == 0) { return; } foreach (var lcmd in commands) { CheckCurrentCommand(); var sql = _sqlFactory.GetLinqSql(lcmd); _commandBuilder.AddLinqStatement(sql, lcmd.ParamValues); }//foreach schCmd }
public object ExecuteLinqSelect(EntitySession session, LinqCommand command, DataConnection conn) { var sql = SqlFactory.GetLinqSql(command); var genMode = command.Options.IsSet(QueryOptions.NoParameters) ? SqlGenMode.NoParameters : SqlGenMode.PreferParam; var cmdBuilder = new DataCommandBuilder(this._driver, batchMode: false, mode: genMode); cmdBuilder.AddLinqStatement(sql, command.ParamValues); var dataCmd = cmdBuilder.CreateCommand(conn, DbExecutionType.Reader, sql.ResultProcessor); ExecuteDataCommand(dataCmd); return(dataCmd.ProcessedResult); }