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;
}
