public void Execute(string AStatement, SQLParameters AParameters) { CheckConnectionValid(); using (SQLCommand LCommand = CreateCommand()) { LCommand.Statement = AStatement; LCommand.Parameters.AddRange(AParameters); LCommand.Execute(); } }
public void Execute(string statement, SQLParameters parameters) { CheckConnectionValid(); using (SQLCommand command = CreateCommand(false)) { command.Statement = statement; command.Parameters.AddRange(parameters); command.Execute(); } }
public SQLCursor Open(string AStatement, SQLParameters AParameters, SQLCursorType ACursorType, SQLIsolationLevel ACursorIsolationLevel, SQLCommandBehavior ABehavior) { CheckConnectionValid(); SQLCommand LCommand = CreateCommand(); try { LCommand.Statement = AStatement; LCommand.Parameters.AddRange(AParameters); LCommand.CommandBehavior = ABehavior; return(LCommand.Open(ACursorType, ACursorIsolationLevel)); } catch { LCommand.Dispose(); throw; } }
public SQLCursor Open(string statement, SQLParameters parameters, SQLCursorType cursorType, SQLIsolationLevel cursorIsolationLevel, SQLCommandBehavior behavior) { CheckConnectionValid(); SQLCommand command = CreateCommand(true); try { command.Statement = statement; command.Parameters.AddRange(parameters); command.CommandBehavior = behavior; return(command.Open(cursorType, cursorIsolationLevel)); } catch { command.Dispose(); throw; } }