static void AddData() { using (var pgdb = new NpgsqlDbContext()) { var students = new[] { new Student { Name = "Lee", Code = "125" }, new Student { Name = "Mao", Code = "777" }, new Student { Name = "Liu", Code = "345" } }; pgdb.Students.AddRange(students); pgdb.SaveChanges(); } }
static void QueryData() { using (var pgdb = new NpgsqlDbContext()) { var nameClause = $"%L%"; var students = pgdb.Students.Where(c => DbFunctions.Like(c.Name, nameClause)).ToList(); if (students.Any()) { Console.WriteLine("get data success"); } } }
public AccountController(UserManager <ApplicationUser> userManager, SignInManager <ApplicationUser> signInManager, ApplicationRoleManager roleManager, NpgsqlDbContext dbContext, IConfiguration configuration, IUnitOfWork unitOfWork, IEmailSender emailSender) { _userManager = userManager; _signInManager = signInManager; _roleManager = roleManager; _dbContext = dbContext; _configuration = configuration; _emailSender = emailSender; _unitOfWork = unitOfWork; }
public NpsqlCalendarEventRepository(NpgsqlDbContext context) { _context = context; }
public NpsqlAttachedFileRepository(NpgsqlDbContext context) { _context = context; }
public NpsqlPositionRepository(NpgsqlDbContext context) { _context = context; }
public NpsqlCompanyRepository(NpgsqlDbContext context) { _context = context; }
public NpsqlCompanyNotificationRepository(NpgsqlDbContext context) { _context = context; }
public NpsqlChatMessageParticipantRepository(NpgsqlDbContext context) { _context = context; }
public NpsqlRegistrationRequestRepository(NpgsqlDbContext context) { _context = context; }
public NpsqlDepartmentRepository(NpgsqlDbContext context) { _context = context; }
public NpsqlShortLinkRepository(NpgsqlDbContext context) { _context = context; }
public NpsqlPrivateNotificationRepository(NpgsqlDbContext context) { _context = context; }
public NpsqlTaskNotificationRepository(NpgsqlDbContext context) { _context = context; }
public NpsqlUnitOfWork(NpgsqlDbContext context) { _context = context; }
public NpsqlTaskRepository(NpgsqlDbContext context) { _context = context; }
public NpsqlEmployeeInvitationRepository(NpgsqlDbContext context) { _context = context; }
public NpsqlChatRepository(NpgsqlDbContext context) { _context = context; }
public NpsqlApplicationUserRepository(NpgsqlDbContext context) { _context = context; }
public NpsqlFilePublickLinkRepository(NpgsqlDbContext context) { _context = context; }