public async Task <IActionResult> Create([Bind("FirstName,LastName,EMail,Course,UniversityID,Answers")] Student student)
{
if (ModelState.IsValid)
{
_context.Add(student);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(student));
}
public async Task <IActionResult> Create([Bind("ID,QuestionContents,HasOptions,MultipleSelect,Options")] Question question)
{
if (ModelState.IsValid)
{
_context.Add(question);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(question));
}
public async Task <IActionResult> Create([Bind("UniversityID,UniversityName,UniversityPoints")] University university)
{
if (ModelState.IsValid)
{
_context.Add(university);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(university));
}
static async Task Main(string[] args)
{
const string connection_str = @"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=Students.DB;Integrated Security=True";
//var service_collection = new ServiceCollection();
//service_collection.AddDbContext<StudentsDB>(opt => opt.UseSqlServer(connection_str));
//var services = service_collection.BuildServiceProvider();
//new DbContextOptionsBuilder().sq
//new StudentsDB()
//using (var db = services.GetRequiredService<StudentsDB>())
//{
//}
using (var db = new StudentsDB(new DbContextOptionsBuilder <StudentsDB>().UseSqlServer(connection_str).Options))
{
//await db.Database.EnsureCreatedAsync();
await db.Database.MigrateAsync();
var students_count = await db.Students.CountAsync();
Console.WriteLine("Число студентов в БД = {0}", students_count);
}
using (var db = new StudentsDB(new DbContextOptionsBuilder <StudentsDB>().UseSqlServer(connection_str).Options))
{
var k = 0;
if (await db.Students.CountAsync() == 0)
{
for (var i = 0; i < 10; i++)
{
var group = new Group
{
Name = $"Группа {i}",
Description = $"Описание группы {i}",
Students = new List <Student>()
};
for (var j = 0; j < 10; j++)
{
var student = new Student
{
Name = $"Студент {k}",
Surname = $"Surname {k}",
Patronymic = $"Patronymic {k}",
//Description = $"Description {k}"
};
k++;
group.Students.Add(student);
}
await db.Groups.AddAsync(group);
}
await db.SaveChangesAsync();
}
}
using (var db = new StudentsDB(new DbContextOptionsBuilder <StudentsDB>().UseSqlServer(connection_str).Options))
{
var students = await db.Students.
Include(s => s.Group).
Where(s => s.Group.Name == "Группа 5").
ToArrayAsync();
foreach (var student in students)
{
Console.WriteLine("[{0}] {1} - {2}", student.Id, student.Name, student.Group.Name);
}
}
Console.WriteLine("Главный поток работу закончил!");
Console.ReadLine();
}