public void OnGet() { var optionsBuilder = new DbContextOptionsBuilder <KnowledgeShareDbContext>(); optionsBuilder.UseSqlServer(Configuration.GetConnectionString("KnowledgeShareDbContext")); using (var context = new KnowledgeShareDbContext(optionsBuilder.Options)) { this.Questions = context.Questions.Select(x => x).ToList(); this.Answers = context.Questions.Where(x => x.QuestionId == 1).SelectMany(x => x.Answers).ToList(); } }
public async Task ConnectUser(string username) { var connectedUsers = new List <ConnectedUser>(); var optionsBuilder = new DbContextOptionsBuilder <KnowledgeShareDbContext>(); optionsBuilder.UseSqlServer(Configuration.GetConnectionString("KnowledgeShareDbContext")); using (var context = new KnowledgeShareDbContext(optionsBuilder.Options)) { connectedUsers = await context.ConnectedUsers.ToListAsync(); } await Clients.All.SendAsync("UserConnected", JsonConvert.SerializeObject(connectedUsers)); }
public void OnPost() { var userName = Request.Form["UserName"]; if (!string.IsNullOrWhiteSpace(userName)) { this.UserName = userName; var optionsBuilder = new DbContextOptionsBuilder <KnowledgeShareDbContext>(); optionsBuilder.UseSqlServer(Configuration.GetConnectionString("KnowledgeShareDbContext")); using (var context = new KnowledgeShareDbContext(optionsBuilder.Options)) { context.ConnectedUsers.Add(new Models.ConnectedUser { UserName = userName }); context.SaveChanges(); } } }
public KnowledgeShareRHub(IConfiguration configuration, KnowledgeShareDbContext dbContext) { Configuration = configuration; _db = dbContext; }
public MessageModel(ILogger <IndexModel> logger, IConfiguration configuration, KnowledgeShareDbContext dbContext) { _logger = logger; Configuration = configuration; _db = dbContext; }