private SqlCommand SetUpCommand(string query, IEnumerable<Argument> parameters, VirtualOfficeContext context) { using (SqlCommand cmd = (SqlCommand)context.Database.Connection.CreateCommand()) { context.Database.Connection.Open(); cmd.CommandText = query; cmd.CommandType = CommandType.StoredProcedure; foreach (Argument arg in parameters) { cmd.Parameters.AddWithValue(arg.Param.Name, arg.Value); } return cmd; } }
public SqlQueryExecutor(ILogger logger, VirtualOfficeContext context) { _context = context; }