static void Main(string[] args)
{
QuestionDbContext qContext = new QuestionDbContext(new DbContextOptionsBuilder <QuestionDbContext>()
.UseSqlServer("connectionString")
.Options);
var questions = qContext.SampleQuestions.AsNoTracking(); // not elegant, but it will work
}
public IActionResult ForgotPassword()
{
var options = new DbContextOptionsBuilder <QuestionDbContext>();
options.UseSqlServer("Server=tcp:cimobdb.database.windows.net,1433;Initial Catalog=CimobY;Persist Security Info=False;User ID=admincimob;Password=@dmincimob1;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;");
var _context = new QuestionDbContext(options.Options);
ViewBag.Question = _context.Questions.ToList <Question>();
return(View());
}
public TeamManagmentModel(
UserManager <ApplicationUser> userManager,
SignInManager <ApplicationUser> signInManager,
ILogger <TeamManagmentModel> logger,
QuestionDbContext questionDbContext)
{
_questionDbContext = questionDbContext;
_userManager = userManager;
_signInManager = signInManager;
_logger = logger;
}
public IActionResult Register(string returnUrl = null)
{
var options = new DbContextOptionsBuilder <QuestionDbContext>();
options.UseSqlServer("Server=tcp:cimobdb.database.windows.net,1433;Initial Catalog=CimobY;Persist Security Info=False;User ID=admincimob;Password=@dmincimob1;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;");
var _context = new QuestionDbContext(options.Options);
var poptions = new DbContextOptionsBuilder <ProfileTypeDbContext>();
poptions.UseSqlServer("Server=tcp:cimobdb.database.windows.net,1433;Initial Catalog=CimobY;Persist Security Info=False;User ID=admincimob;Password=@dmincimob1;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;");
var _pcontext = new ProfileTypeDbContext(poptions.Options);
//IList<Question> questionList = r.Question.ToList<Question>();
ViewBag.Question = _context.Questions.ToList <Question>();
ViewBag.ProfileType = _pcontext.ProfileTypes.ToList <ProfileType>();
ViewData["ReturnUrl"] = returnUrl;
return(View());
}
public RoundController(QuestionDbContext context, UserManager <ApplicationUser> userManager)
{
_userContext = userManager;
_context = context;
}
public AnswerController(QuestionDbContext context, IConfiguration configuration) :
base(context, configuration)
{
}
public BaseController(QuestionDbContext context,
IConfiguration configuration)
{
DbContext = context;
}
public QuestionsController(QuestionDbContext context)
{
_context = context;
}
