private void Form1_Load(object sender, EventArgs e)
{
UniversityDB db = new UniversityDB();
db.Software.Add(new Software()
{
Name = "Sql"
});
db.SaveChanges();
}
static void Main(string[] args)
{
var _conn_str = @"data source=localhost\SQLEXPRESS;initial catalog=University;integrated security=True;MultipleActiveResultSets=True";
//Console.ReadKey();
using (var _conn = new SqlConnection(_conn_str))
{
_conn.Open();
var s = _conn.Query <Student>("Select * FROM Students");
var tempStudent = s.First(x => x.Name == "Muradxan");
var querry = @"Update Students Set [Name]=@Name where Id = @Id";
_conn.Execute(querry, new { Name = "BurdaAdDeyisdi", Id = tempStudent.Id });
//var querry = "INSERT INTO Groups VALUES (@Name)";
//_conn.Execute(querry,group);
// var group = _conn.Query<Group>("SELECT * FROM Groups");
// var student = new Student() { Name="Muradxan", Surname="Novruzov", Group=group.FirstOrDefault()
// var querry = "INSERT INTO Students Values(@Name,@Surname,@Id)";
// _conn.Execute(querry,new{student.Name, student.Surname, student.Group.Id });
// var querry = @"SELECT * FROM Students ORDER BY Id; SELECT * FROM Groups;SELECT Group_Id FROM Students ORDER BY Id;";
// var st = _conn.QueryMultiple(querry);
// var s = st.Read<Student>().ToList();
// var g = st.Read<Group>().ToList();
// var gId = st.Read<int>().ToList();
// for (int i = 0; i < s.Count; i++)
// {
// foreach (var group in g)
// {
// if (gId[i]== group.Id)
// {
// s[i].Group = group;
// }
// }
// }
// foreach (var student in s)
// {
// Console.WriteLine(student + student.Group.Name);
// }
//var newSql = @"SELECT * FROM Students JOIN Groups ON Group_Id = Students.Group_Id";
//var oldSql = @"SELECT * FROM Students";
//var gd = new Dictionary<int, Group>();
//var sd = new Dictionary<int, Student>();
//var st = _conn.Query<Student,Group,Student>(
// newSql, (s,g) =>
// {
// Group gTemp;
// if (!gd.ContainsKey(g.Id))
// {
// gTemp = g;
// gd.Add(g.Id, g);
// }
// else
// {
// gTemp = gd[g.Id];
// }
// s.Group = gTemp;
// if(!sd.ContainsKey(s.Id))
// {
// sd.Add(s.Id, s);
// return s;
// }
// else
// {
// return sd[s.Id];
// }
// }).Distinct().ToList();
//Console.WriteLine(st[0].Group.Name);
//st.ForEach(Console.WriteLine);
}
Console.ReadKey();
using (UniversityDB db = new UniversityDB())
{
db.Students.ToList().ForEach(Console.WriteLine);
//var g = db.Groups.FirstOrDefault();
////var g = db.Groups.Include("Students").FirstOrDefault();
////db.Entry(g).Collection(x => x.Teachers).Load();
////Console.WriteLine(g.Name);
//g.Students.ForEach(Console.WriteLine);
//g.Teachers.ForEach(Console.WriteLine);
//db.Entry(g).State = System.Data.Entity.EntityState.Modified;
//db.Database.ExecuteSqlCommand("");
//foreach (var teacher in g.Teachers)
//{
// Console.WriteLine(teacher.Groups.Count);
//}
//foreach (var student in g.Students)
//{
// Console.WriteLine(student.Name);
// Console.WriteLine(student.Group.Name);
//}
}
}
