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