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