public void Add(Election t) { IDbCommand command = _connector.CreateCommand(); command.CommandText = "INSERT INTO [Verkiezing] ([Naam], [AantalZetels]) VALUES (@name, @seats);"; command.AddParameterWithValue("name", t.Name); command.AddParameterWithValue("seats", t.Seats); _connector.ExecuteNonQuery(command); }
public void Add(Party t) { IDbCommand command = _connector.CreateCommand(); command.CommandText = "INSERT INTO [Partij] ([Naam], [Lijsttrekker], [AantalLeden]) VALUES (@name, @partyleader, @members);"; command.AddParameterWithValue("name", t.Name); command.AddParameterWithValue("primeminister", t.PartyLeader); command.AddParameterWithValue("members", t.AmountOfMembers); _connector.ExecuteNonQuery(command); }
public void Add(Results t) { IDbCommand command = _connector.CreateCommand(); command.CommandText = "INSERT INTO [Uitslag] ([VerkiezingID], [Naam], [TotaalStemmen]) VALUES (@electionid, @name, @votes);"; command.AddParameterWithValue("electionid", 1); command.AddParameterWithValue("name", t.Name); command.AddParameterWithValue("votes", t.TotalVotes); _connector.ExecuteNonQuery(command); }
public void Add(Coalition t) { IDbCommand command = _connector.CreateCommand(); command.CommandText = "INSERT INTO [Coalitie] ([Naam], [Premier], [Zetels]) VALUES (@name, @primeminister, @seats);"; command.AddParameterWithValue("name", t.Name); command.AddParameterWithValue("primeminister", t.PrimeMinister); command.AddParameterWithValue("seats", t.Seats); _connector.ExecuteNonQuery(command); }
/// <summary> /// Creates a database command and populates the parameter values. /// </summary> /// <typeparam name="TParameters">The type of a class containing the parameters.</typeparam> /// <param name="connector">The database connector.</param> /// <param name="commandText">The command text.</param> /// <param name="commandType">Type of the command.</param> /// <param name="parameters">The parameter type instance.</param> /// <param name="ignoreProperties">A list with properties to ignore.</param> /// <returns>A database command.</returns> public static IDatabaseCommand CreateCommand <TParameters>(this IDatabaseConnector connector, string commandText, CommandType commandType, TParameters parameters, params string[] ignoreProperties) { var command = connector.CreateCommand(commandText); PopulateCommandParameters(connector, command, parameters, ignoreProperties); return(command); }
/// <summary> /// Initializes a new instance of the <see cref="CommandBatch"/> class. /// </summary> /// <param name="connector">The database connector.</param> public CommandBatch(IDatabaseConnector connector) { this.Connector = connector; this.FormatProvider = connector.GetCommandFormatProvider(); this.Command = connector.CreateCommand(); this.Steps = new List <ICommandBatchStep>(); }
/// <summary> /// Initializes a new instance of the <see cref="CommandBatch"/> class. /// </summary> /// <param name="connector">The database connector.</param> public CommandBatch(IDatabaseConnector connector) { this.Connector = connector; this.FormatProvider = connector.GetCommandFormatProvider(); this.Command = connector.CreateCommand(); this.Steps = new List <ICommandBatchStep>(); this.ParameterRegex = new Regex($"{this.Connector.GetCommandFormatProvider().GetParameterName(string.Empty)}[a-zA-Z][a-zA-Z0-9_]*", RegexOptions.Compiled | RegexOptions.Multiline); }
/// <summary> /// Creates a database command. /// </summary> /// <param name="connector">The database connector.</param> /// <param name="commandText">The command text.</param> /// <returns>A database command.</returns> public static IDatabaseCommand CreateCommand(this IDatabaseConnector connector, string commandText) { var command = connector.CreateCommand(); command.CommandText = commandText; return(command); }
/// <summary> /// Executes a database command as scalar. /// </summary> /// <param name="connector">The database connector.</param> /// <param name="commandText">The database command.</param> /// <param name="action">A callback action to process the scalar value.</param> public static T ExecuteScalar <T>(this IDatabaseConnector connector, string commandText, Func <object, T> action) { connector.OpenMySqlConnectionWhenClose(); using (var command = connector.CreateCommand(commandText)) { return(action(command.ExecuteScalar())); } }
/// <summary> /// Executes a database command as scalar. /// </summary> /// <param name="connector">The database connector.</param> /// <param name="commandText">The database command.</param> /// <param name="action">A callback action to process the scalar value.</param> public static void ExecuteScalar(this IDatabaseConnector connector, string commandText, Action <object> action) { connector.OpenMySqlConnectionWhenClose(); using (var command = connector.CreateCommand(commandText)) { action(command.ExecuteScalar()); } }
/// <summary> /// Executes a database command as non query. /// </summary> /// <param name="connector">The database connector.</param> /// <param name="commandText">The command text.</param> public static void ExecuteNonQuery(this IDatabaseConnector connector, string commandText) { connector.OpenMySqlConnectionWhenClose(); using (var command = connector.CreateCommand(commandText)) { command.ExecuteNonQuery(); } }
/// <summary> /// Executes a database command as scalar. /// </summary> /// <param name="connector">The database connector.</param> /// <param name="commandText">The database command.</param> /// <param name="action">A callback action to process the scalar value.</param> public static async Task <T> ExecuteScalarAsync <T>(this IDatabaseConnector connector, string commandText, Func <object, Task <T> > action) { await connector.OpenMySqlConnectionWhenCloseAsync(); using (var command = connector.CreateCommand(commandText)) { return(await action(await command.ExecuteScalarAsync())); } }
/// <summary> /// Executes a database command as scalar. /// </summary> /// <param name="connector">The database connector.</param> /// <param name="commandText">The database command.</param> /// <param name="action">A callback action to process the scalar value.</param> public static async Task ExecuteScalarAsync(this IDatabaseConnector connector, string commandText, Action <object> action) { await connector.OpenMySqlConnectionWhenCloseAsync(); using (var command = connector.CreateCommand(commandText)) { action(await command.ExecuteScalarAsync()); } }
/// <summary> /// Initializes a new instance of the <see cref="CustomQuery{TResultType}"/> class. /// </summary> /// <param name="connector">The database connector.</param> /// <param name="query">The query.</param> /// <param name="descriptor">The custom type descriptor.</param> public CustomQuery(IDatabaseConnector connector, string query, ICustomTypeDescriptor descriptor) { this.Connector = connector; this.Descriptor = descriptor; this.CommandText = query; this.Command = connector.CreateCommand(); this.Command.CommandText = query; this.Mapper = new DatabaseReaderMapper <TResultType>(connector, descriptor); }
/// <summary> /// Executes a database command as non query. /// </summary> /// <param name="connector">The database connector.</param> /// <param name="commandText">The command text.</param> /// <param name="action">A callback action to process the affected rows quantity.</param> public static async Task ExecuteNonQueryAsync(this IDatabaseConnector connector, string commandText, Func <int, Task> action) { await connector.OpenMySqlConnectionWhenCloseAsync(); using (var command = connector.CreateCommand(commandText)) { await action(await command.ExecuteNonQueryAsync()); } }
/// <summary> /// Creates a database command. /// </summary> /// <typeparam name="TParameters">The type of a class containing the parameters.</typeparam> /// <param name="connector">The databaseconnector.</param> /// <param name="commandText">The command text.</param> /// <param name="commandType">Type of the command.</param> /// <param name="descriptor">A routine type descriptor for the parameters.</param> /// <returns>A database command.</returns> public static IDatabaseCommand CreateCommand <TParameters>(this IDatabaseConnector connector, string commandText, CommandType commandType, IRoutineTypeDescriptor descriptor) { var command = connector.CreateCommand(commandText); command.CommandType = CommandType.StoredProcedure; PopulateCommandParameters(connector, command, descriptor, default(TParameters), null); return(command); }
/// <summary> /// Executes a database command as data reader. /// </summary> /// <param name="connector">The database connector.</param> /// <param name="commandText">The command text.</param> /// <param name="action">A callback action to process the database reader.</param> public static async Task <T> ExecuteReaderAsync <T>(this IDatabaseConnector connector, string commandText, Func <IDatabaseReader, T> action) { await connector.OpenMySqlConnectionWhenCloseAsync(); using (var command = connector.CreateCommand(commandText)) { using (var reader = await command.ExecuteReaderAsync()) { return(action(reader)); } } }
/// <summary> /// Executes a database command as data reader. /// </summary> /// <param name="connector">The database connector.</param> /// <param name="commandText">The command text.</param> /// <param name="action">A callback action to process the database reader.</param> public static async Task ExecuteReaderAsync(this IDatabaseConnector connector, string commandText, Action <IDatabaseReader> action) { await connector.OpenMySqlConnectionWhenCloseAsync(); using (var command = connector.CreateCommand(commandText)) { using (var reader = await command.ExecuteReaderAsync()) { action(reader); } } }
/// <summary> /// Executes a database command as data reader. /// </summary> /// <param name="connector">The database connector.</param> /// <param name="commandText">The command text.</param> /// <param name="action">A callback action to process the database reader.</param> public static void ExecuteReader(this IDatabaseConnector connector, string commandText, Action <IDatabaseReader> action) { connector.OpenMySqlConnectionWhenClose(); using (var command = connector.CreateCommand(commandText)) { using (var reader = command.ExecuteReader()) { action(reader); } } }
/// <summary> /// Executes a database command as data reader. /// </summary> /// <param name="connector">The database connector.</param> /// <param name="commandText">The command text.</param> /// <param name="action">A callback action to process the database reader.</param> public static T ExecuteReader <T>(this IDatabaseConnector connector, string commandText, Func <IDatabaseReader, T> action) { connector.OpenMySqlConnectionWhenClose(); using (var command = connector.CreateCommand(commandText)) { using (var reader = command.ExecuteReader()) { return(action(reader)); } } }
/// <summary> /// Creates a database command. /// </summary> /// <typeparam name="TParameters">The type of a class containing the parameters.</typeparam> /// <param name="connector">The database connector.</param> /// <param name="commandText">The command text.</param> /// <param name="descriptor">The routine type descriptor.</param> /// <returns>A database command.</returns> public static IDatabaseCommand CreateCommand <TParameters>(this IDatabaseConnector connector, string commandText, IRoutineTypeDescriptor descriptor) { return(connector.CreateCommand <TParameters>(commandText, CommandType.StoredProcedure, descriptor)); }
public void AddCardToDeck(Deck deck, Card card) { IDbCommand command = connector.CreateCommand(); command.CommandText = "INSERT INTO deckList (deckID, cardID) VALUES (@deck, @card);"; command.AddParameterWithValue("deck", deck.GetID()); command.AddParameterWithValue("card", card.GetID()); connector.ExecuteNonQuery(command); }
/// <summary> /// Creates a database command and populates the parameter values. /// </summary> /// <typeparam name="TParameters">The type of a class containing the parameters.</typeparam> /// <param name="connector">The database connector.</param> /// <param name="commandText">The command text.</param> /// <param name="commandType">Type of the command.</param> /// <param name="parameters">The parameter type instance.</param> /// <returns>A database command.</returns> public static IDatabaseCommand CreateCommand <TParameters>(this IDatabaseConnector connector, string commandText, CommandType commandType, TParameters parameters) { return(connector.CreateCommand(commandText, parameters, null)); }
/// <summary> /// Creates a database command and populates the parameter values. /// </summary> /// <typeparam name="TParameters">The type of a class containing the parameters.</typeparam> /// <param name="connector">The database connector.</param> /// <param name="commandText">The command text.</param> /// <param name="parameters">The parameter type instance.</param> /// <param name="ignoreProperties">A list with properties to ignore.</param> /// <returns>A database command.</returns> public static IDatabaseCommand CreateCommand <TParameters>(this IDatabaseConnector connector, string commandText, TParameters parameters, params string[] ignoreProperties) { return(connector.CreateCommand(commandText, CommandType.Text, parameters, ignoreProperties)); }
/// <summary> /// Creates a database command. /// </summary> /// <typeparam name="TParameters">The type of a class containing the parameters.</typeparam> /// <param name="connector">The databaseconnector.</param> /// <param name="commandText">The command text.</param> /// <returns>A database command.</returns> public static IDatabaseCommand CreateCommand <TParameters>(this IDatabaseConnector connector, string commandText) { return(connector.CreateCommand(commandText, CommandType.Text, default(TParameters), null)); }