static void Main(string[] args) { StudentsDB studentsDB = new StudentsDB(); //Console.WriteLine(studentsDB.ConnectionString); try { //studentsDB.SelectDB("SELECT * FROM Persons;"); Person person = new Person { LastName = "Miller", FirstName = "Glenn", Birthday = new DateTime(1997, 6, 18), GroupId = 2 }; //добавили нашего студента //studentsDB.PersonInsert(person); //посмотрели нашего студента //studentsDB.SelectDB("SELECT * FROM Persons;"); studentsDB.PersonDelete(7); studentsDB.SelectDB("SELECT * FROM Persons;"); Console.WriteLine(studentsDB.RecordCount("Persons")); } catch (Exception ex) { Console.WriteLine(ex.Message); } Console.ReadKey(); }
static void Main(string[] args) { StudentsDB studentsDB = new StudentsDB(); //Console.WriteLine(studentsDB.ConnectionString); try { //studentsDB.SelectDB("SELECT * FROM Persons;"); Person person = new Person { LastName = "Lansakaya", FirstName = "Natalina", Birthday = new DateTime(1986, 2, 14), GroupId = 1 }; //добавили нашего студента studentsDB.PersonInsert(person); //посмотрели нашего студента //studentsDB.SelectDB("SELECT * FROM Persons;"); //studentsDB.PersonDelete(7); studentsDB.PersonUpdate(8, "Beam"); studentsDB.SelectDB("SELECT * FROM Persons;"); Console.WriteLine(studentsDB.RecordCount("Persons")); } catch (Exception ex) { Console.WriteLine(ex.Message); } Console.ReadKey(); }